Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 18207 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / deepak,the infotech icon
sqlConnection con=new sqlConnection();
con.Connectionstring="Data source=servername;Initial
Catalog=databasename;Integrated Security=sspi";
con.open();
string query="SELECT * FROM tablename where name=@name AND
password=@password";
sqlCommand cmd=new sqlCommand(query,con);
cmd.parameters.add(new sqlparameters(@name,textbox1.text));
cmd.parameters.add(new sqlparameters(@password,textbox2.text));
sqlDataReader dr=cmd.Executereader();
while(dr.read())
{
if((textbox1.text==dr[0])&&(textbox2.text==dr[1]))
{
Messagebox.show("YOU ARE SUCCESSFULLY LOGED IN");
return;
}
}
Messagebox.show("INVALID USERNAME OR PASSWORD");
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
What is a serialized object?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
How to add an aggregate column?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What is the use of SqlCommand object?
List the 4 common ado.net namespaces?
Do we use stored procedure in ADO.Net?
What is a non query?
What is ado.net in vb net?
Why is it important to close an ado.net application?
Explain the two fundamental objects in ado.net?
Is entity framework better than ado.net?
How do you connect to sql server database without using sqlclient?
What is an example of ordinal data?
What does sqldatareader return?
