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
Does ado.net use odbc?
What is variable view?
How to connect and retrieve data from database using dataset
How to create data relations?
Explain the various objects in dataset.
What are the different ado.net namespaces?
Does executenonquery return a value?
Why ca not we use multiple inheritance and garbage collector paralelly in .net?
What is sql command in ado net?
Explain sqlconnection object?
Describe briefly an ADO.NET Dataset ?
Why edit is not possible in repeater?
Do we use stored procedure in ADO.Net?
What are the Data providers in ADO.Net?
What is the return type of executescalar?