Access Databases and AccessDataSource Control

Re: username & password validation

suresh.pydi — Mon, 31 Mar 2008 13:45:24 GMT

create procedure CheckLoginDetails

(

@username nvarchar(100),

@password nvarchar(100)

)

Begin

select Count(*) from tablename where Username=@username ,password=@password

End

in Codebehind Ur using Executescalar.

Re: username & password validation

Jos Branders — Sun, 30 Mar 2008 07:44:57 GMT

Automatic translation from vb to C#:

http://labs.developerfusion.co.uk/convert/vb-to-csharp.aspx

Jos

Re: username & password validation

mestrebisli — Sat, 29 Mar 2008 15:45:39 GMT

can you give the same exemple in c# code?

Re: username & password validation

Jos Branders — Sun, 23 Mar 2008 08:40:23 GMT

In the onclick of the logon button, try something like (I'm using VB.NET):

       Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|userdatabase.mdb"
        Dim cn As New OleDbConnection(strConn)
        Try
            cn.Open()
            Dim cm As New OleDbCommand("SELECT COUNT(*) FROM users WHERE username=? AND password=?;", cn)
            cm.Parameters.AddWithValue("?",TextBoxUsername.Text)
            cm.Parameters.AddWithValue("?",TextBoxPassword.Text)
            Dim count As Integer = CInt(cm.ExecuteScalar())
            If(count>0) Then
                  ' user successfully logged on
                  ' do something
            Else
                 lblError.Text = "Logon failed"
            End If
        Catch ex As Exception
            lblError.Text = ex.Message()
        Finally
            cn.Close()
        End Try

Jos

username & password validation

devianakalia — Sat, 22 Mar 2008 21:06:30 GMT

I am trying to validate a username and password that has been entered in a text box, and validating it against a username and password that is in an Access database. How would I do that in visual web developer using sql?