Create application for an advocate management system.
Table: client_infor.
Fields: case_no, client_name, vs_name, act_no,
date_of_submission, court.
Imports System.Data.OleDb
Public Class app1
Dim cn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\Roshni\VB.net\final assignment of vb\Database3.accdb")
Dim adp As New OleDbDataAdapter("select * from client_infor", cn)
Dim ds As New DataSet
Dim bs As New BindingSource
Dim cmd As New OleDbCommandBuilder
Private Sub app1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
cmd = New OleDbCommandBuilder(adp)
adp.Fill(ds, "t1")
bs.DataSource = ds
bs.DataMember = "t1"
TextBox1.DataBindings.Add("text", bs, "case_no")
TextBox2.DataBindings.Add("text", bs, "client_name")
TextBox3.DataBindings.Add("text", bs, "VS_name")
TextBox4.DataBindings.Add("text", bs, "act_no")
TextBox5.DataBindings.Add("text", bs, "date_of_submission")
TextBox6.DataBindings.Add("text", bs, "court")
End Sub
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
bs.MoveFirst()
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
bs.MoveNext()
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
bs.MoveLast()
End Sub
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
bs.MovePrevious()
End Sub
Private Sub Button8_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button8.Click
bs.AddNew()
End Sub
Private Sub Button7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button7.Click
bs.EndEdit()
adp.Update(ds, "t1")
End Sub
Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
Button7_Click(Nothing, Nothing)
End Sub
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
bs.RemoveCurrent()
Button7_Click(Nothing, Nothing)
End Sub
End Class
Made By: Yadav Roshani R. from Third Year of BCA
Comments
Post a Comment