Security Login

[aarondba]

I am relatively new to programming and could use some direction from someone more experienced.

What I am trying to do is create a login routine for a VB.Net app I have created. I need to promp the user to enter a username and password, then compare their password with the password field in a SQL Server database for their userid. If they match, then go ahead and open the first form in the app.

Basically I need someone to show me the syntax I should follow to connect to the database, formulate and run a select statement based on the userid they enter in the textbox, then compare the password they entered in a textbox to the one in the database. I'd like to use ADO.NET, but if there are other ways to do this, please feel free to respond. Thanks in advance!

[Neoharuo]

Welcome to the forums!

First you need to get the connection string.

http://www.connectionstrings.com/

This site has lots of them. Then you need to create a data adater and a data table and then just fill the table from the adapter. I'll post code if you need it.

[Neoharuo]

Dim oConn As New SqlConnection = "Connection String Goes Here"
Dim oAdpt As New SqlDataAdapter("Select * From Employee", oConn)
Dim oDTbl As New DataTable
 
oADpt.Fill(oDTble)
 
Dim oTempRow As DataRow
For Each oTempRow In oDTbl.Rows
     If oTempRow.Item("EmployeeID") = txtEmpID.Text Then
          If oTempRow.Item("Password") = txtPassword.Text Then
               'User Logs In
          Else
               'User Doesn't Log In
          End If
     End If
Next

[aarondba]

That is exactly what I needed. It worked perfectly. Thanks Neoharuo!

[Neoharuo]

That is exactly what I needed. It worked perfectly. Thanks Neoharuo!

NP glad to be of help!