login

[winnie]

hi. i am new to .net programming. i have a simple question here.

how can i validate a login form using vb.net and sql?

can i get sample code from somewhere?

[divil]

You'll have to be a little less vague first. It depends on what database you're using, table and field names etc.

[winnie]

i am using microsoft sql server.

there are a few columns such as userid,password,email,DOB and etc.

i thought i just have to check for userid and password. if it match, the user can login.

is this the right way?

[divil]

Yes, that's the right way.

[winnie]

can someone show me how to write this in vb.net code?? i cant seem to get mine to work...

[liquidspaces]

This is one thing that I know how to do in this kookie language:)

 

Can you show us what you have right now?

[winnie]

my code is very messy right now. can anyone show me how to do it in a proper way??

[a_jam_sandwich]

Imports System.Data.SqlClient

Module Module9

   public Function CheckPassword(ByRef UID As String, ByRef Password As String) As Boolean
       Dim myConnection As New SqlConnection()
       Dim myRs As ADODB.Recordset
       myConnection.ConnectionString = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=DATABASENAME"
       myConnection.Open()
       myRs = New ADODB.Recordset()
       myRs.Open("SELECT UserID,PASSWORD FROM MyTABLE WHERE UserID='" & UID & "' AND PASSWORD='" & Password & "'", myConnection, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockOptimistic)
       If myRs.RecordCount > 0 Then
           CheckPassword = True
       Else
           CheckPassword = False
       End If
       myRs.Close()
       myConnection.Close()
   End Function

End Module

 

Try somthing like this

[winnie]

i have tried the code, but still cannot run.

is "adodb.recordset" for vb6 only??

[divil]

Make sure you have a project reference to Microsoft ActiveX Data Objects.