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
- 16560 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 ole in vb?
What are the different ado.net namespaces?
Does ado.net use odbc?
What are ado.net objects?
What are two types of transaction supported by ado.net?
How do you implement locking concept for dataset?
What two types of data providers does ADO.NET supply? What determines which one you should use?
What is the use of ADO.NET and XML web services?
Describe the disconnected architecture of ADO.NET’s data access model.
Explain the namespaces in which .net has the data functionality class.
What is data adapter in ado.net with example?
Define ado.net?
What is the advantage of ado.net?
What is Data Provider?
What is difference between entity framework and ado.net?
