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
How do you update database through dataset?
How can we load multiple tables in a dataset?
What is bubbled event can you please explain?
What is the full form of ado?
Do you use stored procedure in ado.net?
What Is Difference Between Ado And Ado.net?
What is the default timeout specified for "sqlcommand.commandtimeout" property?
What do you mean by performing asynchronous operation using command object?
How to Read, Add, Update and Delete record in Entity Framework ?
What do you mean by ‘batch updates’?
What is ole in vb?
Which is better ole db or odbc?
What are the pre-requisites for connection pooling?
Which method in OLEDBAdapter is used to populate dataset with records?
What are the data access namespaces in .NET?