How to compare strings in c#?

<i><b>Originally posted by : kamp (kamph@netease.com)</b></i><br /><br />i want compare user's password and the password from a database(m$sql), but it doesn't work!<br />when i print both two password on the web-browser, they are the same! The following is my code:<br /> <br /> SQLConnection myConnection = new SQLConnection("server=Qacomputer;uid=sa;pwd=;database=sn");<br /> SQLCommand myCommand = new SQLCommand("select psswrd from login where name='"+idname.SelectedItem.Value+"'", myConnection);<br /><br /> myConnection.Open();<br /> myCommand.Execute(out MyReader);<br /> MyReader.Read();<br /><br /> if(MyReader["psswrd"].ToString().Equals(password.Text.ToString()))<br /> hell.Text = "password is corrected";<br /> else<br /> hell.Text = "password is not corrected " +MyReader["psswrd"].ToString() + " " + password.Text.ToString();<br /> MyReader.Close();<br /> myConnection.Close();

<i><b>Originally posted by : </b></i><br />hi<br />why do u want to do this ???<br />MyReader["psswrd"].ToString().Equals(password.Text.ToString())<br /><br />i guess ur storing strings of passwords into the database then why do you want to caste it back to a string(MyReader["psswrd"].ToString())<br />.Try using MyReader["psswrd"] only<br /><br />Regards<br />Saurabh<br /><br />------------<br />kamp at 11/9/2000 7:28:00 AM<br /><br /><br />i want compare user's password and the password from a database(m$sql), but it doesn't work!<br />when i print both two password on the web-browser, they are the same! The following is my code:<br /> <br /> SQLConnection myConnection = new SQLConnection("server=Qacomputer;uid=sa;pwd=;database=sn");<br /> SQLCommand myCommand = new SQLCommand("select psswrd from login where name='"+idname.SelectedItem.Value+"'", myConnection);<br /><br /> myConnection.Open();<br /> myCommand.Execute(out MyReader);<br /> MyReader.Read();<br /><br /> if(MyReader["psswrd"].ToString().Equals(password.Text.ToString()))<br /> hell.Text = "password is corrected";<br /> else<br /> hell.Text = "password is not corrected " +MyReader["psswrd"].ToString() + " " + password.Text.ToString();<br /> MyReader.Close();<br /> myConnection.Close();