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
- 17643 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 adodb dll?
What is data relation in ado.net?
Explain the dataadapter class in ado.net?
What are the 3 major types of connection objects in ado.net?
Can we load multiple tables in a dataset?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
What is csdl entity framework?
Explain the role of data provider in ado.net?
What are good ado.net object to replace to ado recordset object.
What is an ado connection?
What is ado.net and its features?
What are the ado.net connection pooling parameters?
Can we do database operations without using any of the ado.net objects?
The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
Define partial class?
