C#

Member 2458467 wrote:

I use the label control to debug the program instead of the Debug.Print("..."), I think the label control doesn't affect as you say.

for (int i = 1; i < 20000000; i++)
    label1.Text = i.ToString();

Member 2458467 wrote:

you say: "i never use the value of the Random so it's never being painted anywhere." What do I use to generate random numbers ?

public class Form1 : Form
{
    private Random RNG = new Random();
.
.
.
    private void SomeMethod()
    {
        ...
        int x = RNG.Next(10000);
        ...
    }
}

Member 2458467 wrote:

you say: "Form_Paint is a bit much for this. I'd create a Control specifically for the purpose ..." I haven't seen you create a Control specifically posted by you for everyone to see ?

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?