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
- 17645 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 execute reader in ado.net?
What is ado object model?
What is the difference between dataset and datatable?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What is ole db query?
Is entity framework better than ado.net?
What is sqldatareader?
How can we load multiple tables in to dataset?
Which object needs to be closed?
What is ado oledb and odbc?
If a table contains 20000 records. In a page at each time 100 records to be displayed.
Which database is the ado.net sql connection object designed for?
What provider ado.net use by default? Explain the role of data provider in ado.net?
What does executereader return?
What is openrowset?
