| Author: Danasegarane.A 21 Aug 2007 | Member Level: Diamond | Rating:  Points: 2 |
Try to use a DropdownBox . And populate the users from the table in the DropdownBox.And for the user to select the user from the DropdownBox
|
| Author: ChandraShekarThota 21 Aug 2007 | Member Level: Diamond | Rating: Points: 2 |
object myConnection; object myCommand; object myReader; myConnection = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source='" + Server.MapPath(".") + "/veracity.mdb'; "); myCommand = new OleDbCommand("select * from tblusers where username='" + TextBox1.Text + "' and password='" + TextBox2.Text + "'", myConnection); myCommand.Connection.Open(); myReader = myCommand.ExecuteReader(); if (myReader.HasRows()) { myReader.Read(); Response.Write("success"); } else { Response.Write("ERROR : Record NOT FOUND."); } myCommand.Connection.Close();
|