How To Programmatically Construct The UpdateCommand For SqlDataSource

Hi, All

I'm using Gridview and SqlDataSource to dynamically display the contents in different tables, as followed:

<%
   dataSource.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["connectionString"];
   dataSource.SelectCommand = "SELECT * FROM " + tableName;
   gridView.DataBind();

   dataSource.UpdateCommand = "";
%>


<asp:SqlDataSource ID="dataSource" runat="server"></asp:SqlDataSource>

<asp:GridView ID="gridView" runat="server" DataSourceID="dataSource" AllowPaging="True" AllowSorting="True" AutoGenerateEditButton="True" BorderColor="Silver" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" PageSize="20" DataKeyNames="ID" OnRowDataBound="tableGridView_RowDataBound">
    <HeaderStyle BackColor="#C0C0FF" />
    <AlternatingRowStyle BackColor="#C0FFC0" />
</asp:GridView>


The datasource take the "tableName" as argument to determine which table to display. My problem is I can't figure out a way to programmatically construct the UpdataCommand for the SqlDataSource. I try to get the field names from the HeaderRow, but all the cells are empty in this row.

Does anyone know what causes the problem or how to construct the UpdateCommand properly. Thanks!