Advertisement
jeqx

error code

Apr 4th, 2020
14
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. Public Sub GetRecords()
  2. sql = "select [ID], [Patient's Name], [Treatment Details], [Prescribed Medicines] from [tbl_TreatmentsRecords]"
  3.  
  4. con.Open()
  5. ds = New DataSet
  6. da = New OleDb.OleDbDataAdapter(sql, con)
  7. da.Fill(ds, "tbl_TreatmentsRecords")
  8.  
  9. DataGridViewTreatmentRecordsNurseBillingPage.DataSource = ds
  10. DataGridViewTreatmentRecordsNurseBillingPage.DataMember = "tbl_TreatmentsRecords" 'the ds(dataset) contain a table called tbl_accounts
  11. con.Close()
  12. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement