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 are the drawbacks of using ado.net?
What are the advantages of ado.net?
Explain the difference between ado and ado.net?
What is ado recordset?
What is aggregating data ?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?
What is ado.net and its architecture?
What are the rules to implement connection pooling?
What are the advantages and drawbacks of using ado.net?
What is openquery?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
How is it possible to get 2 tables of data at a time by using data reader?
How do you update a dataset in ado.net and how do you update database through dataset?
What is DataRowCollection?
What is the use of sqldatareader class?