how can i solve my error ??

Question

hi..when i run my loging page.. that time my usernm wrong &password fieldis right then its work my loging page.....pls give some help

Niradhip Chakraborty · Answer

Try the following code for your login control: I have two textbox txtEmployeeID is for userName and txtPIN for password,onclick of submit button execute the following code. In my user table usr_vch_Name field is for userId and usr_vch_Password holds tha password bool blnFound = false; SqlConnection sqlCon = null; Array arrOptions; int intIndex = 0; sqlCon = new SqlConnection(ConfigurationManager.AppSettings["con"].ToString());//fetching the connection string from web.config. sqlCon.Open(); SqlCommand cmd = new SqlCommand("select * from Users where usr_int_Type=1 or usr_int_Type=3 ", sqlCon); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { if (dr["usr_vch_Name"].ToString() == txtEmployeeID.Text) { if (dr["usr_vch_Password"].ToString() == txtPIN.Text) { blnFound = true; // SUCCESSFULLY USER VALIDATED } } } if (!blnFound) MessageBox.Show("Wrong login info is provided"); txtEmployeeID.Text = ""; txtPIN.Text = ""; dr.Close(); sqlCon.Close();

Rahul Saxena · Answer

can u paste here your login page coding

Vimal Kandasamy · Answer

hi.. please tel me exactly what is your problem...

how can i solve my error ??

Answers (3)