Building a custom (dynamic) dataset and grid
- by marko.ivanovski.nz
Hi,
I'm in the process of building a dynamic table in which you can add/remove rows & columns so it varies in size depending on what the user wants.
Its purpose is to store properties for a product, but there can be from 1 to 10 different properties(columns) per product, and multiple instances(rows) of the product as well.
Here's a screenshot of what I mean http://i40.tinypic.com/nbqkxc.jpg
As you can see I need the structure to be completely up to the client which is where I'm getting stuck.
I've started writing a custom DataSet that has "add column" & "add row" buttons, and have built a custom Table with Textboxes in each cell which builds from that dataset.
I have no idea how to store the data on submit though, and to make it even more complex I need to store this in the database as a string which I think I can do by converting it to XML.
Any help is appreciated, I think I just need a pointer in the right direction and am happy to do research from there.
Thanks in advance.
Marko