FormView使用中的问题

更新前输入如下数据:



点击更新按钮后再次回到该界面：


图中使用的FormView代码如下：

<asp:FormView ID="FormView1" runat="server" DataSourceID="mstiger">
                        <EditItemTemplate>
                            左图片Url:
                            <asp:TextBox ID="LeftImgUrlTextBox" runat="server" Text='<%# Bind("LeftImgUrl") %>'></asp:TextBox>&nbsp;
                            宽度:
                            <asp:TextBox ID="LeftImgWidthTextBox" runat="server" Text='<%# Bind("LeftImgWidth") %>'></asp:TextBox>&nbsp;
                            高度:
                            <asp:TextBox ID="LeftImgHeightTextBox" runat="server" Text='<%# Bind("LeftImgHeight") %>'></asp:TextBox><br />
                            <br />
                            中图Url:
                            <asp:TextBox ID="MiddleImgUrlTextBox" runat="server" Text='<%# Bind("MiddleImgUrl") %>'></asp:TextBox>
                            &nbsp; 宽度::
                            <asp:TextBox ID="MiddleImgWidthTextBox" runat="server" Text='<%# Bind("MiddleImgWidth") %>'></asp:TextBox>
                            高度::
                            <asp:TextBox ID="MiddleImgHeightTextBox" runat="server" Text='<%# Bind("MiddleImgHeight") %>'></asp:TextBox><br />
                            右图Url:
                            <asp:TextBox ID="RightImgUrlTextBox" runat="server" Text='<%# Bind("RightImgUrl") %>'></asp:TextBox>&nbsp;
                            宽度:
                            <asp:TextBox ID="RightImgWidthTextBox" runat="server" Text='<%# Bind("RightImgWidth") %>'></asp:TextBox>&nbsp;
                            高度:
                            <asp:TextBox ID="RightImgHeightTextBox" runat="server" Text='<%# Bind("RightImgHeight") %>'></asp:TextBox><br />
                            <asp:LinkButton ID="UpdateButton" runat="server" CausesValidation="True" CommandName="Update"
                                Text="更新"></asp:LinkButton>
                            <asp:LinkButton ID="UpdateCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
                                Text="取消"></asp:LinkButton>
                        </EditItemTemplate>
                        <ItemTemplate>
                            左图片url:
                            <asp:Label ID="LeftImgUrlLabel" runat="server" Text='<%# Bind("LeftImgUrl") %>'></asp:Label>
                            &nbsp; 宽度:
                            <asp:Label ID="LeftImgWidthLabel" runat="server" Text='<%# Bind("LeftImgWidth") %>'></asp:Label>
                            &nbsp; 高度:
                            <asp:Label ID="LeftImgHeightLabel" runat="server" Text='<%# Bind("LeftImgHeight") %>'></asp:Label><br />
                            中间图片Url:
                            <asp:Label ID="MiddleImgUrlLabel" runat="server" Text='<%# Bind("MiddleImgUrl") %>'></asp:Label>
                            &nbsp;&nbsp; 宽度::
                            <asp:Label ID="MiddleImgWidthLabel" runat="server" Text='<%# Bind("MiddleImgWidth") %>'></asp:Label>
                            高度:
                            <asp:Label ID="MiddleImgHeightLabel" runat="server" Text='<%# Bind("MiddleImgHeight") %>'></asp:Label><br />
                            <br />
                            右图片Url:
                            <asp:Label ID="RightImgUrlLabel" runat="server" Text='<%# Bind("RightImgUrl") %>'></asp:Label>
                            &nbsp; 宽度:
                            <asp:Label ID="RightImgWidthLabel" runat="server" Text='<%# Bind("RightImgWidth") %>'></asp:Label>
                            &nbsp; 高度:
                            <asp:Label ID="RightImgHeightLabel" runat="server" Text='<%# Bind("RightImgHeight") %>'></asp:Label><br />
                            <asp:LinkButton ID="EditButton" runat="server" CausesValidation="False" CommandName="Edit"
                                Text="编辑"></asp:LinkButton>
                        </ItemTemplate>
     </asp:FormView>

该FormView对应的AccessDataSource如下：

<asp:AccessDataSource ID="mstiger" runat="server" DataFile="~/db/mstiger.mdb" SelectCommand="SELECT DISTINCT LeftImgUrl,LeftImgWidth, LeftImgHeight,MiddleImgUrl,   MiddleImgWidth, MiddleImgHeight,  RightImgUrl,RightImgWidth, RightImgHeight FROM GeneralProperties" UpdateCommand="UPDATE GeneralProperties SET LeftImgUrl = @LeftImgUrl, MiddleImgUrl = @MiddleImgUrl, RightImgUrl = @RightImgUrl, LeftImgWidth = @LeftImgWidth , LeftImgHeight =@LeftImgHeight , MiddleImgWidth = @MiddleImgWidth , MiddleImgHeight =@MiddleImgHeight , RightImgWidth =@RightImgWidth , RightImgHeight = @RightImgHeight">
 </asp:AccessDataSource>

好像一切都正常，到底问题出在哪里那？

[解决方法]

把Update语句中字段的顺序调整为和FormView中的字段顺序一致就可以了，看来.net2.0还是不够智能阿