Login Page Detail Example using vb.net and mysql

Downloaded and installed the MySQL Connector/Net from the MySQL official website http://dev.mysql.com/downloads/connector/net/6.1.html Open Visual Studio and click on the new project and give the project a name; it will open the new project, then click on the solution explorer (F4); right-click on "Reference" to add a new reference into the project. Add a reference for those two .dll files to the project (MySql.dll (Win apps), MySql.web.dll (Web apps)). <%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Default.aspx.vb" Inherits="WebApplication20._Default" %> Untitled Page Imports MySql.Data.MySqlClient Partial Public Class _Default Inherits System.Web.UI.Page Dim strcon As String = "Server=localhost;Database=test;Uid=root;Pwd=;" Dim con As New MySqlConnection(strcon) Dim str As String Dim com As MySqlCommand Dim sqlda As MySqlDataAdapter Dim ds As DataSet Dim obj As Object = Nothing Protected Sub btn_login_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btn_login.Click con.Open() str = "select count(*) from login where UserName=@UserName and Password =@Password" com = New MySqlCommand(str, con) com.CommandType = CommandType.Text com.Parameters.AddWithValue("@UserName", TextBox_user_name.Text) com.Parameters.AddWithValue("@Password", TextBox_password.Text) obj = com.ExecuteScalar() If CInt(obj) <> 0 Then lb1.Text = "WELLCOME :: " + TextBox_user_name.Text Else lb1.Text = "invalid user name and password" End If con.Close() End Sub End Class

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Anna Harris13y ago
If you are new to Asp.net, then start with a beginners guide as that can guide you everything step-by-step.
Satyapriya Nayak13y ago
Downloaded and installed the MySQL Connector/Net from the MySQL official website http://dev.mysql.com/downloads/connector/net/6.1.html Open Visual Studio and click on the new project and give the project a name; it will open the new project, then click on the solution explorer (F4); right-click on "Reference" to add a new reference into the project. Add a reference for those two .dll files to the project (MySql.dll (Win apps), MySql.web.dll (Web apps)). <%@ Page Language="vb" AutoEventWireup="false" CodeBehind="Default.aspx.vb" Inherits="WebApplication20._Default" %> Untitled Page

Imports MySql.Data.MySqlClient Partial Public Class _Default Inherits System.Web.UI.Page Dim strcon As String = "Server=localhost;Database=test;Uid=root;Pwd=;" Dim con As New MySqlConnection(strcon) Dim str As String Dim com As MySqlCommand Dim sqlda As MySqlDataAdapter Dim ds As DataSet Dim obj As Object = Nothing Protected Sub btn_login_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btn_login.Click con.Open() str = "select count(*) from login where UserName=@UserName and Password =@Password" com = New MySqlCommand(str, con) com.CommandType = CommandType.Text com.Parameters.AddWithValue("@UserName", TextBox_user_name.Text) com.Parameters.AddWithValue("@Password", TextBox_password.Text) obj = com.ExecuteScalar() If CInt(obj) <> 0 Then lb1.Text = "WELLCOME :: " + TextBox_user_name.Text Else lb1.Text = "invalid user name and password" End If con.Close() End Sub End Class