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 / srilekha
{
string s=string.Format("select * from compare where
name='{0}' and Password='{1}'",textbox1.Text,textbox2.Text);
SqlDataAdapter da=new SqlDataAdapter (s,conn);
DataTable dt=new DataTable();
da.Fill(dt);
if(dt.Rows.Count>0)
{
Lable1.text="login successfull";
}
else
{
Lable1.text="login fail";
}
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
List all the steps in order, to access a database through ado.net?
What is untyped dataset?
What is ado in agriculture?
How to find the given query is optimised one or not?
What is a column variable?
What is the provider being used to access oracle database?
What is the significance of CommandBehavior.CloseConnection ?
What are all the commands used with Data Adapter?
How to create dynamic gridview?
What are the ado.net objects?
What is ado rdo dao in visual basic?
What is ado connection?
What are the different execute methods of Ado.Net?
How to pass multiple tables in datasets simultaneously?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?