coding 4 nagar palika

Post on 11-Dec-2015

227 Views

Category:

Documents

0 Downloads

Preview:

Click to see full reader

DESCRIPTION

nagar palika project

TRANSCRIPT

BirthImports System.DataImports System.Data.OleDb

Public Class Birth Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Me.Close()End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() TextBox14.Clear() TextBox15.Clear() TextBox16.Clear() TextBox17.Clear() TextBox1.Focus() End Sub

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; data source=npn.mdb" End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click con.ConnectionString = str cmd.CommandText = "insert into Birth1 values('" & DateTimePicker1.Text & "','" & DateTimePicker2.Text & "', '" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & DateTimePicker3.Text & "','" & TextBox8.Text & "','" & TextBox9.Text & "','" & TextBox10.Text & "','" & TextBox11.Text & "','" & TextBox12.Text & "','" & TextBox13.Text & "','" & TextBox14.Text & "','" & TextBox15.Text & "','" & TextBox16.Text & "','" & TextBox17.Text & "')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Saved") End Sub

Private Sub Button3_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Me.Close() End SubEnd Class

BirthReg

Imports System.DataImports System.Data.OleDb

Public Class BirthReg Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; data source=npn.mdb" End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() TextBox14.Clear() TextBox1.Focus() End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click con.ConnectionString = str cmd.CommandText = " insert into BirthR values (" & TextBox1.Text & " , " & TextBox2.Text & " , ' " & TextBox3.Text & " ' , ' " & TextBox4.Text & " ' , ' " & TextBox5.Text & " ' , ' " & TextBox6.Text & " ' , ' " & TextBox7.Text & " ' , ' " & TextBox8.Text & " ' , ' " & DateTimePicker1.Text & " ' , ' " & TextBox9.Text & " ' , ' " & TextBox10.Text & " ' , ' " & TextBox11.Text & " ' , ' " & DateTimePicker2.Text & " ' , ' " & TextBox12.Text & " ' , " & TextBox13.Text & " , " & TextBox14.Text & " , ' " & DateTimePicker3.Text & " ' , ' " & DateTimePicker4.Text & " ')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Saved.............") End Sub

Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged TextBox12.Clear() TextBox12.Text = RadioButton1.Text End Sub Private Sub RadioButton2_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton2.CheckedChanged TextBox12.Clear() TextBox12.Text = RadioButton2.Text End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click BirthReg1.Show() Me.Hide() End Sub

Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click Me.Close() End SubEnd Class

BirthReg1

Imports System.DataImports System.Data.OleDb

Public Class BirthReg1 Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Me.Close() End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click BirthReg.Show() Me.Hide() End Sub

Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged TextBox10.Clear() TextBox10.Text = RadioButton1.Text End Sub

Private Sub RadioButton2_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton2.CheckedChanged TextBox10.Clear() TextBox10.Text = RadioButton2.Text End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click con.ConnectionString = str cmd.CommandText = "insert into BirthRI values(" & TextBox1.Text & " , " & TextBox2.Text & " , ' " & TextBox3.Text & " ' , ' " & TextBox10.Text & " ' , ' " & TextBox4.Text & " ' , ' " & TextBox5.Text & " ' , ' " & TextBox6.Text & " ' , ' " & TextBox7.Text & " ' , " & TextBox8.Text & " , " & TextBox9.Text & " , ' " & DateTimePicker1.Text & " ' , ' " & DateTimePicker2.Text & " ')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Saved") End Sub

Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click Me.Close()

End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox1.Focus()

End Sub

Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; data source=npn.mdb" End SubEnd Class

DeathInfo

Imports System.DataImports System.Data.OleDb

Public Class DeathInfo Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub Form6_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; data source=npn.mdb" End Sub

Private Sub RadioButton4_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton4.CheckedChanged TextBox23.Clear() TextBox23.Text = RadioButton4.Text End Sub

Private Sub RadioButton3_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton3.CheckedChanged TextBox23.Clear() TextBox23.Text = RadioButton3.Text End Sub

Private Sub RadioButton10_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton10.CheckedChanged TextBox24.Clear() TextBox24.Text = RadioButton10.Text End Sub

Private Sub RadioButton11_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton11.CheckedChanged TextBox24.Clear() TextBox24.Text = RadioButton11.Text End Sub

Private Sub RadioButton12_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton12.CheckedChanged TextBox25.Clear() TextBox25.Text = RadioButton12.Text End Sub

Private Sub RadioButton13_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton13.CheckedChanged TextBox25.Clear() TextBox25.Text = RadioButton13.Text End Sub

Private Sub RadioButton15_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton15.CheckedChanged

TextBox26.Clear() TextBox26.Text = RadioButton15.Text End Sub

Private Sub RadioButton14_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton14.CheckedChanged TextBox26.Clear() TextBox26.Text = RadioButton14.Text End Sub

Private Sub RadioButton5_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton5.CheckedChanged TextBox26.Clear() TextBox26.Text = RadioButton5.Text End Sub

Private Sub RadioButton6_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton6.CheckedChanged TextBox26.Clear() TextBox26.Text = RadioButton6.Text End Sub

Private Sub RadioButton7_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton7.CheckedChanged TextBox27.Clear() TextBox27.Text = RadioButton7.Text End Sub

Private Sub RadioButton8_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton8.CheckedChanged TextBox27.Clear() TextBox27.Text = RadioButton8.Text End Sub

Private Sub RadioButton9_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton9.CheckedChanged TextBox27.Clear() TextBox27.Text = RadioButton9.Text End Sub

Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged TextBox22.Clear() TextBox22.Text = RadioButton1.Text End Sub

Private Sub RadioButton2_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton2.CheckedChanged TextBox22.Clear() TextBox22.Text = RadioButton2.Text End Sub

Private Sub Button2_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click con.ConnectionString = str cmd.CommandText = "insert into MainR values(" & TextBox1.Text & " , " & TextBox2.Text & "," & TextBox3.Text & ",'" & DateTimePicker1.Text & "','" & DateTimePicker3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox22.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & TextBox8.Text & "','" & TextBox9.Text & "','" & TextBox10.Text & "','" & TextBox11.Text & "','" & TextBox12.Text & "','" & TextBox13.Text & "','" & TextBox14.Text & "','" &

TextBox23.Text & "','" & TextBox15.Text & "','" & TextBox16.Text & "','" & TextBox17.Text & "','" & TextBox18.Text & "','" & TextBox19.Text & "','" & TextBox20.Text & "','" & TextBox21.Text & "','" & TextBox24.Text & "','" & TextBox25.Text & "','" & TextBox26.Text & "','" & TextBox27.Text & "')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record saved") End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click DeathInfo1.Show() Me.Hide() End Sub

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

Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() TextBox14.Clear() TextBox15.Clear() TextBox16.Clear() TextBox17.Clear() TextBox18.Clear() TextBox19.Clear() TextBox20.Clear() TextBox21.Clear()

TextBox22.Clear() TextBox23.Clear() TextBox24.Clear() TextBox25.Clear() TextBox26.Clear() TextBox27.Clear() TextBox1.Focus()

End SubEnd Class

DeathInfo1

Imports System.DataImports System.Data.OleDb

Public Class DeathInfo1 Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) TextBox2.Clear() TextBox2.Text = RadioButton1.Text End Sub

Private Sub RadioButton2_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) TextBox2.Clear() TextBox2.Text = RadioButton2.Text End Sub

Private Sub RadioButton3_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) TextBox5.Clear() TextBox5.Text = RadioButton3.Text End Sub

Private Sub RadioButton4_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) TextBox5.Clear() TextBox5.Text = RadioButton4.Text End Sub

Private Sub RadioButton5_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) TextBox5.Clear() TextBox5.Text = RadioButton5.Text End Sub

Private Sub RadioButton1_CheckedChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged TextBox10.Clear() TextBox10.Text = RadioButton1.Text End Sub

Private Sub RadioButton2_CheckedChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton2.CheckedChanged

TextBox10.Clear() TextBox10.Text = RadioButton2.Text End Sub

Private Sub RadioButton3_CheckedChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton3.CheckedChanged TextBox11.Clear() TextBox11.Text = RadioButton3.Text End Sub

Private Sub RadioButton4_CheckedChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton4.CheckedChanged TextBox11.Clear() TextBox11.Text = RadioButton4.Text End Sub

Private Sub RadioButton5_CheckedChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton5.CheckedChanged TextBox11.Clear() TextBox11.Text = RadioButton5.Text End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click con.ConnectionString = str cmd.CommandText = "insert into MainRF values('" & TextBox1.Text & "'," & TextBox2.Text & ",'" & TextBox3.Text & "'," & TextBox4.Text & ",'" & TextBox5.Text & "'," & TextBox6.Text & ",'" & TextBox7.Text & "'," & TextBox8.Text & "," & TextBox9.Text & ",'" & DateTimePicker1.Text & "','" & DateTimePicker2.Text & "','" & TextBox10.Text & "','" & TextBox11.Text & "','" & TextBox12.Text & "','" & TextBox13.Text & "','" & RichTextBox1.Text & "')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record saved") End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() RichTextBox1.Clear() TextBox1.Focus()

End Sub

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

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

DeathInfo.Show() Me.Hide()

End Sub

Private Sub Form7_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; data source=npn.mdb" End SubEnd Class

DeathRegImports System.DataImports System.Data.oledb

Public Class DeathReg Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub Button4_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click Me.Close() End Sub

Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged TextBox13.Clear() TextBox13.Text = RadioButton1.Text End Sub

Private Sub RadioButton2_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton2.CheckedChanged TextBox13.Clear() TextBox13.Text = RadioButton2.Text End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click con.ConnectionString = str cmd.CommandText = "insert into DeathR values(" & TextBox1.Text & " , " & TextBox2.Text & " , ' " & TextBox3.Text & " ' , ' " & TextBox4.Text & " ',' " & TextBox5.Text & " ' , ' " & TextBox6.Text & " ' , ' " & TextBox7.Text & " ' , ' " & TextBox8.Text & " ' , ' " & TextBox9.Text & " ' , ' " & TextBox13.Text & " ' , ' " & TextBox10.Text & " ' , ' " & DateTimePicker1.Text & " ', " & TextBox11.Text & " , " & TextBox12.Text & " , ' " & DateTimePicker2.Text & " ' , ' " & DateTimePicker3.Text & " ')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Recard saved")

End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click DeathReg1.Show()

Me.Hide() End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() TextBox1.Focus() End Sub

Private Sub Form4_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; data source=npn.mdb" End SubEnd Class

DeathReg1

Imports System.DataImports System.Data.oledb

Public Class DeathReg1 Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click con.ConnectionString = str cmd.CommandText = "insert into DeathRI values(" & TextBox1.Text & " , " & TextBox2.Text & " , ' " & DateTimePicker1.Text & " ' , ' " & TextBox9.Text & " ' , ' " & TextBox3.Text & " ' , ' " & TextBox4.Text & " ' , ' " & TextBox5.Text & " ' , ' " & TextBox6.Text & " ' , " & TextBox7.Text & " , " & TextBox8.Text & " , ' " & DateTimePicker2.Text & " ' , ' " & DateTimePicker3.Text & " ')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Recard saved") End Sub

Private Sub RadioButton1_CheckedChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged TextBox9.Clear() TextBox9.Text = RadioButton1.Text End Sub

Private Sub RadioButton2_CheckedChanged_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton2.CheckedChanged TextBox9.Clear() TextBox9.Text = RadioButton2.Text End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear()

TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox1.Focus() End Sub

Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; data source=npn.mdb" End Sub

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

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click DeathReg.Show() Me.Hide() End SubEnd Class

LIC

Imports System.DataImports System.Data.OleDb

Public Class LIC Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click TextBox13.Clear() TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox14.Clear() TextBox12.Clear() TextBox25.Clear() TextBox26.Clear() TextBox13.Focus()End Sub

Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click

con.ConnectionString = str cmd.Connection = con cmd.CommandText = "insert into Lic values (" & TextBox13.Text & ",'" & TextBox1.Text & "','" & TextBox2.Text & "'," & TextBox3.Text & ",'" & TextBox4.Text & "','" & TextBox5.Text & "','" & DateTimePicker1.Text & "','" & DateTimePicker2.Text & "','" & TextBox8.Text & "'," & TextBox9.Text & ",'" & TextBox10.Text & "','" & TextBox11.Text & "','" & TextBox14.Text & "','" & TextBox12.Text & "','" & TextBox25.Text & "','" & TextBox26.Text & "','" & DateTimePicker3.Text & "')" con.Open() cmd.ExecuteNonQuery() con.Close()

MsgBox("Record Saved.........")

End Sub

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

Private Sub LIC_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load TextBox13.Focus() str = "Provider = Microsoft.Jet.Oledb.4.0; data source=npn.mdb"

End Sub

Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click con.ConnectionString = str cmd.Connection = con cmd.CommandText = "delete from LIC where name='" & TextBox1.Text & "'" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Deleted.........") End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click LIC2.Show() Me.Hide()End SubEnd Class

LIC2Imports System.DataImports System.Data.OleDb

Public Class LIC2 Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click TextBox22.Clear() TextBox1.Clear() TextBox23.Clear() TextBox3.Clear() TextBox19.Clear() TextBox18.Clear() TextBox20.Clear() TextBox1.Clear() TextBox5.Clear() TextBox4.Clear() TextBox6.Clear() TextBox22.Focus() End SubPrivate Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click con.ConnectionString = str cmd.Connection = con cmd.CommandText = " insert into Lic2 values (" & TextBox13.Text & "," & TextBox22.Text & ",'" & DateTimePicker1.Text & "','" & TextBox23.Text & "','" & TextBox3.Text & "'," & TextBox19.Text & ",'" & TextBox18.Text & "','" & DateTimePicker2.Text & "','" & TextBox20.Text & "'," & TextBox1.Text & ",'" & TextBox5.Text & "','" & TextBox4.Text & "'," & TextBox6.Text & ",'" & DateTimePicker3.Text & "')" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Saved.........") End SubPrivate Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click con.ConnectionString = str cmd.Connection = con

cmd.CommandText = "delete from Lic2 where name='" & TextBox1.Text & "'" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Deleted.........") End SubPrivate Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click Me.Close() End Sub Private Sub LIC2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load TextBox13.Text = LIC.TextBox13.Text str = "Provider = Microsoft.Jet.Oledb.4.0; data source=npn.mdb" End SubPrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click LIC.Show() Me.Hide()End SubEnd Class

PublicInsorance

Imports System.DataImports System.Data.OleDb

Public Class PublicInsorance Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox27.Clear() TextBox7.Clear() TextBox8.Clear() TextBox4.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() TextBox14.Clear() TextBox15.Clear() TextBox17.Clear() TextBox19.Clear() TextBox20.Clear() TextBox1.Focus() End Sub

Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click con.ConnectionString = strcmd.Connection = concmd.CommandText = " insert into Public_insurance1 values (" & TextBox1.Text & "," & TextBox2.Text & ",'" & TextBox3.Text & "','" & TextBox27.Text & "','" &

DateTimePicker1.Text & "','" & DateTimePicker2.Text & "'," & TextBox7.Text & ",'" & TextBox8.Text & "','" & TextBox4.Text & "','" & TextBox9.Text & "','" & TextBox10.Text & "','" & TextBox11.Text & "','" & TextBox12.Text & "','" & TextBox13.Text & "','" & TextBox14.Text & "','" & TextBox15.Text & "','" & DateTimePicker3.Text & "','" & TextBox17.Text & "','" & TextBox19.Text & "','" & TextBox20.Text & "')" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Saved.........") End Sub

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

Private Sub PublicInsorance_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "Provider = Microsoft.Jet.Oledb.4.0; data source=npn.mdb" End Sub

Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged TextBox27.Clear() TextBox27.Text = RadioButton1.Text

End Sub

Private Sub RadioButton2_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton2.CheckedChanged TextBox27.Clear() TextBox27.Text = RadioButton2.Text End SubEnd Class

SchoolershipImports System.DataImports System.Data.OleDb

Public Class Schoolership Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click TextBox1.Clear() TextBox24.Clear() TextBox23.Clear() TextBox22.Clear() TextBox21.Clear() TextBox20.Clear() TextBox19.Clear() TextBox1.Clear() TextBox15.Clear() TextBox16.Clear() TextBox7.Clear() TextBox26.Clear() TextBox1.Focus() End Sub

Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click con.ConnectionString = str cmd.Connection = con cmd.CommandText = " insert into Schoolership values (" & TextBox1.Text & ",'" & TextBox24.Text & "'," & TextBox23.Text & ",'" & TextBox22.Text & "','" & TextBox21.Text & "','" & TextBox20.Text & "','" & TextBox19.Text & "','" & DateTimePicker1.Text & "'," & TextBox15.Text & ",'" & TextBox16.Text & "','" & DateTimePicker2.Text & "','" & TextBox7.Text & "','" & TextBox26.Text & "','" & DateTimePicker3.Text & "')" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Saved.........") End Sub

Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click con.ConnectionString = str cmd.Connection = con cmd.CommandText = "delete from Schoolership where name='" & TextBox1.Text & "'" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Deleted.........") End Sub

Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click Me.Close() End Sub Private Sub Schoolership_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

str = "Provider = Microsoft.Jet.Oledb.4.0; data source=npn.mdb"

End SubEnd class

Viklang

Imports system.DataImports System.Data.OleDb

Public Class viklang Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click con.ConnectionString = str cmd.Connection = con cmd.CommandText = "insert into viklang values ( " & TextBox1.Text & ",' " & TextBox22.Text & " ', ' " & TextBox2.Text & " ', ' " & TextBox3.Text & " ' , ' " & TextBox4.Text & " ' ," & TextBox5.Text & " , " & TextBox6.Text & " ,' " & TextBox7.Text & " ' , ' " & TextBox8.Text & " ' , ' " & TextBox10.Text & " ' , ' " & TextBox11.Text & " ' ,' " & TextBox12.Text & " ', ' " & TextBox13.Text & " ' , " & TextBox14.Text & " , " & TextBox15.Text & " ,' " & TextBox16.Text & " ' ,' " & TextBox17.Text & " ' ,' " & TextBox18.Text & " ' ,' " & TextBox19.Text & " ' ,' " & TextBox20.Text & " ' ," & TextBox21.Text & " )" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("recod saved.......") End Sub

Private Sub viklang_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; Data Source =npn.mdb" End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click TextBox1.Clear() TextBox22.Clear() TextBox2.Clear()

TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox10.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() TextBox14.Clear() TextBox15.Clear() TextBox16.Clear() TextBox17.Clear() TextBox18.Clear() TextBox19.Clear() TextBox20.Clear() TextBox21.Clear() TextBox1.Focus() End Sub

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

Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) TextBox22.Clear() TextBox22.Text = RadioButton1.Text End Sub

Private Sub RadioButton2_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) TextBox22.Clear() TextBox22.Text = RadioButton2.Text End Sub

Private Sub TextBox22_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox22.TextChanged

End Sub

Private Sub RadioButton3_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) TextBox12.Clear() TextBox12.Text = RadioButton3.Text End Sub

Private Sub RadioButton4_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) TextBox12.Clear() TextBox12.Text = RadioButton4.Text End Sub

Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click viklang2.Show() End SubEnd Class

Viklang1Imports system.DataImports System.Data.OleDb

Public Class viklang1 Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub viklang1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; Data Source =npn.mdb" End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click con.ConnectionString = str cmd.Connection = con cmd.CommandText = "insert into viklang1 values ( ' " & TextBox1.Text & " ',' " & DateTimePicker2.Text & " ' , ' " & TextBox3.Text & " ' , ' " & TextBox4.Text & " ' ," & TextBox5.Text & " ,' " & TextBox6.Text & " ' ,' " & TextBox7.Text & " ' , ' " & TextBox8.Text & " ' ,' " & TextBox9.Text & " ', ' " & TextBox10.Text & " ' , ' " & TextBox11.Text & " ' , ' " & TextBox12.Text & " ' ,' " & TextBox13.Text & " ' , ' " & TextBox14.Text & " ' ," & TextBox15.Text & " , " & TextBox16.Text & " , " & TextBox17.Text & " ," & TextBox18.Text & " ,' " & TextBox19.Text & " ' ,' " & DateTimePicker1.Text & " ')" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("recod saved.......") End Sub

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

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click TextBox1.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() TextBox14.Clear() TextBox15.Clear() TextBox16.Clear() TextBox17.Clear() TextBox18.Clear() TextBox19.Clear() TextBox1.Focus() End SubEnd Class

desImports System.DataImports System.Data.oledb

Public Class des Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click con.ConnectionString = str cmd.CommandText = "insert into des values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & DateTimePicker1.Text & "')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("record saved.......") End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox1.Focus()

End Sub

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

Private Sub des_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; data source=np.mdb" End SubEnd Class

FFFFF

Imports System.DataImports System.Data.oledb

Public Class FFFFF Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click con.ConnectionString = str cmd.CommandText = "insert into FFFFF values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & TextBox8.Text & "','" & TextBox9.Text & "'," & TextBox10.Text & "," & TextBox11.Text & ")" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("record saved.......") End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear()

TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox1.Focus()

End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Me.Close() End Sub Private Sub FFFFF_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; data source=np.mdb" End SubEnd Class

GrampanchayatImports System.DataImports System.Data.OleDb

Public Class grampanchayat Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub grampanchayat_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "Provider = Microsoft.Jet.Oledb.4.0; data source=npn.mdb"

End SubPrivate Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click con.ConnectionString = str cmd.Connection = con cmd.CommandText = "insert into gramp values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & DateTimePicker1.Text & "','" & TextBox5.Text & "','" & TextBox16.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & TextBox8.Text & "','" & TextBox9.Text & "','" & TextBox10.Text & "','" & TextBox11.Text & "','" & TextBox12.Text & "','" & TextBox17.Text & "','" & DateTimePicker1.Text & "')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Saved.........")

End Sub

Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox5.Clear() TextBox16.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox17.Clear() TextBox1.Focus() End Sub

Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click Me.Close() End SubEnd Class

Hhhh

Imports System.DataImports System.Data.oledb

Public Class hhhh Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub hhhh_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Str = "provider=microsoft.jet.oledb.4.0; data source=np.mdb" End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox1.Focus() End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click con.ConnectionString = str cmd.CommandText = "insert into hhhh values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & DateTimePicker1.Text & "','" & TextBox7.Text & "','" & TextBox8.Text & "','" & TextBox9.Text & "')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("record saved.......") End Sub Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Me.Close() End SubEnd Class

House

Imports System.DataImports System.Data.OleDb

Public Class House Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub Form8_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; data source=npn.mdb" End Sub

Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click con.ConnectionString = str cmd.CommandText = "insert into OOMCS values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & TextBox8.Text & "','" & TextBox9.Text & "'," & TextBox10.Text & ",'" & DateTimePicker1.Text & "','" & DateTimePicker2.Text & "','" & DateTimePicker3.Text & "')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record saved") End Sub

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

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear()

TextBox1.Focus() End SubEnd Class

MarriageImports system.DataImports System.Data.OleDb

Public Class marriage Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() TextBox1.Focus()

End Sub

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

Private Sub Button1_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click con.ConnectionString = str cmd.Connection = con cmd.CommandText = "insert into enquiry values( " & TextBox1.Text & "," & TextBox2.Text & " , ' " & TextBox3.Text & " ' , ' " & TextBox4.Text & " ' ," & TextBox5.Text & " ,' " & TextBox6.Text & " ' ,' " & TextBox7.Text & " ' , ' " & TextBox8.Text & " ' ,' " & TextBox9.Text & " ' , " & TextBox10.Text & " , ' " & TextBox11.Text & " ' ,' " & TextBox12.Text & " ' , ' " & DateTimePicker1.Text & " ' ,' " & DateTimePicker2.Text & " ', " & TextBox13.Text & " ,' " & TextBox14.Text & " ')" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("recod saved.......")

End Sub

Private Sub marriage_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; Data Source =npn.mdb" End SubEnd Class

marriageReg

Imports System.DataImports System.Data.OleDb

Public Class marriegeReg Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "Provider = Microsoft.Jet.Oledb.4.0; data source=npn.mdb" End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click con.ConnectionString = str cmd.CommandText = "insert into Marrige values('" & TextBox19.Text & "','" & TextBox1.Text & "','" & DateTimePicker1.Text & "','" & TextBox3.Text & "'," & TextBox4.Text & ",'" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox13.Text &

"','" & TextBox10.Text & "','" & TextBox21.Text & "','" & TextBox7.Text & "','" & DateTimePicker2.Text & "','" & TextBox16.Text & "'," & TextBox17.Text & ",'" & TextBox18.Text & "','" & TextBox9.Text & "','" & TextBox15.Text & "','" & TextBox14.Text & "','" & TextBox11.Text & "','" & TextBox26.Text & "','" & TextBox25.Text & "','" & TextBox20.Text & "','" & TextBox8.Text & "','" & TextBox27.Text & "','" & TextBox29.Text & "','" & TextBox24.Text & "','" & TextBox23.Text & "','" & TextBox22.Text & "','" & TextBox21.Text & "')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Saved") End Sub

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

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click TextBox19.Clear() TextBox1.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox13.Clear() TextBox10.Clear() TextBox21.Clear() TextBox7.Clear() TextBox16.Clear() TextBox17.Clear() TextBox18.Clear() TextBox9.Clear() TextBox15.Clear() TextBox14.Clear() TextBox11.Clear() TextBox26.Clear() TextBox25.Clear() TextBox20.Clear() TextBox8.Clear() TextBox27.Clear() TextBox29.Clear() TextBox24.Clear()

TextBox23.Clear() TextBox22.Clear() TextBox21.Clear() TextBox19.Focus() End SubEnd Class

Nagar palika office community

Imports System.DataImports System.Data.OleDb

Public Class Nagarpalika_office_comuniti Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub Button8_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear()

TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() TextBox14.Clear() TextBox15.Clear() TextBox16.Clear() TextBox19.Clear() TextBox20.Clear() TextBox1.Focus() End Sub

Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click con.ConnectionString = str cmd.Connection = con cmd.CommandText = " insert into Nagarpalica_office_communication values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & TextBox8.Text & "','" & TextBox9.Text & "','" & TextBox10.Text & "','" & TextBox11.Text & "','" & TextBox12.Text & "','" & TextBox13.Text & "','" & TextBox14.Text & "','" & TextBox15.Text & "','" & TextBox16.Text & "','" & DateTimePicker1.Text & "','" & DateTimePicker2.Text & "','" & TextBox19.Text & "','" & TextBox20.Text & "')" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Saved.........") End Sub

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

Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click con.ConnectionString = str cmd.Connection = con

cmd.CommandText = "delete from Nagarpalica_office_communication where name='" & TextBox1.Text & "'" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Deleted.........") End SubPrivate Sub Nagarpalika_office_comuniti_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

str = "Provider = Microsoft.Jet.Oledb.4.0; data source=npn.mdb"

End SubEnd Class

PENSION

Imports System.DataImports System.Data.OleDb

Public Class PANTION Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub PANTION_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "Provider = Microsoft.Jet.Oledb.4.0; data source=npn.mdb"

End Sub Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click

con.ConnectionString = str cmd.Connection = con cmd.CommandText = "insert into np values ('" & TextBox40.Text & "','" & TextBox1.Text & "','" & TextBox42.Text & "','" & DateTimePicker1.Text & "','" & TextBox16.Text & "','" & TextBox23.Text & "','" & TextBox29.Text & "','" & TextBox35.Text & "','" & DateTimePicker2.Text & "','" & DateTimePicker3.Text & "','" & TextBox47.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox9.Text & "','" & TextBox20.Text & "','" & TextBox26.Text & "','" & TextBox32.Text & "','" & TextBox14.Text & "','" & TextBox4.Text & "','" & TextBox10.Text & "','" & TextBox19.Text & "','" & TextBox27.Text & "','" & TextBox33.Text & "','" & TextBox15.Text & "','" & TextBox5.Text & "','" & TextBox11.Text & "','" & TextBox22.Text & "','" & TextBox28.Text & "','" & TextBox34.Text & "')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Saved.........") End Sub

Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click TextBox40.Clear() TextBox42.Clear() TextBox1.Clear() TextBox42.Clear() TextBox16.Clear() TextBox23.Clear() TextBox29.Clear() TextBox35.Clear() TextBox47.Clear() TextBox2.Clear() TextBox3.Clear() TextBox9.Clear() TextBox20.Clear() TextBox26.Clear() TextBox32.Clear() TextBox14.Clear() TextBox4.Clear() TextBox10.Clear() TextBox19.Clear() TextBox27.Clear() TextBox33.Clear() TextBox15.Clear() TextBox5.Clear() TextBox11.Clear() TextBox22.Clear() TextBox28.Clear() TextBox34.Clear() TextBox1.Focus() End Sub Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click Me.Close() End Sub

Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged TextBox1.Clear() TextBox1.Text = RadioButton1.Text End Sub

Private Sub RadioButton2_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton2.CheckedChanged TextBox1.Clear()

TextBox1.Text = RadioButton2.Text End Sub

Private Sub RadioButton3_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton3.CheckedChanged TextBox1.Clear() TextBox1.Text = RadioButton3.Text End Sub

Private Sub RadioButton4_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton4.CheckedChanged TextBox1.Clear() TextBox1.Text = RadioButton4.Text End SubEnd Class

Vpantion

Imports system.DataImports System.Data.OleDb

Public Class vpantion Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub vpantion_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; Data Source =npn.mdb" End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

con.ConnectionString = str cmd.Connection = con cmd.CommandText = "insert into vpantion values(' " & TextBox1.Text & " ',' " & TextBox2.Text & " ' ,' " & DateTimePicker1.Text & " ',' " & TextBox3.Text & " ' , " & TextBox4.Text & " ,' " & TextBox5.Text & " ',' " & TextBox6.Text & " ' ,' " & TextBox7.Text & " ' , ' " & DateTimePicker2.Text & " ',' " & TextBox8.Text & " ' , " & TextBox9.Text & " , " & TextBox10.Text & " , ' " & TextBox11.Text & " ' , ' " & TextBox12.Text & " ' , " & TextBox13.Text & " , ' " & TextBox14.Text & " ' , " & TextBox15.Text & " , " & TextBox16.Text & " ,' " & TextBox17.Text & " ' ,' " & TextBox18.Text & " ' , " & TextBox19.Text & " ,' " & TextBox20.Text & " ' , " & TextBox21.Text & " ," & TextBox22.Text & " ,' " & TextBox23.Text & " ' ,' " & TextBox24.Text & " ' ," & TextBox25.Text & " ,' " & TextBox26.Text & " ' , " & TextBox27.Text & " , " & TextBox28.Text & " ,' " & TextBox29.Text & " ' ,' " & TextBox30.Text & " ' ," & TextBox31.Text & " ,' " & TextBox32.Text & " ' ," & TextBox33.Text & " ," & TextBox34.Text & " ,' " & TextBox35.Text & " ' ,' " & TextBox36.Text & " ' , " & TextBox37.Text & " ,' " & TextBox38.Text & " ' , " & TextBox39.Text & " )" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("recod saved.......") End Sub

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

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() TextBox15.Clear() TextBox16.Clear() TextBox14.Clear() TextBox18.Clear() TextBox17.Clear() TextBox19.Clear() TextBox23.Clear() TextBox20.Clear() TextBox21.Clear()

TextBox22.Clear() TextBox23.Clear() TextBox24.Clear() TextBox25.Clear() TextBox26.Clear() TextBox27.Clear() TextBox28.Clear() TextBox29.Clear() TextBox30.Clear() TextBox31.Clear() TextBox32.Clear() TextBox33.Clear() TextBox34.Clear() TextBox35.Clear() TextBox36.Clear() TextBox37.Clear() TextBox38.Clear() TextBox39.Clear() TextBox1.Focus() End SubEnd Class

WaterImports System.DataImports System.Data.OleDb

Public Class water Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub water_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "Provider = Microsoft.Jet.Oledb.4.0; data source=npn.mdb" End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click con.ConnectionString = str cmd.Connection = con cmd.CommandText = "insert into supply values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & DateTimePicker1.Text & "','" & TextBox4.Text & "','" & TextBox13.Text & "','" & TextBox14.Text & "','" & TextBox32.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & TextBox8.Text & "','" & TextBox9.Text & "','" & TextBox11.Text & "','" & TextBox15.Text & "','" &

TextBox12.Text & "','" & TextBox16.Text & "','" & TextBox17.Text & "','" & TextBox24.Text & "','" & TextBox19.Text & "','" & TextBox22.Text & "','" & TextBox23.Text & "','" & TextBox25.Text & "','" & TextBox26.Text & "')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("Record Saved.........") End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Clear() TextBox2.Clear() TextBox4.Clear() TextBox13.Clear() TextBox32.Clear() TextBox14.Clear() TextBox5.Clear() TextBox8.Clear() TextBox6.Clear() TextBox7.Clear() TextBox11.Clear() TextBox9.Clear() TextBox15.Clear() TextBox12.Clear() TextBox16.Clear() TextBox17.Clear() TextBox24.Clear() TextBox19.Clear() TextBox22.Clear() TextBox23.Clear() TextBox25.Clear() TextBox26.Clear() TextBox1.Focus() End Sub

Private Sub Cancle_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Cancle.Click Me.Close() End SubEnd Class

WaterconImports system.DataImports System.Data.OleDb

Public Class watercon Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand Private Sub watercon_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; Data Source =npn.mdb" End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click con.ConnectionString = str cmd.Connection = con cmd.CommandText = "insert into wtrcon values ( " & TextBox1.Text & " ," & TextBox2.Text & " ,' " & DateTimePicker1.Text & " ',' " & TextBox3.Text & " ' ,' " &

TextBox4.Text & " ' , " & TextBox5.Text & " ,' " & TextBox6.Text & " ' , " & TextBox7.Text & " ,' " & TextBox8.Text & " ',' " & TextBox9.Text & " ', ' " & TextBox10.Text & " ' , ' " & TextBox11.Text & " ' , " & TextBox12.Text & " ,' " & TextBox13.Text & " ' ,' " & TextBox14.Text & " ' , " & TextBox15.Text & " ,' " & DateTimePicker2.Text & " ', ' " & TextBox16.Text & " ' ,' " & TextBox17.Text & " ',' " & TextBox18.Text & " ')" con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("recod saved.......") End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear() TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox9.Clear() TextBox8.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() TextBox15.Clear() TextBox16.Clear() TextBox14.Clear() TextBox18.Clear() TextBox17.Clear() TextBox18.Clear() TextBox1.Focus() End Sub

Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Me.Close() End SubEnd Class

YyyyImports System.DataImports System.Data.oledb

Public Class yyyy Dim str As String Dim con As New OleDbConnection Dim cmd As New OleDbCommand

Private Sub yyyy_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load str = "provider=microsoft.jet.oledb.4.0; data source=npn.mdb" End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.Clear() TextBox2.Clear() TextBox3.Clear() TextBox4.Clear()

TextBox5.Clear() TextBox6.Clear() TextBox7.Clear() TextBox8.Clear() TextBox9.Clear() TextBox10.Clear() TextBox11.Clear() TextBox12.Clear() TextBox13.Clear() TextBox14.Clear() TextBox15.Clear() TextBox16.Clear() TextBox17.Clear() TextBox1.Focus() End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click con.ConnectionString = str cmd.CommandText = "insert into marrige1 values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & TextBox8.Text & "','" & TextBox9.Text & "','" & TextBox10.Text & "','" & TextBox11.Text & "','" & TextBox12.Text & "','" & TextBox13.Text & "','" & TextBox14.Text & "','" & TextBox15.Text & "','" & TextBox16.Text & "','" & TextBox17.Text & "')" cmd.Connection = con con.Open() cmd.ExecuteNonQuery() con.Close() MsgBox("record saved.......") End SubPrivate Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Me.Close() End Sub

Private Sub Button3_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Me.Close() End SubEnd Class

top related