Dynamic 3d Drag n Drop Gridview
dynamic 3d drag n drop gridview
------------------------------
Hi, i need to come out a 3d drag and drop grid view for user to arrange the item inside it for priority arrangement.
Let me explain the scenario further :
I have a table from database and its data is as blow:
-----------------------------------------------------------------------
LineNo |DateDay |Date |Shift |Project No|ItemNo|ItemQty| AvailHr
-----------------------------------------------------------------------
1.1 |Monday |1/2/2010 |x1 |y1 | z1 | 100 | 0.5
1.1 |Monday |1/2/2010 |x1 |y1 | z2 | 150 | 0.2
1.1 |Monday |1/2/2010 |x1 |y1 | z3 | 120 | 0.3
1.1 |Monday |1/2/2010 |x2 |y2 | z4 | 105 | 0.1
2.1 |Tuesday |2/2/2010 |x1 |y1 | z1 | 100 | 0.5
2.1 |Tuesday |2/2/2010 |x1 |y1 | z2 | 150 | 0.9
2.1 |Tuesday |2/2/2010 |x1 |y1 | z3 | 120 | 0.7
2.1 |Tuesday |2/2/2010 |x2 |y2 | z4 | 105 | 0.1
I need to rearrange the data above in gridview in the following format
--------------------------------------------------------------------------------------------------------
| Monday | Tuesday
------------------------------------------------------------------------------------------------------------
| 1/2/2010 | 2/2/2010
------------------------------------------------------------------------------------------------------------
| X1 | X2 | x1 | x2
-------------------------------------------------------------------------------------------------------------
1.1 | ItemNo: z1 | Qty=100 | ItemNo: z4 | Qty=105 |
| ItemNo: z2 | Qty=150
| ItemNo: z3 | Qty=120
Ttl Avail Hr:1.0
---------------------------------------------------------------------------
2.1 | ItemNo: z1 | Qty=100 | ItemNo: z4 | Qty=105
| ItemNo: z2 | Qty=150
| ItemNo: z3 | Qty=120
(1).There is 3 column header within a column that is Day of The Week (Monday), Date and also the Shift.Within the Shift itself it is split to multiple shift.There is another column beside the gridview that is line no which make up the gridview to 3 dimension.All the header text are dynamic.
(2).User are allow to drag n drop the item in the grid to arrange the priority of the item. For example the row (in bold color) are able to be drag and drop within the gridview.
Coding Issue
(1).After studying the logic , i find that it is impossible to use gridview.datasource method.I need to create the header dynamically and also the column and then according to the header and column title pump in the data.Does anyone has idea on 3 d gridview?
