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
- 17982 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sonj
dim qry as string = SELECT name,password FROM compare where
name = '" + txtName.text + "' AND password = '" +
txtPassword.txt + "'"
Dim ConectionString As String = "User ID=xxx;Password = yyy;
Initial Catalog='" + DataBaseName + "';Data Source=<System No>"
dim con as SqlConnection = New SqlConnection(ConectionString )
con.open
dim cmd as SqlCommand = new SqlCommand(qry,con)
dim dr as SqlDataReader = cmd.ExectueReader
if dr.HasRows = True then
messagebox.show("User ID Found")
else
messagebox.show("User ID Not Found")
end if
Above is the one example. There are various ways to validate
fox example you can write a stored procedure to validate
ID,Password and avoid SQL Injection etc.,
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is ole in excel?
Explain the role of data provider in ado.net? What is the role of data provider in ado.net?
Do we use stored procedure in ADO.Net?
What does executereader return?
What is ado object model?
What is ado rdo dao in visual basic?
What is ole2 format?
How to Read, Add, Update and Delete record in Entity Framework ?
How can I retrieve two tables of data at a time by using data reader?
What is data reader in ado.net?
What is XML serialization
What is isolation?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
Can we do database operations without using any of the ado.net objects?
What are the data providers used in ado.net
