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
What is the difference between DataReader and DataSet in ADO.NET?
How to create data relations?
Explain why canot we use multiple inheritance and garbage collector paralelly in .net?
What is sqldatareader in ado.net?
What is execute scalar in ado.net?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
Explain how to pass multiple tables in datasets simultaneously?
What is the hierarchy of data in databases?
What providers does Ado.net uses?
What is ado or jdbc?
What are the namespaces used in ADO.Net to connect to a database?
What is the difference between sqlcommand and sqldataadapter?
Which architecture does Datasets follow?
What is the difference between executequery and executenonquery?
How to identify the updated rows in a dataset?