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
Explain the various objects in dataset.
How can we load multiple tables in a dataset?
Define Execute Scalar?
What is the difference between sqlcommand and sqldataadapter?
What is executequery?
How to pass values into a datatable?
What are the namespaces used in ado.net for data access?
Explain the difference between ado and ado.net?
How to identify the controls which can be used for binding data?
Can we load multiple tables in a dataset?
What is the hierarchy of data in databases?
What are the advantage of ado.net?
What is the meaning of object pooling?
What does executequery return?
Explain the differences between oledb sql server, oledbdotnet provider?