C#

OriginalGriff wrote:

He's on second.
Who's on first, I don't know is on third.

public List<string> GetAnswers(string question) {
	List<string> answers=new List<string>();
	string connectionString=@"SERVER=localhost;DATABASE=myDatabase;UID=me;PASSWORD=1234;";
	try {
		using (MySqlConnection dbCon=new MySqlConnection(connectionString)) {
			dbCon.Open();
			// to avoid someone starting a lecture about SQLinjection:
			question=question.Split(';')[0];
			string query="SELECT answer FROM AnswersToAllQuestions "+
				" WHERE question LIKE '%"+question+"%'";
			using (MySqlCommand dbCmd=new MySqlCommand(query, dbCon)) {
				using (MySqlDataReader reader=dbCmd.ExecuteReader()) {
					while (reader.Read()) {
						string answer=(string)reader["answer"];
						answers.Add(answer);
					}
				}
			}
			dbCon.Close();
		}
	} catch (Exception exc) {
		Console.WriteLine(exc.ToString());
	}
	return answers;
}

Luc Pattyn wrote:

C#

// to avoid someone starting a lecture about SQLinjection:
question=question.Split(';')[0];
string query="SELECT answer FROM AnswersToAllQuestions "+
    " WHERE question LIKE '%"+question+"%'";

using (MySqlConnection dbCon=new MySqlConnection(connectionString)) {
    dbCon.Open();
    
    const string query = "SELECT answer FROM AnswersToAllQuestions WHERE question LIKE '%' + @question + '%'";
    
    using (MySqlCommand dbCmd = new MySqlCommand(query, dbCon)) {
        // Do the right thing, Luc!
        dbCmd.Parameters.AddWithValue("@question", question);
        
        using (MySqlDataReader reader = dbCmd.ExecuteReader()) {
            while (reader.Read()) {
                string answer = (string)reader["answer"];
                answers.Add(answer);
            }
        }
    }
}

const string query = "SELECT answer FROM AnswersToAllQuestions WHERE question LIKE @question";    
    using (MySqlCommand dbCmd = new MySqlCommand(query, dbCon)) {
        dbCmd.Parameters.AddWithValue("@question", "%"+question+"%");

Super Lloyd wrote:

But now if fails

Super Lloyd wrote:

maybe the sysadmin change some AD setting?

catch (System.UnauthorizedAccessException uax)
{
    if (uax.Message.Contains("$Recycle.Bin"))
    {
        // ignore trashcan
    }
}

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

exception handler does not work. And I don't know how to use object.ForEach.

I have also tried to use LINQ like this but it does work.

string[] originalFiles = Directory.GetFiles(sourceFolder, "*", SearchOption.AllDirectories).Where(f => !f.Contains("System Volume Information").ToString())

Is it possible in this case to use LINQ?

Member 14055879 wrote:

exception handler does not work.

Member 14055879 wrote:

And I don't know how to use object.ForEach.

Member 14055879 wrote:

Is it possible in this case to use LINQ?

public Form1()
{
    InitializeComponent();
    string[] originalFiles = GetNonSystemFiles(@"C:\");
    foreach (string originalFileLocation in originalFiles)
    {
        // stuff
    }
}

string[] GetNonSystemFiles(string path)
{
    DirectoryInfo di = new DirectoryInfo(path);

    // reserve list for result
    List<string> result = new List<string>();

    // get folders
    IEnumerable<DirectoryInfo> folders = null;
    try
    {
        folders = di.EnumerateDirectories("*", SearchOption.TopDirectoryOnly);
    }
    catch (System.UnauthorizedAccessException uax)
    {
        System.Diagnostics.Debug.WriteLine("Unauthorized folder for: {0}, ex: {1}", di.Name, uax.Message);
    }

    if (null != folders)
        foreach (DirectoryInfo folder in folders)
        {
            result.Add(folder.FullName);

            // get this folders' contents and add it to the result too
            if ((folder.Attributes & FileAttributes.System) != FileAttributes.System // skip system folders
            && (folder.Attributes & FileAttributes.Hidden) != FileAttributes.Hidden) // skip hidden folders
                result.AddRange(GetNonSystemFiles(folder.FullName).ToList());
        }

    // get files for this folder
    IEnumerable<FileInfo> fileInfos = null;
    try
    {
        fileInfos = di.EnumerateFiles("*", SearchOption.TopDirectoryOnly);
    }
    catch (UnauthorizedAccessException uax)
    {
        System.Diagnostics.Debug.WriteLine("Unauthorized file for: {0}, ex: {1}", di.Name, uax.Message);
    }
    if (fileInfos != null)
        foreach (FileInfo fileInfo in fileInfos)
        {
            result.Add(fileInfo.FullName);
        }

    return result.ToArray();
}

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.