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
Which is better ole db or odbc?
What are the Features and disadvantages of dataset
What is the current version of entity framework?
What are the ado.net connection pooling parameters?
What is ole in vb?
What is the difference between ADO and ADO.Net?
What DataReader class do in ADO.NET ?
How to find the given query is optimised one or not?
What do you mean by performing asynchronous operation using command object?
What are the advantages of oledb compared with other classes?
What is the use of adodc?
How to work with disconnected data - the dataset and sqldataadapter?
What is ado.net in vb net?
What is the difference between sqlcommand and sqldataadapter?
Which is faster ado.net or linq?