[Help] GridView 使用sqlDataSource的更新

Question

昨天刚提过问题...不知道为什么 突然好了..
 但是今天 不知道改了哪里.又出问题了.  <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="CustomerID"
            DataSourceID="SqlDataSource1" OnRowDataBound="GridView1_RowDataBound" >
            <Columns>
                <asp:HyperLinkField HeaderText="Index" />
                <asp:BoundField DataField="CustomerID" HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" Visible="False" >
                    <ControlStyle Width="50px" />
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:BoundField>
                <asp:BoundField DataField="CustomerName" HeaderText="CustomerName" SortExpression="CustomerName" >
                    <ControlStyle Width="50px" />
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:BoundField>
                <asp:BoundField DataField="CustomerAddress" HeaderText="CustomerAddress" SortExpression="CustomerAddress" >
                    <ControlStyle Width="50px" />
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:BoundField>
                <asp:BoundField DataField="CustomerRepresent" HeaderText="CustomerRepresent" SortExpression="CustomerRepresent">
                    <ControlStyle Width="50px" />
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:BoundField>
                <asp:BoundField DataField="CustomerCall" HeaderText="CustomerCall" SortExpression="CustomerCall" >
                    <ControlStyle Width="50px" />
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:BoundField>
                <asp:CheckBoxField DataField="IsActive" HeaderText="IsActive" SortExpression="IsActive" >
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:CheckBoxField>
                <asp:CommandField ShowEditButton="True" >
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" Width="80px" />
                </asp:CommandField>
                <asp:CommandField ShowDeleteButton="True" >
                    <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
                </asp:CommandField>
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString3 %>"
            DeleteCommand="UPDATE [Customer] SET [IsActive] = False WHERE [CustomerID] = @CustomerID"
            InsertCommand="INSERT INTO [Customer] ([CustomerID], [CustomerName], [CustomerAddress], [CustomerRepresent], [CustomerCall], [IsActive]) VALUES (@CustomerID, @CustomerName, @CustomerAddress, @CustomerRepresent, @CustomerCall, @IsActive)"
            ProviderName="<%$ ConnectionStrings:ConnectionString3.ProviderName %>" SelectCommand="SELECT * FROM [Customer] WHERE [IsActive] = True"
            UpdateCommand="UPDATE [Customer] SET [CustomerName] = @CustomerName, [CustomerAddress] = @CustomerAddress, [CustomerRepresent] = @CustomerRepresent, [CustomerCall] = @CustomerCall, [IsActive] = @IsActive WHERE [CustomerID] = @CustomerID">
            <DeleteParameters>
                <asp:Parameter Name="CustomerID" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="CustomerName" Type="String" />
                <asp:Parameter Name="CustomerAddress" Type="String" />
                <asp:Parameter Name="CustomerRepresent" Type="String" />
                <asp:Parameter Name="CustomerCall" Type="String" />
                <asp:Parameter Name="IsActive" Type="Boolean" />
                <asp:Parameter Name="CustomerID" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="CustomerID" Type="Int32" />
                <asp:Parameter Name="CustomerName" Type="String" />
                <asp:Parameter Name="CustomerAddress" Type="String" />
                <asp:Parameter Name="CustomerRepresent" Type="String" />
                <asp:Parameter Name="CustomerCall" Type="String" />
                <asp:Parameter Name="IsActive" Type="Boolean" />
            </InsertParameters>页面打开.数据正常显示 说明 SELECTCOMMAND 可以执行
我将DELETECOMMAND修改了为 设置IsActive = False 也是正常的.说明DELETECOMMAND也可以执行.UPDATE 中如果语法错误 将提示..因此 可以判断 UPDATE的语法是经过验证的.
 但是..数据不更新...求助 各位 有人知道是 哪里的问题吗 ? ...

Answer 1

数据库mdf文件是否放在项目中的？

Answer 2

UPDATECOMMAND 对应操作没有更新...
但是 DELETECOMMAND对应操作是更新的...

Answer 3

你把SELECTCOMMAND 和UpdateCommand位置换一换试试

Answer 4

额...问题依旧...说明一下.我这里是ACCESS 07大家帮我想想哈..

Answer 5

额..因为这个感觉好像比较简单..还有就是..后台的 还不会  - -
 .
求教求教~..(有实例就更好了 .关于gridview 查改删 的..)个人认为以上问题可能是ACCESS 07兼容不好...

Answer 6

 好吧 ..希望 vs开发团队看到我这个问题能够 解决..
 好让 vs05能够更好的兼容 access07