Asp.net with Mysql Server

Hi Nitin,


refer this link step by step to create login form
http://dotnet.tekyt.info/?p=31

Hi,

You can Download a Sample Source Code Here and follow the instructions,

http://forum.coolwebawards.com/threads/10-ASP.NET-forms-authentication-login-using-C-.NET

Hi Nitin,


Try this...


' Import the ODBC namespace for MySQL Connection
Imports System.Data.Odbc
Partial Class login
    Inherits System.Web.UI.Page

    Protected Sub Login1_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.AuthenticateEventArgs) Handles Login1.Authenticate
        Dim cn As New OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=mydb; User=root;Password=;")
        cn.Open()
        Dim cmd As New OdbcCommand("Select * from login where username=? and password=?", cn)

        'Add parameters to get the username and password

        cmd.Parameters.Add("@username", OdbcType.VarChar)
        cmd.Parameters("@username").Value = Me.Login1.UserName

        cmd.Parameters.Add("@password", OdbcType.VarChar)
        cmd.Parameters("@password").Value = Me.Login1.Password

        Dim dr As OdbcDataReader
        ' Initialise a reader to read the rows from the login table.
        ' If row exists, the login is successful

        dr = cmd.ExecuteReader

        If dr.HasRows Then
            e.Authenticated = True
            ' Event Authenticate is true
        End If

    End Sub
End Class


Refer the below link for more

http://dotnet.tekyt.info/?p=31

http://www.codeguru.com/csharp/.net/net_data/article.php/c19493


Thanks