Rizq Technology – Exploring Your iDea.

Aplikasi Sederhana ODBC Visual Basic (Part 2).

8. Kembali pada project1.vbp pada program VB dan design form seperti di bawah ini.

9. Buatlah sebuah sample data di dalam tabel user.

10.  Don’t forget to pointing DataSource for DataGrid1 and choose Adodc1.

11. Double Click Command and fill with Command Script

Private Sub Command1_Click() 'Add Command
Adodc1.Recordset.AddNew
End Sub

Private Sub Command2_Click() 'Edit Command
Adodc1.Recordset.Update
End Sub

Private Sub Command3_Click()'Save Command
Adodc1.Recordset.Save
End Sub

Private Sub Command4_Click()'Delete Command
Adodc1.Recordset.Delete
End Sub

Private Sub Command6_Click()'Close Command
End
End Sub

12.  And running your application(F5).

13.  Click Add to adding record

14. Select record, Click Edit to Update record and then Save.

15. Select record, Click Delete to trash record.

16.  Lalu berlanjut pada part 3 untuk membuat report-nya.