User created data stored in a table like structure

hafizarslan

New Member
I have an asp.net 4.0 c# application where a user is now going to be able to create a table and store data in that table. One thing that has been decided for version 1 is once the table is created it can't be edited this is purely for making it less complicated. It would be nice to have a solution to where the schema could be edited also. My first thought is to have a table in the db and each row would represent each "table", one column would store the schema in xml and then a second column would store the data. When trying to pull the data I would read the xml into a datatable work with the data and then save it back out to xml in the db. Any thoughts suggestions or links to others trying this would be greatly appreciated!Thanks in advance.
 
Back
Top