Private Sub picsave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles picsave.Click
FillDataGrid("UPDATE tblstreetss set streets='" & Trim(txtstreets.Text) & "',Purok='" & Trim(cmbpurok.Text) & "' where ID=" &
frmstreets1.dgvstreets.CurrentRow.Cells(0).Value & "", frmstreets1.dgvstreets) Me.Close() frmstreets1.loadstreets() End Sub SEARCH STREETS
Private Sub txtserch_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtserch.TextChanged
FillDataGrid("SELECT * FROM tblstreetss WHERE streets like '" & Trim(txtserch.Text) & "%' or Purok like '" & Trim(txtserch.Text) & "%'", dgvstreets)
End Sub
PRINTING OF RESIDENTS Imports System.Data.OleDb Public Class frmprinting
Dim kom As New OleDbCommand Dim da As New OleDbDataAdapter
Dim dset, dset2, dset3, dsetDel, dsetDept, dsetKors As New DataSet
Private Sub frmprinting_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If switchPRint = 1 Then Dim cr As New Officials
da = New OleDbDataAdapter("select * from tblofficials", ultracon) dset = New DataSet
da.Fill(dset, "tblofficials") cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 2 Then
Dim cr As New Residents
da = New OleDbDataAdapter("select * from tblinfo", ultracon) dset = New DataSet
da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 3 Then
Dim cr As New R_established
da = New OleDbDataAdapter("select * from tblestablishment", ultracon)
dset = New DataSet
da.Fill(dset, "tblestablishment") cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 6 Then
Dim cr As New rpp
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 7 Then
Dim cr As New rpp1
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "'and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "'", ultracon) dset = New DataSet
da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 8 Then
Dim cr As New year
da = New OleDbDataAdapter("select * from tblofficials where year='" & (frmservice.cmbelected.Text) & "'", ultracon)
dset = New DataSet
da.Fill(dset, "tblofficials") cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 9 Then
Dim cr As New rpp2
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Gender]='" &
frmprintresidents.cmbgender.Text & "'", ultracon) dset = New DataSet
da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 10 Then
Dim cr As New rpp3
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Streets]='" &
frmprintresidents.cmbstreets.Text & "'", ultracon) dset = New DataSet
da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 11 Then
Dim cr As New rpp4
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Citizenship]='" &
frmprintresidents.cmbcitizen.Text & "'", ultracon) dset = New DataSet
da.Fill(dset, "tblinfo") cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset) CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh() 83
ElseIf switchPRint = 12 Then
Dim cr As New rpp5
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Religion]='" &
frmprintresidents.cmbreligion.Text & "'", ultracon) dset = New DataSet
da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 13 Then
Dim cr As New rpp6
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Gender]='" & frmprintresidents.cmbgender.Text & "'", ultracon) dset = New DataSet
da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 14 Then
Dim cr As New rpp7
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Streets]='" & frmprintresidents.cmbstreets.Text & "'", ultracon) dset = New DataSet
da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 15 Then
Dim cr As New rpp8
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "'", ultracon) dset = New DataSet
da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 16 Then
Dim cr As New rpp9
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 17 Then
Dim cr As New rpp10
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Gender]='" & frmprintresidents.cmbgender.Text & "' and [Streets]='" & frmprintresidents.cmbstreets.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 18 Then
Dim cr As New rpp11
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Gender]='" & frmprintresidents.cmbgender.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 19 Then
Dim cr As New rpp12
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='"
&frmprintresidents.cmbstat.Text & "' and [Gender]='" & frmprintresidents.cmbgender.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 20 Then
Dim cr As New rpp13
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Gender]='" & frmprintresidents.cmbgender.Text & "' and [Streets]='" & frmprintresidents.cmbstreets.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 21 Then
Dim cr As New rpp14
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Gender]='" & frmprintresidents.cmbgender.Text & "' and [Streets]='" & frmprintresidents.cmbstreets.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 22 Then
Dim cr As New rpp15
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Gender]='" &
frmprintresidents.cmbgender.Text & "' and [Streets]='" & frmprintresidents.cmbstreets.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 23 Then
Dim cr As New rpp16
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Gender]='" &
frmprintresidents.cmbgender.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 24 Then
Dim cr As New rpp17
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Gender]='" &
frmprintresidents.cmbgender.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 25 Then
Dim cr As New rpp18
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Streets]='" &
frmprintresidents.cmbstreets.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 26 Then
Dim cr As New rpp19
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Streets]='" &
frmprintresidents.cmbstreets.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 27 Then
Dim cr As New rpp20
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Religion]='" &
frmprintresidents.cmbreligion.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 28 Then
Dim cr As New rpp21
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Gender]='" &
frmprintresidents.cmbgender.Text & "' and [Streets]='" & frmprintresidents.cmbstreets.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 29 Then
Dim cr As New rpp22
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Gender]='" &
frmprintresidents.cmbgender.Text & "' and [Streets]='" & frmprintresidents.cmbstreets.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 30 Then
Dim cr As New rpp23
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Gender]='" &
frmprintresidents.cmbgender.Text & "' and [Streets]='" & frmprintresidents.cmbstreets.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 31 Then
Dim cr As New rpp24
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Streets]='" & frmprintresidents.cmbstreets.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 32 Then
Dim cr As New rpp25
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Gender]='" & frmprintresidents.cmbgender.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo") cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset) CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh() 90
ElseIf switchPRint = 33 Then
Dim cr As New rpp26
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Gender]='" &
frmprintresidents.cmbgender.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 34 Then
Dim cr As New rpp27
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 35 Then
Dim cr As New rpp28
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Streets]='" &
frmprintresidents.cmbstreets.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo") cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset) CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh() 91
ElseIf switchPRint = 36 Then
Dim cr As New rpp29
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Streets]='" & frmprintresidents.cmbstreets.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 37 Then Dim cr As New rppofficials
da = New OleDbDataAdapter("select * from tblofficials where [Position]='" & frmprintingofficials.cmbposition.Text & "' and [year]='" & frmprintingofficials.cmbelected.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblofficials") cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 38 Then Dim cr As New rpp30
da = New OleDbDataAdapter("select * from tbltotal ", ultracon) dset = New DataSet
da.Fill(dset, "tbltotal")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 39 Then
Dim cr As New R_established
da = New OleDbDataAdapter("select * from tblestablishment where [PUROK]='" & printestblishment.cmbpurok.Text & "' and [STREETS]='" & printestblishment.cmbstreets.Text & "'", ultracon)
dset = New DataSet
da.Fill(dset, "tblestablishment") cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 40 Then
Dim cr As New rpp31
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Streets]='" &
frmprintresidents.cmbstreets.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 41 Then Dim cr As New rpp32
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & frmprintresidents.cmbpurok.Text & "' and [Civilstatus]='" &
frmprintresidents.cmbstat.Text & "' and [Gender]='" & frmprintresidents.cmbgender.Text & "' and [Streets]='" & frmprintresidents.cmbstreets.Text & "' and [Religion]='" & frmprintresidents.cmbreligion.Text & "' and [Citizenship]='" & frmprintresidents.cmbcitizen.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo") cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset) CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh() 93
ElseIf switchPRint = 42 Then Dim cr As New rpp33
da = New OleDbDataAdapter("select * from tbltotal ", ultracon) dset = New DataSet
da.Fill(dset, "tbltotal")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 43 Then Dim cr As New rppdeceased
da = New OleDbDataAdapter("select * from tblarchive ", ultracon) dset = New DataSet
da.Fill(dset, "tblarchive")
cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset)
CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh()
ElseIf switchPRint = 44 Then Dim cr As New rpp34
da = New OleDbDataAdapter("select * from tblinfo where [Zone]='" & PrintEducational_Attainment.cmbpurok.Text & "' and [Attainment]='" & PrintEducational_Attainment.cmbattainment.Text & "'", ultracon)
dset = New DataSet da.Fill(dset, "tblinfo") cr.SetDatabaseLogon("", "123") cr.SetDataSource(dset) CrystalReportViewer1.ReportSource = cr CrystalReportViewer1.Refresh() Refresh() End If End Sub Sub delete()
FillDataGrid("delete from tbltotal", frmstatistic.dgvtotal) End Sub