Sunday, March 16, 2014

MySQL VB.NET Tutorial 2 : Create Login Form with MySql and VB.NET (Part 1)






Imports MySql.Data.MySqlClient

Public Class Form1
    Dim MysqlConn As MySqlConnection
    Dim COMMAND As MySqlCommand




    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        MysqlConn = New MySqlConnection
        MysqlConn.ConnectionString =
       "server=localhost;userid=root;password=root;database=database"

        Try
            MysqlConn.Open()
            MessageBox.Show("Connection Successful")
            MysqlConn.Close()

        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            MysqlConn.Dispose()

        End Try

    End Sub

    Private Sub Login_Btn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Login_Btn.Click
        MysqlConn = New MySqlConnection
        MysqlConn.ConnectionString =
       "server=localhost;userid=root;password=root;database=database"
        Dim READER As MySqlDataReader


        Try
            MysqlConn.Open()
            Dim Query As String
            Query = "select * from database.edata where user_name='" & TextBox_UN.Text & "' and password='" & TextBox_Pass.Text & "' "
            COMMAND = New MySqlCommand(Query, MysqlConn)
            READER = COMMAND.ExecuteReader
            Dim count As Integer
            count = 0
            While READER.Read
                count = count + 1

            End While

            If count = 1 Then
                MessageBox.Show("Username and password are correct")
            ElseIf count > 1 Then
                MessageBox.Show("Username and password are Duplicate")
            Else
                MessageBox.Show("Username and password are not correct")

            End If


            MysqlConn.Close()

        Catch ex As MySqlException
            MessageBox.Show(ex.Message)
        Finally
            MysqlConn.Dispose()

        End Try
    End Sub
End Class














--------------------------------------------------------

Login Program for VB.NET with Mysql

Visual VB.NET - Login Form Tutorial

VB.NET - How can I close a login form and show the main form

Login Form using VB.NET and SQL

VB.NET Login Form with MS Access

Login Form using c# and ms access as database..?‎

closing Login form after a successful Login in VB.NET form‎

create a login form using VB.NET‎

VB.NET program to connect to mysql

php login code mysql

Login Source Codes

Code for login form in VB.NET

VB.NET Login form Searches related to c# login form

java login form Visual basic

visual basic login form Visual basic

visual studio login form Visual basic

c# login form template Visual basic

c# login form access database Visual basic

c# login form example Visual basic

c# login form code Visual basic

c# login form sql Visual basic

create login page contain user id,password,buttons  Visual basic

mysql C# sample codeVisual basic
















No comments:

Post a Comment