[Solved] RadGrid insert/update/delete with dynamic columns

[Syazwan Ahmad]

Hello.

Telerik version: 2009.2.701.20
Database: MySQL 5

I have a page with 2 controls, RadComboBox and RadGrid.

RadComboBox lists the tables I have in my database, databound onload. RadGrid then loads the table content via ajax.

Now problem comes when I want the Insert/Update/Delete functionality. So far all examples and demos I have found requires the use of declarative approach. I cannot do this when  I do not know exactly how many columns there will be, and what the column names are.

Although they share the same primary key, they may have additional columns.

Is this possible?

[Shinu]

Hi Syazwan,

As far as I understood Select and Delete functionality won't be a problem for you. But Insert and Update operation requires the column names to be specified in their respective Insert/Update Command . So one suggestion would to set the DataSource for the Grid in the SelectedIndexChanged event of the RadCombobox and then loop through the column collection and then access the column names. Once you get the column names you may generate the Insert/Update command query dynamically.

Thanks
Shinu.