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
Describe briefly an ADO.NET Dataset ?
What are the methods of XML dataset object?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is the namespaces being used to access oracle database?
What is dataset object? Explain the various objects in dataset.
What is microsoft ole db provider for sql server?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
What are the drawbacks of using ado.net?
Does dapper use ado.net?
What is Serialization in .NET? what are the types of Serialization?
Which object holds only data and does not interact with data source?
Explain how do you connect to sql server database without using sqlclient?
Which name space is used to get assembly details?
What is ado.net in mvc?
What is the difference between sqldatareader and sqldataadapter?