eddie_adl
09-13-2007, 01:32 AM
Hi,
I need to implement a webform containing a table for showing/inserting/updating customers sales by date:
Date1 Date2 Date3 Total
Customer1
Customer2
Customer3
Total
The data is filled from a SQL Server database.
The X axis (dates) is always all the days of the actual week (constant). The y axis is dynamic. The total fields have to be calculated automatically.
The user have to fill the blank fields (sales for customer by date). Every field in the table should be inserted in the database as a record (Date, Customer, Sales).
How is recommended to build the table, in order to be able to fill the table with the relevent values from the DB and than to be able to update the DB ?
Thanks,
Eddie
I need to implement a webform containing a table for showing/inserting/updating customers sales by date:
Date1 Date2 Date3 Total
Customer1
Customer2
Customer3
Total
The data is filled from a SQL Server database.
The X axis (dates) is always all the days of the actual week (constant). The y axis is dynamic. The total fields have to be calculated automatically.
The user have to fill the blank fields (sales for customer by date). Every field in the table should be inserted in the database as a record (Date, Customer, Sales).
How is recommended to build the table, in order to be able to fill the table with the relevent values from the DB and than to be able to update the DB ?
Thanks,
Eddie