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
- 17920 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
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
List the 4 common ado.net namespaces?
What is the difference between dataset and datatable?
What is a dataview?
Does dapper use ado.net?
How to Read, Add, Update and Delete record in Entity Framework ?
Describe the command object and its method.
What are dcl commands?
What is dataadapter in ado.net?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
What is Serialization in .NET? what are the types of Serialization?
Which object of ado contains datarow datacolumn collection?
What is partial class?
Explain the two fundamental objects in ado.net?
