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
- 17929 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 connection pooling and what is the maximum pool size in ado.net connection string?
What is difference between executenonquery and executequery?
What are datareaders?
What is sqldatareader in ado.net?
Describe briefly an ADO.NET Dataset ?
Describe datareader object of ado.net with example.
What is the difference between OLEDB Provider and SqlClient?
What is ado.net and its architecture?
What is the advantage of ado.net?
What is the use of SqlCommandBuilder?
How do you update a dataset in ado.net and how do you update database through dataset?
What is ole in vb?
What is ado object model?
What are the rules to implement connection pooling?
What is sql connection in ado.net?
