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
- 18205 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 are the major difference between classic ADO and ADO.NET?
Which object holds only data and does not interact with data source?
What is full form of ado?
How do you connect to sql server database without using sqlclient?
Is it possible to load multiple tables in a Dataset?
What are dcl commands?
Does sqlclient and oledb class share the same functionality?
What is a sqldataadapter?
Does entity framework use ado.net?
What is dataset and datatable in ado.net?
How to pass values into a datatable?
Define data access layer?
What are the essential features of ado.net?
Define atomicity?
What does executereader return?
