GUI Application With Database VB .NET Program



Description:
           
Data to be stored into database through controls


Imports System.Data.OleDb
Public Class transmas
    Inherits System.Windows.Forms.Form


#Region " Windows Form Designer generated code "

    Public Sub New()
        MyBase.New()

        'This call is required by the Windows Form Designer.
        InitializeComponent()

        'Add any initialization after the InitializeComponent() call

    End Sub

    'Form overrides dispose to clean up the component list.
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    Dim OldTransCode As String = ""

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Call database_connection()
        textenable()
        cmbTransName.Visible = False
        cmdcancel.Enabled = Not cmdcancel.Enabled
        cmdsave.Enabled = False
        cmdupdate.Enabled = Not cmdupdate.Enabled
        cmddelok.Enabled = Not cmddelok.Enabled
        cmdadd.Focus()
    End Sub
    Private Sub cmbload()
        Try
            cmbTransName.Items.Clear()
            Dim cmd As New OleDbCommand
            Dim dr As OleDbDataReader
            con.Open()
            cmd = New OleDbCommand("select transname from transmaster", con)
            dr = cmd.ExecuteReader
            While dr.Read
                cmbTransName.Items.Add(dr("transname"))
            End While
            con.Close()
        Catch ex As Exception
            MsgBox(ex.Message)
            If con.State = ConnectionState.Open Then
                con.Close()
            End If
        End Try
    End Sub
    Private Sub cmdenable()
        cmdadd.Enabled = Not cmdadd.Enabled
        cmdedit.Enabled = Not cmdedit.Enabled
        cmddelete.Enabled = Not cmddelete.Enabled
        cmdend.Enabled = Not cmdend.Enabled
        cmdview.Enabled = Not cmdview.Enabled
    End Sub
    Private Sub textenable()
        txttranscode.Enabled = Not txttranscode.Enabled
        txttransname.Enabled = Not txttransname.Enabled
        txttransownname.Enabled = Not txttransownname.Enabled
        txtaddress1.Enabled = Not txtaddress1.Enabled
        txtaddress2.Enabled = Not txtaddress2.Enabled
        txtaddress3.Enabled = Not txtaddress3.Enabled
        txtcontactno.Enabled = Not txtcontactno.Enabled
        txtfax.Enabled = Not txtfax.Enabled
        txtemail.Enabled = Not txtemail.Enabled
        cmbTransName.Enabled = Not cmbTransName.Enabled
    End Sub
    Private Sub textclear()
        txttranscode.Text = ""
        txttransname.Text = ""
        txttransownname.Text = ""
        txtaddress1.Text = ""
        txtaddress2.Text = ""
        txtaddress3.Text = ""
        txtcontactno.Text = ""
        txtfax.Text = ""
        txtemail.Text = ""
        cmbTransName.Text = ""
    End Sub
    Private Sub cmdadd_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdadd.Click
        textenable()
        cmdenable()
        textclear()
        If cmbTransName.Visible Then
            cmbTransName.Visible = Not cmbTransName.Visible
        End If
        cmdsave.Enabled = True
        cmdsave.Visible = True
        cmdcancel.Enabled = Not cmdcancel.Enabled
        If cmdupdate.Visible Then
            cmdupdate.Visible = Not cmdupdate.Visible
        ElseIf cmddelok.Visible Then
            cmddelok.Visible = Not cmddelok.Visible
        End If
        txttranscode.Focus()
    End Sub

    Private Sub cmdcancel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdcancel.Click
        textclear()
        textenable()
        cmdenable()
        cmdcancel.Visible = True
        cmdcancel.Enabled = Not cmdcancel.Enabled
        cmdsave.Visible = False
        cmdsave.Enabled = Not cmdsave.Enabled

        If cmbTransName.Enabled Then
            cmbTransName.Items.Clear()
            cmbTransName.Enabled = Not cmbTransName.Enabled
            cmbTransName.Visible = Not cmbTransName.Visible
            cmbTransName.Text = ""
        End If
        If txttransname.Enabled Then
            txttransname.Enabled = Not txttransname.Enabled
        End If
        cmbTransName.Items.Clear()
        cmdadd.Focus()
    End Sub

    Private Sub cmdend_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdend.Click
        Me.Close()
    End Sub

    Private Sub cmdedit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdedit.Click

        cmbload()
        textenable()
        cmdenable()

        If txttransname.Enabled Then
            txttransname.Enabled = Not txttransname.Enabled
        End If
        If Not cmbTransName.Enabled Then
            cmbTransName.Enabled = Not cmbTransName.Enabled
        End If
        cmbTransName.Visible = True
        If Not cmdupdate.Enabled Then
            cmdupdate.Enabled = Not cmdupdate.Enabled
        End If
        If Not cmdupdate.Visible Then
            cmdupdate.Visible = Not cmdupdate.Visible
        End If
        cmdcancel.Enabled = Not cmdcancel.Enabled
        If cmddelok.Visible Then
            cmddelok.Visible = Not cmddelok.Visible
        ElseIf cmdsave.Visible Then
            cmdsave.Visible = Not cmdsave.Visible
        End If
        txttranscode.Focus()
    End Sub

    Private Sub cmddelete_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmddelete.Click

        textenable()
        cmdenable()
        cmbload()
        If txttransname.Enabled Then
            txttransname.Enabled = Not txttransname.Enabled
        End If
        cmbTransName.Visible = True
        If Not cmbTransName.Enabled Then
            cmbTransName.Enabled = Not cmbTransName.Enabled
        End If
        cmdcancel.Enabled = Not cmdcancel.Enabled
        If Not cmddelok.Enabled Then
            cmddelok.Enabled = Not cmddelok.Enabled
        End If
        If Not cmddelete.Visible Then
            cmddelok.Visible = Not cmddelok.Visible
        End If

        If cmdupdate.Visible Then
            cmdupdate.Visible = Not cmdupdate.Visible
        ElseIf cmdsave.Visible Then
            cmdsave.Visible = Not cmdsave.Visible
        End If
        txttranscode.Focus()
    End Sub

    Private Sub cmdview_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdview.Click
        cmbload()
        textenable()
        cmdenable()
        If txttransname.Enabled Then
            txttransname.Enabled = Not txttransname.Enabled
        End If
        If Not cmbTransName.Enabled Then
            cmbTransName.Enabled = Not cmbTransName.Enabled
        End If
        cmbTransName.Visible = True
        cmdcancel.Enabled = Not cmdcancel.Enabled
        If cmdupdate.Visible Then
            cmdupdate.Visible = Not cmdupdate.Visible
        ElseIf cmddelok.Visible Then
            cmddelok.Visible = Not cmddelok.Visible
        ElseIf cmdsave.Visible Then
            cmdsave.Visible = Not cmdsave.Visible
        End If
        cmbTransName.Focus()
    End Sub

    Private Sub cmddelok_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmddelok.Click
        Try
            Dim cmd As New OleDbCommand
            con.Open()
            cmd = New OleDbCommand("delete from transmaster where transname = '" & cmbTransName.Text & "'", con)
            Deleted = cmd.ExecuteNonQuery()
            con.Close()

            If Deleted = 1 Then
                MsgBox("Record(s) Deleted Successfully", , "Confirmation")
            End If

            textclear()
            textenable()
            cmdenable()
            cmdcancel.Visible = True
            cmdcancel.Enabled = Not cmdcancel.Enabled
            cmddelok.Visible = True
            cmddelok.Enabled = Not cmddelok.Enabled

            If cmbTransName.Enabled Then
                cmbTransName.Items.Clear()
                cmbTransName.Enabled = Not cmbTransName.Enabled
                cmbTransName.Visible = Not cmbTransName.Visible
                cmbTransName.Text = ""
            End If
            If txttransname.Enabled Then
                txttransname.Enabled = Not txttransname.Enabled
            End If
            cmbTransName.Items.Clear()
            cmdadd.Focus()
        Catch ex As Exception
            MsgBox(ex.Message)
            If con.State = ConnectionState.Open Then
                con.Close()
            End If
        End Try
    End Sub

    Private Sub cmbTransName_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbTransName.SelectedValueChanged
        Try
            Dim cmd As New OleDbCommand
            Dim dr As OleDbDataReader
            con.Open()
            cmd = New OleDbCommand("select transcode,transownname,add1,add2,add3,contactno,fax,email from transmaster where transname='" & cmbTransName.Text & "'", con)
            dr = cmd.ExecuteReader
            While dr.Read
                txttranscode.Text = dr("transcode")
                txttransownname.Text = dr("transownname")
                txtaddress1.Text = dr("add1")
                txtaddress2.Text = dr("add2")
                txtaddress3.Text = dr("add3")
                txtcontactno.Text = dr("contactno")
                txtfax.Text = dr("fax")
                txtemail.Text = dr("email")
            End While
            con.Close()

        Catch ex As Exception
            MsgBox(ex.Message)
            If con.State = ConnectionState.Open Then
                con.Close()
            End If
        Finally
            OldTransCode = Replace(txttranscode.Text, "'", "''")
        End Try
    End Sub

    Private Sub cmdsave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdsave.Click
        Try
            Dim cmd As New OleDbCommand
            con.Open()
            cmd = New OleDbCommand("Insert into transmaster (transcode,transname,transownname,add1,add2,add3,contactno,fax,email) values('" & Trim(txttranscode.Text) & "','" & Trim(txttransownname.Text) & "','" & Trim(txtaddress1.Text) & "','" & Trim(txtaddress2.Text) & "','" & Trim(txtaddress3.Text) & "','" & Trim(txtcontactno.Text) & "','" & Trim(txtfax.Text) & "','" & Trim(txtemail.Text) & "') ", con)
            Added = cmd.ExecuteNonQuery()
            con.Close()
            If Added = 1 Then
                MsgBox("Record(s) Saved Successfully", , "Confirmation")
            End If
            textclear()
            textenable()
            cmdenable()
            cmdcancel.Visible = True
            cmdcancel.Enabled = Not cmdcancel.Enabled
            cmdsave.Visible = True
            cmdsave.Enabled = Not cmdsave.Enabled
            If cmbTransName.Enabled Then
                cmbTransName.Items.Clear()
                cmbTransName.Enabled = Not cmbTransName.Enabled
                cmbTransName.Visible = Not cmbTransName.Visible
                cmbTransName.Text = ""
            End If
            If txttransname.Enabled Then
                txttransname.Enabled = Not txttransname.Enabled
            End If
            cmbTransName.Items.Clear()
            cmdadd.Focus()
        Catch ex As Exception
            MsgBox(ex.Message)
            If con.State = ConnectionState.Open Then
                con.Close()
            End If
        End Try
    End Sub

    Private Sub cmdupdate_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdupdate.Click
        Try

            Dim cmd As New OleDbCommand
            con.Open()
            cmd = New OleDbCommand("update transmaster set transcode='" & Trim(txttranscode.Text) & "',transname='" & Trim(cmbTransName.Text) & "',transownname='" & Trim(txttransownname.Text) & "',add1='" & Trim(txtaddress1.Text) & "',add2='" & Trim(txtaddress2.Text) & "',add3='" & Trim(txtaddress3.Text) & "',contactno='" & Trim(txtcontactno.Text) & "',fax='" & Trim(txtfax.Text) & "',email='" & Trim(txtemail.Text) & "' where transcode = '" & OldTransCode & "'", con)
            Updated = cmd.ExecuteNonQuery()
            con.Close()
            If Updated = 1 Then
                MsgBox("Record(s) Updated Successfully", , "Confirmation")
            End If
            textclear()
            textenable()
            cmdenable()
            cmdcancel.Visible = True
            cmdcancel.Enabled = Not cmdcancel.Enabled
            cmdupdate.Visible = True
            cmdupdate.Enabled = Not cmdupdate.Enabled
            If cmbTransName.Enabled Then
                cmbTransName.Items.Clear()
                cmbTransName.Enabled = Not cmbTransName.Enabled
                cmbTransName.Visible = Not cmbTransName.Visible
            End If
            If txttransname.Enabled Then
                txttransname.Enabled = Not txttransname.Enabled
            End If
            cmbTransName.Items.Clear()
            cmdadd.Focus()

        Catch ex As Exception
            MsgBox(ex.Message)
            If con.State = ConnectionState.Open Then
                con.Close()
            End If
        End Try

    End Sub

    Private Sub txttranscode_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txttranscode.KeyPress
        If Asc(e.KeyChar) = "13" Then
            txttransname.Focus()
        End If

    End Sub


    Private Sub txttransname_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txttransname.KeyPress
        If Asc(e.KeyChar) = "13" Then
            txttransownname.Focus()
        End If
    End Sub


    Private Sub txtaddress2_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtaddress2.KeyPress
        If Asc(e.KeyChar) = "13" Then
            txtaddress3.Focus()
        End If
    End Sub

    Private Sub txtaddress3_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtaddress3.KeyPress
        If Asc(e.KeyChar) = "13" Then
            txtcontactno.Focus()
        End If
    End Sub

    Private Sub txtcontactno_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtcontactno.KeyPress
        If Asc(e.KeyChar) = "13" Then
            txtfax.Focus()
        End If
    End Sub

    Private Sub txtfax_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtfax.KeyPress
        If Asc(e.KeyChar) = "13" Then
            txtemail.Focus()
        End If
    End Sub

    Private Sub txtaddress1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtaddress1.KeyPress
        If Asc(e.KeyChar) = "13" Then
            txtaddress2.Focus()
        End If
    End Sub

    Private Sub txttransownname_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txttransownname.KeyPress
        If Asc(e.KeyChar) = "13" Then
            txtaddress1.Focus()
        End If
    End Sub

    Private Sub cmdadd_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdadd.GotFocus
        cmdsave.Visible = True
        cmdsave.Enabled = False
        cmddelok.Visible = False
        cmddelok.Enabled = False
        cmdupdate.Visible = False
        cmdupdate.Enabled = False
    End Sub
    Private Sub cmddelete_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmddelete.GotFocus
        cmdsave.Visible = False
        cmdsave.Enabled = False
        cmddelok.Enabled = False
        cmdupdate.Visible = False
        cmdupdate.Enabled = False
        cmddelok.Visible = True
    End Sub
    Private Sub cmdedit_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdedit.GotFocus
        cmdsave.Visible = False
        cmdsave.Enabled = False
        cmddelok.Visible = False
        cmddelok.Enabled = False
        cmdupdate.Visible = True
        cmdupdate.Enabled = False
    End Sub
    Private Sub cmdview_GotFocus(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdview.GotFocus
        cmdsave.Visible = False
        cmdsave.Enabled = False
        cmddelok.Enabled = False
        cmdupdate.Visible = False
        cmdupdate.Enabled = False
        cmddelok.Visible = True
    End Sub

    Private Sub txtemail_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtemail.KeyPress
        If Asc(e.KeyChar) = "13" Then
            cmdsave.Focus()
        End If
    End Sub
End Class

OUTPUT


Contact:
Mr. Roshan P. Helonde
Mobile: +91-7276355704
WhatsApp: +91-7276355704
Email: roshanphelonde@rediffmail.com
Share:

Total Pageviews

CONTACT US

Prof. Roshan P. Helonde
Mobile: +917276355704
WhatsApp: +917276355704
Email: roshanphelonde@rediffmail.com

Enter Project Title

Popular Projects

All Archive

Contact Form

Name

Email *

Message *