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
- 17570 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 you mean by filtering of data?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
What is sqldatareader?
What do you mean by ‘batch updates’?
What is Data view?
What is data control techniques?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
Is entity framework better than ado.net?
What is the difference between Command and CommandBuilder object?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What are all the different authentication techniques used to connect to MS SQL Server?
What are the benefits of using ado.net?
Can we do database operations without using any of the ado.net objects?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Why edit is not possible in repeater?
