Questions
I have problem in Visual Basic Database Programming. How to Create (Add) , Delete, Save (Update), First, Previous, Next, Last data which there is a lot of conditions in one form. There are a lot of table which are used in one form.
Here are the questions
1. Which components is the best in create, saved or delete data ? Using DataGrid, or DBGrid or TrueDBGrid ? Can You explain to me or give some reference?
2. For example, I want to Add/Create data in datagrid which have 5 columns when I press Enter the cursor in the last column. Move to the First Column at next Rows. How’s the logic in VB Programming ? Would you please give us source code for explanation or you can give us source code with case inside
3. How to create datagrid which contains 2 tables. The first Table for caption datagrid, and the seconds for details ? For example :
Table A
No Fields Example Data
1 JobNo Primary Key 100
2 Size01 S
3 Size02 M
4 Size03 L
Table B
No Fields
1 JobNo Primary Key 100
2 Qty01 Quantity for table A, fields Size01 10
3 Qty02 Quantity for table A, fields Size02 20
4 Qty03 Quantity for table A, fields Size03 30
DataGrid
Job No S M L
100 10 20 30
How is characteristic of DataGrid,
Main point is :
Please give us some samples sources code for datagrid or references in datagrid. In this case create, save, delete and navigation buttons using datagrid which have a lot of table used.
