Hi All
Is there any simpler way of doing this ? Has anyone done it before? Would apperciate some help.
Michael
I have a requirement to have a grid that can display, update, insert and delete items from multiple tables. I will have a dropdown list which contains the list of tables and then a grid which is bound when a dropdown list item is selected. The grid is setup to generate the columns headers at runtime.
I basically have a function that takes a table name and returns the data for that table. Select * from "table_name".
The problem comes when I need to insert, update and delete. The grid control requires me to bind to a ObjectDataSource or SQLDataSource control. I obviously cannot use a SQLDataSource as the table / select statement changes. A ObjectDataSource could bind to a class that some how constructed the statements on the fly but you start to get issues.
Is there any simpler way of doing this ? Has anyone done it before? Would apperciate some help.
Thanks
Michael