eddie_adl
September 13th, 2007, 01:22 AM
Hi,
-----------------------------------------------------------------
Date1 | Date2| Date3 |Total |
-----------------------------------------------------------------
Customer1 | | | | |
-----------------------------------------------------------------
Customer1 | | | | |
-----------------------------------------------------------------
Customer1 | | | | |
-----------------------------------------------------------------
Total | | | | |
-----------------------------------------------------------------
I need to implement a webform containing a table for showing/inserting/updating customers sales by date:
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
-----------------------------------------------------------------
Date1 | Date2| Date3 |Total |
-----------------------------------------------------------------
Customer1 | | | | |
-----------------------------------------------------------------
Customer1 | | | | |
-----------------------------------------------------------------
Customer1 | | | | |
-----------------------------------------------------------------
Total | | | | |
-----------------------------------------------------------------
I need to implement a webform containing a table for showing/inserting/updating customers sales by date:
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