Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 / boopathiraj

sqlconnection con = new sqlconnection("");
sqlcommand cmd = new sqlcommand("select * from
table-name",con);

//write this code in the button click event
con.open();
dr = cmd.executereader();
while(dr.read())
{
if(textbox1.text==dr.getvalue(0).tostring()&&
textbox2.text==dr.getvalue(1).tostring())
{
msgbox.show("successful");
}
}
con.close();
else
{
msgbox.show("not success");
}

Is This Answer Correct ?    3 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define Execute Scalar?

1020


What are the features of ado.net?

1039


What is the difference between linq and ado.net?

999


What are the different ado.net namespaces are available in .net?

1008


What is the difference between Data adaptor and Data set?

1041


What is ole db and odbc?

924


Which keyword is used to accept variable number of parameters?

1127


Explain the architecture of ado.net?

1068


How to work with disconnected data - the dataset and sqldataadapter?

987


Which control of the BindingNavigator returns the current position within the data source?

1169


Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?

1150


What is the difference between ado.net and entity framework?

1049


What is ado full form?

1020


What are the different row versions available in table?

975


What is untyped dataset?

1094