Hi
I just want to know is there any function which simply ignores the case of a string values. I mean I have some values stored in database which is a mixture of lower and upper cases. Now in a form I have one textbox which accepts some string value and a button called "search". Upon clicking on the search button the textbox value should be taken and be compared with the value in the database. If it matches then a messagebox will popup saying successful else failure. Friends when I did this if the cases entered in the textbox exactly matches the value in the database then it shows success message otherwise even if the spelling is correct it shows unsuccessful because of cases. So is there any method to ignore the case as soon as the value in the textbox entered.
Thanks
Loading
Niradhip ChakrabortyPosted Sep 1, 2009, 9:46 AM
string strData = "1"; // assign the value here from database
if (strData.ToLower() == txtPassword.Text.ToLower())
{
//correct password
}
else
{
//wrong password
}
Kirtan PatelPosted Sep 1, 2009, 9:22 AM
You can achieve this by Converting both String's Case to same lower case .
Here is Example code in which i m comparing Username without case sensitivity
dont forget to mark "Do you like answer" please it will give me some credits :)
private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True");
con.Open();
SqlCommand comm = new SqlCommand("select * from Users where Lower(Username)='" + txtUsername.Text.ToLower() + "'", con);
SqlDataReader reader = comm.ExecuteReader();
try
{
while (reader.Read())
{
txtPassword.Text = reader["Password"].ToString();
}
}
catch
{
}
}