Need a good way to store data in a DB from a table on a webpage that can have N columns.
- by Abe Miessler
Users need to be able to add a specific type of column to an otherwise static table on my web page and then save the information they enter in there to the database.
I've been told that in reality they will almost never go over 5 columns but I would rather support N. The columns will all be of the same datatype.
My first thought was to have an XML column with the values from all added columns in there but I was curious if anyone else had come up with a better solution. Suggestions?