Hi,
datagrid fields
name, birthday, number, company, product, quantity
click on the Save button
customer table
name, number, birth day must record fields.
list table
company, product, quantity must record fields.
I'm trying VB6, SQL Server
Printable View
Hi,
datagrid fields
name, birthday, number, company, product, quantity
click on the Save button
customer table
name, number, birth day must record fields.
list table
company, product, quantity must record fields.
I'm trying VB6, SQL Server
You'll need to read the data from the grid or the recordset behind the grid then build the proper update statements to update you tables
i.e. Update CustomerTable Set [Name]='Whatever', Number=0, Birthday='10/31/2013'
I'm sorry I could not understand.
When I select the first grid, the user's operations are appearing in second field. I want to save the fields which are in grid, to separate statement.
There is not nearly enough info to give a specific answer. We also do not know what if any coding you understand.
The basic process is as I described before
[all of this would be in a loop if you are wanting to do multiple rows]
Read the data from the grid
Build an update query to update the first table with the values from the columns you want from the grid
Build an update query to update the second table with the values from the columns you want from the grid
[repeat as needed]