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


Please Help Members By Posting Answers For Below Questions

What is maximum pool size in ado.net connection string?

489


Which is better ole db or odbc?

489


What is XML serialization

581


how Sequence to connect and retrieve data from database using dataset?

743


Which database is the ado.net?

491






Is it possible to edit data in Repeater control?

521


What is microsoft ole db provider for sql server?

471


How to read data with the sqldatareader ?

527


What is ole word?

519


What is a dataview?

525


What is ole access?

542


What is the role of the dataset object in ado.net?

563


How to add an aggregate column?

523


What is a sqldataadapter?

516


How to add a javaScript function in a datagrid?

561