User-313791273 posted
I developing a roster application (asp.net with VB + sql server) to let user input shift duty record, proposed screen as follows:

for the database design, each staff will have one record per day.
Column name:
staff_key, shift_date, start_time, end_time, shift_patten, SL, VL, ML, PH, APH, etc.
sample data:
123, 23-5-2011, 9:00, 17:00, A, N, N, N, N, N
123, 24-5-2011, 12:00, 19:00, B, N, N, N, N, N
123, 25-5-2011, 12:00, 19:00, B, N, N, N, N, N
I want to create a multi dimensional array to bind the gridview.
Is that correct that I create a arraylist (for 7 days) and then a subarray for each day ?
How can I create a 7 dimensional array & sub array under this 7-D array in asp.net + VB ?
Thanks
Joe