[Solved] RadGrid with dynamic datasource and batch edit

[Lauren]

I've figured out how to create a RadGrid in batch edit mode, and I've figured out how to change the RadGrid's datasource from a DropDownList of table names... but I'm having trouble combining the two.

Once I switch from a hard-coded datasource (a single table) to the dynamic one, I lose the ability to automatically update/insert/delete.  But I can't realistically manually create CRUD operations for the hundreds of tables in my DropDownList.

Is there a way to use the command parameter to control the table?  I tried it like this, but it doesn't work:

  <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>" SelectCommand="SELECT * FROM @Table">
<SelectParameters>
    <asp:ControlParameter ControlID="DropDownList1" Name="Table" PropertyName="SelectedValue" Type="String" />
</SelectParameters>

[Konstantin Dikov]

Hello Lauren,

It is not possible to set the table name from a parameter, but you could change the SelectCommand on server-side, depending on the selected value in the DropDownList. You could take a look at the following forum thread for additional information on this matter:

• Must declare the table variable @table

However, please have in mind that Automatic CRUD operations will work only if the DataSource control is set correctly (thus including the Update, Insert and Delete commands). Detailed information on the automatic CRUD operations is available at the following help article:

• Automatic DataSource Operations

Hope this helps.


Regards,
Konstantin Dikov
Telerik