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
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 the difference between Data adaptor and Data set?
Do you use stored procedure in ado.net?
Explain how to create dynamic gridview?
What are the advantages and disadvantages of using datalist?
What is the role of clr?
What is ado.net code?
Is it possible to load multiple tables in a Dataset?
What is the difference between DataReader and DataSet in ADO.NET?
How can we serialize the dataset object?
What is a serialized object?
How can I retrieve two tables of data at a time by using data reader?
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What is ado.net connection?
What is the use of ADO.NET and XML web services?
How to aggregating data across related tables?