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 / vijay
sqldatasource s=new sqldatasource();
s.connectionstring=configurationmanager.connectionstring
["compareconnectionstring"].connectionstring;
s.selectcommand="select count(*) from compare where uid='"
+ textbox1.text + "'and pwd='" + textbox2.text + "'";
Dataview dv=new dataview();
dv=(dataview)s.select(datasourceselectarguments.empty)
if(dv[0][0]>0){} //found
else{}//not found
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Command objects uses, purposes and their methods.
What are the major difference between classic ADO and ADO.NET?
Which is faster ado.net or linq?
How do you connect to sql server database without using sqlclient?
Why do we serialize data?
Does executenonquery return a value?
What are the Features and disadvantages of dataset
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
What are the data access namespaces in .NET?
What are the different ado.net namespaces are available in .net?
Is entity framework better than ado.net?
How do you find the count of records in a dataset?
Explain the advantages and disadvantages of using datalist?
What is Data view?
What is acid in ado.net?