Dropdownlist

Question

I am having a table in that i store different user names and passwords. What i need is when i load the page all the users in the table should be displayed in Dropdownlist and when i click on log in button it should verify whether correct password is given to the selected user or not an it should log in...

Niradhip Chakraborty · Answer

For button Click you may refer following code: bool blnFound = false ; SqlConnection sqlCon = null ; sqlCon = new SqlConnection(ConfigurationManager.AppSettings[con].ToString()); sqlCon.Open(); SqlCommand cmd = new SqlCommand(select * from Users where sqlCon); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { //validating user name if (dr[usr_vch_Name].ToString() == cboUserName.Value) { // validating password i f (dr[usr_vch_Password].ToString()).ToString() == txtPassword.Text) { blnFound = true ; // User validated successfully code redirect to other pages } } }

Dorababu Meka · Answer

Can i have the complete code for button click event also

Kirtan Patel · Answer

If i Have table With Column 'username' Then Code Will be Like Below protected void Page_Load(object sender EventArgs e) { if (!IsPostBack) { SqlConnection con = new SqlConnection(@Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True); con.Open(); SqlCommand comm = new SqlCommand(select Username From Users con); SqlDataReader reader = comm.ExecuteReader(); while (reader.Read()) { ddlUsers.Items.Add(reader[Username].ToString()); } } }