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
- 17957 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 aggregating data ?
Explain ado.net features? Benefits? Drawbacks?
Explain the different row versions available in table?
What is the use of data grid?
What are all components of ADO.Net data provider?
What is ado or jdbc?
What is isolation?
Does ado.net use odbc?
What is the difference in record set and dataset?
How do you update database through dataset?
What does ole stand for in excel?
What are the advantages and drawbacks of using ado.net?
What we do with the object of ado.net dataset after using it?
How can we check that some changes have been made to dataset since it was loaded?
What connected data?
