[RESOLVED] Developing a two demensional grid on a form

Hi Teches

I have been requested to develop a two demensional grid in which data can be entered on a form. I am working with VB.Net on a windows 2000 system and an Access DB. The columns of this grid will be months and the rows will be entries for the months. Additionally I have been requested to have prior and next buttons to bump down to prior months and bump up to future months. The grid must rotate to the left for prior months and to the right for future months. I have attempted using the Datagrid function but find it too restrictive. I am currrently looking at adding approximately 80 textboxes to the form but this is very tedious. Can ahyone offer a simpler alternative?

A picture says a thousand words.... Perhaps if you include a sketch of what your grid should look like it will help a lot in trying to visualize it.

What is restrictive about the Datagrid?

I can think of a potentially twisted solution involving a ListView and a phantom TextBox, but I can't imagine what advantage it would have over the DataGrid.

As I understand the datagrid functionality through its properties I can point to a dataset which points to the database. I can't rotate my columns without an index/pointer from the database.


Example:

prior 2006 next
Jan Feb March April
Entry 1 xx yy zz 99
Entry 2 pp qq rr 88

After pressing the prior button the imagry should look like this.

prior 2005 next

Dec Jan Feb March
Entry 1 aa xx yy zz
Entry 2 bb pp qq rr

Do you guys have any suggestions?

What exactly does this data look like in the database? I don't see how you can possibly have a column for each month because that would mean that the number of columns in your table would keep growing indefinitely. If that is indeed how your data is structured then that's a MAJOR flaw. If it's not and you are massaging the data into that form in code then there's no reason that you also can't remove a column at one end and add one at the other when the user wants to go forward or back by month. You could do so by either changing the visibility of columns in the grid, adding and removing columns in your data source or shuffling data in existing columns. That's basically what you'd be doing with individual controls anyway.