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 the difference between ado.net and oledb?
What is the use of connection object in ado.net?
What is the difference between linq and ado.net?
What are the classes in System.Data.Common Namespace?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What is aggregating data ?
What is ole in excel?
What is ado and rdo?
What is the use of SqlCommandBuilder?
What is ado control?
Difference between sqlcommand and sqlcommandbuilder?
What is the role of the dataset object in ado.net?
Which method in OLEDBAdapter is used to populate dataset with records?
What is adodb dll?