今天在用gridview做用戶管理界面。發(fā)現(xiàn)在刪除的時(shí)候，出現(xiàn)

“除非指定了 DeleteCommand，否則數(shù)據(jù)源“SqlDataSource1”不支持刪除操作。 ”的錯(cuò)誤。我就增加了delect命令

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MRCSSConn %>"
                SelectCommand="SELECT [ID],[LoginID], [Name], [Description], [Phone], [Address], [IsEnable], [IsLock] FROM [tblUser]"
                DeleteCommand="DELETE FROM [tblUser] WHERE [ID] = @ID">
                <DeleteParameters>
                    <asp:Parameter Name="ID" Type="Int32" />
                </DeleteParameters>
            </asp:SqlDataSource>

但是這樣沒報(bào)錯(cuò)但刪除沒反應(yīng)。百度了一下，找了好多文章，在http://apps.hi.baidu.com/share/detail/23287136發(fā)現(xiàn)問題，沒有給GridView的DataKeyNames屬性賦值，將主鍵字段設(shè)置為DataKeyNames的值即可。

            <asp:GridView ID="grdUserList" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
                AllowPaging="True" AllowSorting="True" BorderWidth="1px" CellPadding="3" CellSpacing="2"
                BorderStyle="None" DataKeyNames="ID"> 補(bǔ)充上datakeynames就搞定了