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
- 17839 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 command class in ado.net?
What is data relation in ado.net?
Define Execute Reader?
Which control of the BindingNavigator returns the current position within the data source?
Describe the disconnected architecture of ADO.NET’s data access model.
What is difference between ado and other data object?
What is the difference between ado.net and oledb?
What is openrowset?
What is linq and entity framework?
Which database is the ado.net?
What is the return type of executescalar?
What are the data providers in ADO.NET framework?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
Which object is used to add relationship between two Datatables?
