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
- 17919 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 does datareader object do?
Define the executescalar method?
What is the use of SqlCommand object?
What is ole2 format?
Which provider is used to connect ms access, oracle, etc…?
Does entity framework use ado.net?
What are the drawbacks of using ado.net?
What does executequery return?
Why do we serialize data?
Which method is used to sort the data in ADO.Net?
What is defaultview in datatable?
Explain the difference in an abstract class and an interface?
Which is faster entity framework or ado.net?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
How to add a javaScript function in a datagrid?
