是否可以使用可变数量的列更新GridView？

问题描述：

我有一个GridView链接到一个SQL表。表具有未知或可变数量的列。列的数量和列的名称都是可变的。是否有可能在sqlDataSource中设置动态UpdateCommand，以便我可以更新每一列？如是;怎么样？是否可以使用可变数量的列更新GridView？

代码我想：

<asp:GridView ID="GridView1" AutoGenerateColumns="True" ShowHeaderWhenEmpty ="True" DataSourceID="UpdateSqlDataSource" 
    CssClass = "table" runat="server" AllowSorting="True" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" 
    CellPadding="3" DataKeyNames="UpdateID" ShowFooter="True" 
    AutoGenerateDeleteButton="true" AutoGenerateSelectButton ="true" AutoGenerateEditButton="true"> 
    <AlternatingRowStyle BackColor="#F7F7F7" /> 
    <Columns> 
    </Columns> 
    <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" /> 
    <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" /> 
    <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" /> 
    <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" /> 
    <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" /> 
    <SortedAscendingCellStyle BackColor="#F4F4FD" /> 
    <SortedAscendingHeaderStyle BackColor="#5A4C9D" /> 
    <SortedDescendingCellStyle BackColor="#D8D8F0" /> 
    <SortedDescendingHeaderStyle BackColor="#3E3277" /> 
</asp:GridView> 
<asp:SqlDataSource ID ="UpdateSqlDataSource" runat ="server" ConnectionString="<%$ ConnectionStrings:MachineUpdateDataBaseConnectionString %>" 
    DeleteCommand="DELETE FROM [MachineUpdate] WHERE [UpdateID] = @UpdateID" 
    SelectCommand="SELECT * FROM [MachineUpdate]" UpdateCommand="UPDATE SET [MachineUpdate] = @MachineUpdate WHERE [UpdateID] = @UpdateID[*] = @* WHERE [UpdateID] = @UpdateID"> 
    <DeleteParameters> 
      <asp:Parameter Name="UpdateID" Type="Int32" /> 
    </DeleteParameters> 
</asp:SqlDataSource>

告诉我们你已经尝试过..我们会从那里帮助.. –

你想更新什么？该行的内容？ – Ewerton

提示：columns.add在循环中。 –

答

你的SqlDataSource的更新命令总是静态的，以产生一个动态更新的，你应该通过C＃代码处理GridView控件的RowUpdating事件做到这一点。

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) 
{ 
    string sqlCommand = "UPDATE YourTable SET "; 
    foreach (DictionaryEntry item in e.NewValues) 
    { 
     // You will need to take care to not update PK, FK, etc 
     // You will need to handle DB restrictions 
     // You will need to handle DataTypes (eg: Not set a boolean in a Date column) 
     sqlCommand = sqlCommand + item.Key + " = " + item.Value + ","; 
    } 

    sqlCommand = sqlCommand.TrimEnd(','); // removes the last comma 

    foreach (DictionaryEntry de in e.Keys) 
    { 
     //Assuming that you will have just only one key 
     // You can get the Key in the GridView.DataKeyNames property as well 
     sqlCommand = sqlCommand + " WHERE " + de.Key.ToString() + " = " + de.Value.ToString(); 
    } 


    GridView grd = (GridView)sender; 
    SqlDataSource ds = (SqlDataSource)grd.DataSourceObject; 
    ds.UpdateCommand = sqlCommand; // Modify the UpdateCommand of you SqlDataSource 
}

注：更新列动态是不是一个好主意，你将有大于收益头痛。但对于简单的场景，上面的代码可以工作。

我得到了这个工作！非常感谢！ –

是否可以使用可变数量的列更新GridView？

相关推荐