Login Page Detail Example using vb.net and mysql

Question

Hello I want to create an web application using vb.net and MySQL please give step by step guide or example which show how to create login page in vb.net using MySQL awaiting your valuable reply.

Anna Harris · Answer

If you are new to Asp.net then start with a beginners guide as that can guide you everything step-by-step.

Satyapriya Nayak · Answer

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)). 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