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
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 ole word?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
Does ado.net use odbc?
What is the difference between OLEDB Provider and SqlClient?
differences between ADO and ADO.NET
What are the main differences between classic ado and ado.net?
Explain the difference between ado and ado.net?
Is it possible to load multiple tables in a Dataset?
How do you merge 2 datasets into the third dataset in a simple manner?
What do you mean by ‘batch updates’?
How to find the given query is optimised one or not?
How do you update database through dataset?
What is dataadapter in ado.net?
Give an example that shows how to execute a stored procedure in ado.net?
How to copy the contents from one table to another table and how to delete the source table in ado.net?