i have two textboxes one for user name and another for
password . i have a table name compare(which contains
name,passwod etc.,)my doubt is how compare username
textbox with name column and how compare password textbox
with passwod column. i want the code
Answer Posted / boopathiraj
sqlconnection con = new sqlconnection("");
sqlcommand cmd = new sqlcommand("select * from
table-name",con);
//write this code in the button click event
con.open();
dr = cmd.executereader();
while(dr.read())
{
if(textbox1.text==dr.getvalue(0).tostring()&&
textbox2.text==dr.getvalue(1).tostring())
{
msgbox.show("successful");
}
}
con.close();
else
{
msgbox.show("not success");
}
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is sqldatareader?
What is openquery?
What is microsoft ole db provider for sql server?
What are the ado.net components?
What is ado in agriculture?
What are two important objects of ADO.Net?
How can you add or remove rows from the datatable object of dataset?
What is the full form of ado.net?
What is the difference between linq and ado.net?
What is the difference between statement and preparedstatement interface?
What is microsoft ado?
Explain the difference in an abstract class and an interface?
What is the difference between the clone() and copy() methods of the dataset class?
What is ado rdo dao in visual basic?
What is the default Timeout for SqlCommand.CommandTimeout property?