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
- 9 Answers
- 17637 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / anjaneyulu
U will compare the 2 textboxes values i.e.username &
password with the database values by writing the following code:
cn.Open();
SqlCommand cmd = new SqlCommand("select count(*)
from compare where username='" + TextBox1.Text + "'and
password='" + TextBox2.Text + "'", cn);
int count = (int)cmd.ExecuteScalar();
cn.Close();
if (count != 0)
{
Page.RegisterStartupScript("pr",
"<script>alert('welcome to MS.Net')</script>");
}
else
{
Page.RegisterStartupScript("an",
"<script>alert('sorry')</script>");
}
| Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
What two types of data providers does ADO.NET supply? What determines which one you should use?
What is the use of data grid?
How can we add/remove row's in "datatable" object of "dataset"?
Which is better ole db or odbc?
What is ado full form?
Explain sqlconnection object?
What are the features of ado.net?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
What does adodb stand for?
What are the key events of sqlconnection class?
Explain how to call the sql commands asynchronously in ado.net version 2.0?
Does entity framework use ado.net?
How can we add relation between tables in a dataset?
What is ado.net full form?
How to generate a single aggregate?
