Password CAPS not Checking in my code

N Mohamed rafi

I saved my password in CAPS includes but if i enter in small letters its also logged in how to change it?

private void button14_Click(object sender, EventArgs e)
{
if (textBox9.Text != "" && textBox10.Text != "")
{
string connectionString;
MySqlConnection cnn;
connectionString = @"Data Source=localhost;Initial Catalog=testDB;User ID=root;Password=mysql";
cnn = new MySqlConnection(connectionString);
string id = textBox9.Text;
string password = textBox10.Text;
textBox9.Text = "";
textBox10.Text = "";
string query = "select count(*) from login where userid=@userid and password=@password";
using (MySqlCommand cmd = new MySqlCommand(query))
{
cmd.Parameters.AddWithValue("@userid", id);
cmd.Parameters.AddWithValue("@password", password);
cmd.Connection = cnn;
cnn.Open();
cmd.ExecuteNonQuery();
int result = Convert.ToInt32(cmd.ExecuteScalar());
DialogResult dr = MessageBox.Show("Are you sure to Login now?", "Confirmation", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes && result > 0)
{
MessageBox.Show("Login Successfully");
cnn.Close();
this.Hide();
Form2 f2 = new Form2();
f2.ShowDialog();
}
else
{
MessageBox.Show("Login Failed");
}
}
}
else
{
MessageBox.Show("Please Enter Correct Login details");
}

}
}

OriginalGriff

There is no point in answering this: you haven't listened to a thing we said in reply to any of your other questions: you are just copy'n'pasting junk code without thinking about it at all and relying on others to fix it for you. You aren't learning anything from us; you aren't even trying. All you are doing is becoming a Help Vampire who wastes our time. Go away, get a book, and start learning how to code properly: copy'n'paste'n'hope is not a valid development method.

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!

N Mohamed rafi

ok provide solution and article link pls

OriginalGriff

Again, you are ignoring everything we tell you ...

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony "Common sense is so rare these days, it should be classified as a super power" - Random T-shirt AntiTwitter: @DalekDave is now a follower!

Dave Kreskowiak

You've already been given those links, and you're STILL ignoring them.

Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles.
Dave Kreskowiak

N Mohamed rafi

Please provide solution or idea

Dave Kreskowiak

All this time and you still don't get it. You've already been given all the links to read to figure this out. You just refuse to do the work yourself.

Asking questions is a skill CodeProject Forum Guidelines Google: C# How to debug code Seriously, go read these articles.
Dave Kreskowiak