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
- 17962 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 are ado.net objects?
What is difference between datatable and dataset?
Do you use stored procedure in ado.net?
What is data relation in ado.net?
What is openrowset?
What is serialization and de-serialization in .net?
Describe datareader object of ado.net with example.
How does entity framework work?
What are the differences between OLEDB and SQLClient Providers?
What is sql command in ado net?
If we are not returning any records from the database, which method is to be used?
Give an example of a .net application which connects to microsoft access database using ado.net classes.
Explain the different row versions available in table?
What are the 3 major types of connection objects in ado.net?
Define executenonquery?
