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
- 17972 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / suchit kumar dash
Dim con as new SqlConnection
Dim cmd as new SqlCommand
Dim dr as SqlDataReader
Dim str,str1 as String
Dim I_Int as Integer=0
PageLoad
--------------
str="Server=......;Database=......;Trusted_Connection=Yes;User
Id=sa;Password=sa;"
con=new SqlConnection(str)
Login BUtton
--------------
str1="select * from TableName where User_Name='"&
TextBox1.Text &"' and Password='" & TextBox2.Text &"'"
cmd=New SqlCommand(str1,con)
dr=cmd.ExecuteReader
while(dr.Read())
i_int=i_int+1
End while
if i=0 then
MessageBox.Show("Please Enter correct User Id and Password")
else
Endif
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What is serialization and de-serialization in .net? How can we serialize the dataset object?
Define atomicity?
What is the difference between Optimistic and Pessimistic locking?
What are the data providers used in ado.net
Explain ado.net features?
What does ado stand for in ado.net?
Can datareader hold data from multiple tables?
What is difference between datatable and dataset?
can we create synonymn in ms access,sql server,my sql if so explain me with example
What is data view and variable view?
What is ole in excel?
Explain sqlconnection object?
What is oledb connection?
Define data access layer?
Does ado.net use odbc?
