为何FormView的更新功能会失效?

in Develop

因为FromView的易用性,Blog后台管理的很多地方用到了它
一般是用GridView与FormView结合来使用
用GridView显示基本信息
点击GridView某一行后显示该条记录的详细信息
然后用FormView自带的编辑功能进行修改

可就在现在我发现一个很是郁闷的问题
FormView在编辑记录时,数据库中的记录并未做任何更改!

 <asp:FormView ID="FormView1" runat="server" DataKeyNames="ID" DataSourceID="_fv_source" BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" >
                <EmptyDataTemplate>
                <asp:LinkButton Text="点击这里新建一个公告" CommandName="New" runat="server"></asp:LinkButton>
                </EmptyDataTemplate>

                <EditItemTemplate>
                    <table width="400" border="0" cellspacing="1" cellpadding="6">
                        <tr>
                            <td>
                                ID</td>
                            <td>
                                <%# Eval("id") %>
                               </td>
                        </tr>
                        <tr>
                            <td>
                                Announce</td>
                            <td>
                                <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Announce") %>' Height="189px" TextMode="MultiLine" Width="571px"></asp:TextBox>
                                <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="TextBox1"
                                    Display="Dynamic" ErrorMessage="*" ValidationGroup="edit"></asp:RequiredFieldValidator></td>
                        </tr>
                        <tr>
                            <td>
                                开始时间</td>
                            <td>
                                <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("datestart") %>'>
                                </asp:TextBox>
                                <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="TextBox2"
                                    Display="Dynamic" ErrorMessage="*" ValidationGroup="edit"></asp:RequiredFieldValidator></td>
                        </tr>
                        <tr>
                            <td>
                                结束时间</td>
                            <td>
                                <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("dateend") %>'>
                                </asp:TextBox>
                                <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="TextBox3"
                                    Display="Dynamic" ErrorMessage="*" ValidationGroup="edit"></asp:RequiredFieldValidator></td>
                        </tr>
                        <tr>
                            <td colspan="2">
                                <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update"
                                    Text="更新" ValidationGroup="edit"></asp:LinkButton>
                                <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="True" CommandName="Cancel"
                                    Text="取消" ValidationGroup="edit"></asp:LinkButton></td>
                        </tr>
                    </table>
                </EditItemTemplate>
                <InsertItemTemplate>
                    <table width="400" border="0" cellspacing="1" cellpadding="6">
                        <tr>
                            <td>
                                Announce</td>
                            <td style="width: 493px">
                                <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("Announce") %>' Height="187px" TextMode="MultiLine" Width="509px"></asp:TextBox>
                                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1"
                                    Display="Dynamic" ErrorMessage="*" ValidationGroup="insert"></asp:RequiredFieldValidator></td>
                        </tr>
                        <tr>
                            <td>
                                开始时间</td>
                            <td style="width: 493px">
                                <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("datestart") %>'>
                                </asp:TextBox>
                                <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TextBox2"
                                    Display="Dynamic" ErrorMessage="*" ValidationGroup="insert"></asp:RequiredFieldValidator></td>
                        </tr>
                        <tr>
                            <td>
                                结束时间</td>
                            <td style="width: 493px">
                                <asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("dateend") %>'>
                                </asp:TextBox>
                                <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="TextBox3"
                                    Display="Dynamic" ErrorMessage="*" ValidationGroup="insert"></asp:RequiredFieldValidator></td>
                        </tr>
                        <tr>
                            <td colspan="2">
                                <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Insert"
                                    Text="插入" ValidationGroup="insert"></asp:LinkButton>
                                <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="True" CommandName="Cancel"
                                    Text="取消" ValidationGroup="insert"></asp:LinkButton></td>
                        </tr>
                    </table>
                </InsertItemTemplate>
                <ItemTemplate>
                    <table width="400" border="0" cellspacing="1" cellpadding="6">
                        <tr>
                            <td>
                                ID</td>
                            <td>
                                <%# Eval("ID") %>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                Announce:</td>
                            <td>
                                <%# Eval("Announce") %>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                开始时间</td>
                            <td>
                                <%# Eval("datestart") %>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                结束时间</td>
                            <td>
                                <%# Eval("dateend") %>
                            </td>
                        </tr>
                        <tr>
                            <td colspan="2">
                                <asp:LinkButton ID="EditButton" runat="server" CausesValidation="True" CommandName="Edit"
                                    Text="编辑">
                                </asp:LinkButton>
                                <asp:LinkButton ID="DeleteButton" runat="server" CausesValidation="True" CommandName="Delete"
                                    Text="删除">
                                </asp:LinkButton>
                                <asp:LinkButton ID="NewButton" runat="server" CausesValidation="True" CommandName="New"
                                    Text="新建">
                                </asp:LinkButton></td>
                        </tr>
                    </table>
                </ItemTemplate>
                <FooterStyle BackColor="Tan" />
                <EditRowStyle BackColor="#EFEFEF" ForeColor="Black" />
                <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />
                <HeaderStyle BackColor="Tan" Font-Bold="True" />
            </asp:FormView>

SqlDataSource

 <asp:SqlDataSource ID="_fv_source" runat="server" ConnectionString="<%$ ConnectionStrings:DefaultConnectionstrings %>"
                DeleteCommand="DELETE FROM [Announce] WHERE [ID] = @ID" InsertCommand="INSERT INTO [Announce] ([Announce], [datestart], [dateend], [publishdate]) VALUES (@Announce, @datestart, @dateend, @publishdate)"
                SelectCommand="SELECT * FROM [Announce] WHERE ([ID] = @ID)"
                UpdateCommand="UPDATE [Announce] SET [Announce] = @Announce, [datestart] = @datestart, [dateend] = @dateend WHERE [ID] = @ID" OnInserted="_fv_source_Inserted" OnInserting="_fv_source_Inserting" >
                <DeleteParameters>
                    <asp:Parameter Name="ID" Type="Int32" />
                </DeleteParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Announce" Type="String" />
                    <asp:Parameter Name="datestart" Type="DateTime" />
                    <asp:Parameter Name="dateend" Type="DateTime" />

                    <asp:Parameter Name="ID" Type="Int32" />
                </UpdateParameters>
                <SelectParameters>
                    <asp:Parameter Name="ID" Type="Int32" />
                </SelectParameters>
                <InsertParameters>
                    <asp:Parameter Name="Announce" Type="String" />
                    <asp:Parameter Name="datestart" Type="DateTime" />
                    <asp:Parameter Name="dateend" Type="DateTime" />
                    <asp:Parameter Name="publishdate" Type="DateTime" />
                </InsertParameters>
            </asp:SqlDataSource>

没发现什么不对劲的啊
怎么会这样呢?

已找到原因:
禁用了ViewState,启用后就好了

0 Comments

Leave a Reply

Using Gravatars in the comments - get your own and be recognized!

XHTML: These are some of the tags you can use: <a href=""> <b> <blockquote> <code> <em> <i> <strike> <strong>