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
How many major types of connection objects in ADO.NET?
Define table relations?
What are the disadvantages of using datalist?
What is connected architecture in ado.net?
What you mean by filtering of data?
How to check if the Dataset has records ?
What is a non query?
Define Execute Reader?
What is a sqldataadapter?
What is serialization and de-serialization in .net?
Define isolation?
Explain sqlconnection object?
Difference between sqlcommand and sqlcommandbuilder?
What is the role of data provider in ado.net?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?