您的位置: 首页  >  技术问答  >  Gridview编辑和更新按钮会删除数据库中的数据。为什么？

Gridview编辑和更新按钮会删除数据库中的数据。为什么？

分类: 技术问答 • 2022-06-15 19:36:32
问题描述：

我有一个网页表单，上面有一个网格视图。网格查看器只显示我选择显示的几列。当我想在网格视图中更新一列时，单击左侧的编辑链接，这些字段将打开以进行编辑。然后我将一个列数据从True更改为False。然后我点击左侧的更新链接，所有数字数据都消失了，但不是我改变了。为什么会这样？我做错了什么？它适用于我的其他项目，但这不是。



这是我的Gridview代码：



I have a web form that has a Grid view on it. The Grid viewer shows just a couple of columns I chose to show. When I want to update one column in the Grid view I click on the Edit link to the left and the fields are open to be edited. Then I change one column data from True to False. I then click on the Update link to the left and all of the number data is gone but not what I changed. Why does this happen? What did I do wrong? It works on my other projects but this one it is not.

Here is my Gridview code:

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <asp:GridView ID="GridView1" runat="server" AllowSorting="True" 

            AutoGenerateColumns="False" CellPadding="4" DataKeyNames="AutoID" 

            DataSourceID="SqlDataSourceFTESUB" ForeColor="#333333" GridLines="None" 

            style="text-align: center" Width="1511px">
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
            <Columns>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" 

                    ShowSelectButton="True" />
                <asp:BoundField DataField="AutoID" HeaderText="AutoID" InsertVisible="False" 

                    ReadOnly="True" SortExpression="AutoID" />
                <asp:BoundField DataField="INST_ID" HeaderText="INST_ID" 

                    SortExpression="INST_ID" />
                <asp:BoundField DataField="LongName" HeaderText="LongName" 

                    SortExpression="LongName" />
                <asp:BoundField DataField="FTEYR" HeaderText="FTEYR" SortExpression="FTEYR" />
                <asp:BoundField DataField="FTE40" HeaderText="FTE40" SortExpression="FTE40" />
                <asp:BoundField DataField="HC50" HeaderText="HC50" SortExpression="HC50" />
                <asp:BoundField DataField="FTE4050" HeaderText="FTE4050" 

                    SortExpression="FTE4050" />
                <asp:BoundField DataField="SUBMITTED" HeaderText="SUBMITTED" 

                    SortExpression="SUBMITTED" />
            </Columns>
            <EditRowStyle BackColor="#999999" />
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#E9E7E2" />
            <SortedAscendingHeaderStyle BackColor="#506C8C" />
            <SortedDescendingCellStyle BackColor="#FFFDF8" />
            <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSourceFTESUB" runat="server" 

            ConnectionString="<%$ ConnectionStrings:PasswordConnectionString %>" 

            DeleteCommand="DELETE FROM [TableFTE] WHERE [AutoID] = @AutoID" 

            InsertCommand="INSERT INTO [TableFTE] ([INST_ID], [FT_UNDERGR], [FT_GRAD], [FTE_UNDERG], [FTE_GRAD], [NON_CREDIT], [TOTAL_FTE], [FTEYR], [UserName], [DATE], [FCFTUHC], [FCFTPBHC], [FCPTUHC], [FCPTPBHC], [NCHC], [TIME], [key], [UnderG12], [Postb9], [Total123b4b], [THCAS], [FTE40], [HC50], [FTE4050], [SUBMITTED], [LongName]) VALUES (@INST_ID, @FT_UNDERGR, @FT_GRAD, @FTE_UNDERG, @FTE_GRAD, @NON_CREDIT, @TOTAL_FTE, @FTEYR, @UserName, @DATE, @FCFTUHC, @FCFTPBHC, @FCPTUHC, @FCPTPBHC, @NCHC, @TIME, @key, @UnderG12, @Postb9, @Total123b4b, @THCAS, @FTE40, @HC50, @FTE4050, @SUBMITTED, @LongName)" 

            SelectCommand="SELECT * FROM [TableFTE] WHERE ([FTEYR] = @FTEYR)" 

            UpdateCommand="UPDATE [TableFTE] SET [INST_ID] = @INST_ID, [FT_UNDERGR] = @FT_UNDERGR, [FT_GRAD] = @FT_GRAD, [FTE_UNDERG] = @FTE_UNDERG, [FTE_GRAD] = @FTE_GRAD, [NON_CREDIT] = @NON_CREDIT, [TOTAL_FTE] = @TOTAL_FTE, [FTEYR] = @FTEYR, [UserName] = @UserName, [DATE] = @DATE, [FCFTUHC] = @FCFTUHC, [FCFTPBHC] = @FCFTPBHC, [FCPTUHC] = @FCPTUHC, [FCPTPBHC] = @FCPTPBHC, [NCHC] = @NCHC, [TIME] = @TIME, [key] = @key, [UnderG12] = @UnderG12, [Postb9] = @Postb9, [Total123b4b] = @Total123b4b, [THCAS] = @THCAS, [FTE40] = @FTE40, [HC50] = @HC50, [FTE4050] = @FTE4050, [SUBMITTED] = @SUBMITTED, [LongName] = @LongName WHERE [AutoID] = @AutoID">
            <DeleteParameters>
                <asp:Parameter Name="AutoID" Type="Int32" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="INST_ID" Type="Int32" />
                <asp:Parameter Name="FT_UNDERGR" Type="Int32" />
                <asp:Parameter Name="FT_GRAD" Type="Int32" />
                <asp:Parameter Name="FTE_UNDERG" Type="Int32" />
                <asp:Parameter Name="FTE_GRAD" Type="Int32" />
                <asp:Parameter Name="NON_CREDIT" Type="Int32" />
                <asp:Parameter Name="TOTAL_FTE" Type="Int32" />
                <asp:Parameter Name="FTEYR" Type="Int32" />
                <asp:Parameter Name="UserName" Type="String" />
                <asp:Parameter Name="DATE" Type="String" />
                <asp:Parameter Name="FCFTUHC" Type="Int32" />
                <asp:Parameter Name="FCFTPBHC" Type="Int32" />
                <asp:Parameter Name="FCPTUHC" Type="Int32" />
                <asp:Parameter Name="FCPTPBHC" Type="Int32" />
                <asp:Parameter Name="NCHC" Type="Int32" />
                <asp:Parameter Name="TIME" Type="Double" />
                <asp:Parameter Name="key" Type="String" />
                <asp:Parameter Name="UnderG12" Type="Int32" />
                <asp:Parameter Name="Postb9" Type="Int32" />
                <asp:Parameter Name="Total123b4b" Type="Int32" />
                <asp:Parameter Name="THCAS" Type="Int32" />
                <asp:Parameter Name="FTE40" Type="Int32" />
                <asp:Parameter Name="HC50" Type="Int32" />
                <asp:Parameter Name="FTE4050" Type="Int32" />
                <asp:Parameter Name="SUBMITTED" Type="String" />
                <asp:Parameter Name="LongName" Type="String" />
            </InsertParameters>
            <SelectParameters>
                <asp:Parameter DefaultValue="2015" Name="FTEYR" Type="Int32" />
            </SelectParameters>
            <UpdateParameters>
                <asp:Parameter Name="INST_ID" Type="Int32" />
                <asp:Parameter Name="FT_UNDERGR" Type="Int32" />
                <asp:Parameter Name="FT_GRAD" Type="Int32" />
                <asp:Parameter Name="FTE_UNDERG" Type="Int32" />
                <asp:Parameter Name="FTE_GRAD" Type="Int32" />
                <asp:Parameter Name="NON_CREDIT" Type="Int32" />
                <asp:Parameter Name="TOTAL_FTE" Type="Int32" />
                <asp:Parameter Name="FTEYR" Type="Int32" />
                <asp:Parameter Name="UserName" Type="String" />
                <asp:Parameter Name="DATE" Type="String" />
                <asp:Parameter Name="FCFTUHC" Type="Int32" />
                <asp:Parameter Name="FCFTPBHC" Type="Int32" />
                <asp:Parameter Name="FCPTUHC" Type="Int32" />
                <asp:Parameter Name="FCPTPBHC" Type="Int32" />
                <asp:Parameter Name="NCHC" Type="Int32" />
                <asp:Parameter Name="TIME" Type="Double" />
                <asp:Parameter Name="key" Type="String" />
                <asp:Parameter Name="UnderG12" Type="Int32" />
                <asp:Parameter Name="Postb9" Type="Int32" />
                <asp:Parameter Name="Total123b4b" Type="Int32" />
                <asp:Parameter Name="THCAS" Type="Int32" />
                <asp:Parameter Name="FTE40" Type="Int32" />
                <asp:Parameter Name="HC50" Type="Int32" />
                <asp:Parameter Name="FTE4050" Type="Int32" />
                <asp:Parameter Name="SUBMITTED" Type="String" />
                <asp:Parameter Name="LongName" Type="String" />
                <asp:Parameter Name="AutoID" Type="Int32" />
            </UpdateParameters>
        </asp:SqlDataSource>
    
    </div>
    </form>
</body>
</html>





There is no code behind.



There is no code behind.

答

ConnectionStrings:PasswordConnectionString %>\"

DeleteCommand=\"DELETE FROM [TableFTE] WHERE [AutoID] = @AutoID\"

InsertCommand=\"INSERT INTO [TableFTE] ([INST_ID], [FT_UNDERGR], [FT_GRAD], [FTE_UNDERG], [FTE_GRAD], [NON_CREDIT], [TOTAL_FTE], [FTEYR], [UserName], [DATE], [FCFTUHC], [FCFTPBHC], [FCPTUHC], [FCPTPBHC], [NCHC], [TIME], [key], [UnderG12], [Postb9], [Total123b4b], [THCAS], [FTE40], [HC50], [FTE4050], [SUBMITTED], [LongName]) VALUES (@INST_ID, @FT_UNDERGR, @FT_GRAD, @FTE_UNDERG, @FTE_GRAD, @NON_CREDIT, @TOTAL_FTE, @FTEYR, @UserName, @DATE, @FCFTUHC, @FCFTPBHC, @FCPTUHC, @FCPTPBHC, @NCHC, @TIME, @key, @UnderG12, @Postb9, @Total123b4b, @THCAS, @FTE40, @HC50, @FTE4050, @SUBMITTED, @LongName)\"

SelectCommand=\"SELECT * FROM [TableFTE] WHERE ([FTEYR] = @FTEYR)\"

UpdateCommand=\"UPDATE [TableFTE] SET [INST_ID] = @INST_ID, [FT_UNDERGR] = @FT_UNDERGR, [FT_GRAD] = @FT_GRAD, [FTE_UNDERG] = @FTE_UNDERG, [FTE_GRAD] = @FTE_GRAD, [NON_CREDIT] = @NON_CREDIT, [TOTAL_FTE] = @TOTAL_FTE, [FTEYR] = @FTEYR, [UserName] = @UserName, [DATE] = @DATE, [FCFTUHC] = @FCFTUHC, [FCFTPBHC] = @FCFTPBHC, [FCPTUHC] = @FCPTUHC, [FCPTPBHC] = @FCPTPBHC, [NCHC] = @NCHC, [TIME] = @TIME, [key] = @key, [UnderG12] = @UnderG12, [Postb9] = @Postb9, [Total123b4b] = @Total123b4b, [THCAS] = @THCAS, [FTE40] = @FTE40, [HC50] = @HC50, [FTE4050] = @FTE4050, [SUBMITTED] = @SUBMITTED, [LongName] = @LongName WHERE [AutoID] = @AutoID\">
<DeleteParameters>
<asp:Parameter Name=\"AutoID\" Type=\"Int32\" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name=\"INST_ID\" Type=\"Int32\" />
<asp:Parameter Name=\"FT_UNDERGR\" Type=\"Int32\" />
<asp:Parameter Name=\"FT_GRAD\" Type=\"Int32\" />
<asp:Parameter Name=\"FTE_UNDERG\" Type=\"Int32\" /pan>>
<asp:Parameter Name=\"FTE_GRAD\" Type=\"Int32\" />
<asp:Parameter Name=\"NON_CREDIT\" Type=\"Int32\" />
<asp:Parameter Name=\"TOTAL_FTE\" Type=\"Int32\" />
<asp:Parameter Name=\"FTEYR\" Type=\"Int32\" />
<asp:Parameter Name=\"UserName\" Type=\"String\" />
<asp:Parameter Name=\"DATE\" Type=\"String\" />
<asp:Parameter Name=\"FCFTUHC\" Type=\"Int32\" />
<asp:Parameter Name=\"FCFTPBHC\" Type=\"Int32\" />
<asp:Parameter Name=\"FCPTUHC\" Type=\"Int32\" />
<asp:Parameter Name=\"FCPTPBHC\" Type=\"Int32\" />
<asp:Parameter Name=\"NCHC\" Type=\"Int32\" />
<asp:Parameter Name=\"TIME\" Type=\"Double\" />
<asp:Parameter Name=\"key\" Type=\"String\" />
<an>asp:Parameter Name=\"UnderG12\" Type=\"Int32\" />
<asp:Parameter Name=\"Postb9\" Type=\"Int32\" />
<asp:Parameter Name=\"Total123b4b\" Type=\"Int32\" />
<asp:Parameter Name=\"THCAS\" Type=\"Int32\" />
<asp:Parameter Name=\"FTE40\" Type=\"Int32\" />
<asp:Parameter Name=\"HC50\" Type=\"Int32\" />
<asp:Parameter Name=\"FTE4050\" Type=\"Int32\" />
<asp:Parameter Name=\"SUBMITTED\" Typepan>=\"String\" />
<asp:Parameter Name=\"LongName\" Type=\"String\" />
</InsertParameters>
<SelectParameters>
<asp:Parameter DefaultValue=\"2015\" Name=\"FTEYR\" Type=\"Int32\" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name=\"INST_ID\" Type=\"Int32\" />
<asp:Parameter Name=\"FT_UNDERGR\" Type=\"Int32\" />
<asp:Parameter Name=\"FT_GRAD\" Type=\"Int32\" />
<asp:Parameter Name=\"FTE_UNDERG\" Type=\"Int32\" />
<asp:Parameter Name=\"FTE_GRAD\" Type=\"Int32\" />
<asp:Parameter Name=\"NON_CREDIT\" Type=\"Int32\" />
<asp:Parameter Name=\"TOTAL_FTE\" Type=\"Int32\" />
<asp:Parameter Name=\"FTE YR\" Type=\"Int32\" />
<asp:Parameter Name=\"UserName\" Type=\"String\" />
<asp:Parameter Name=\"DATE\" Type=\"String\" />
<asp:Parameter Name=\"FCFTUHC\" Type=\"Int32\" />
<asp:Parameter Name=\"FCFTPBHC\" Type=\"Int32\" />
<asp:Parameter Name=\"FCPTUHC\" Type=\"Int32\" />
<asp:Parameter Name=\"FCPTPBHC\" Type=\"Int32\" />
<asp:Parameter Name=\"NCHC\" Type=\"Int32\" />
<asp:Parameter Name=\"TIME\" Type=\"Double\" />
<asp:Parameter Name=\"key\" Type=\"String\" />
<asp:Parameter Name=\"UnderG12\" Type=\"Int32\" />
<asp:Parameter Name=\"Postb9\" Type=\"Int32\" />
<asp:Parameter Name=\"Total123b4b\" Type=\"Int32\" />
<asp:Parameter Name=\"THCAS\" Type=\"Int32\" />
<asp:Parameter Name=\"FTE40\" Type=\"Int32\" />
<asp:Parameter Name=\"HC50\" an>Type=\"Int32\" />
<asp:Parameter Name=\"FTE4050\" Type=\"Int32\" />
<asp:Parameter Name=\"SUBMITTED\" Type=\"String\" />
<asp:Parameter Name=\"LongName\" Type=\"String\" />
<asp:Parameter Name=\"AutoID\" Type=\"Int32\" />
</UpdateParameters>
</asp:SqlDataSource>

</div>
</form>
</body>
</html>
ConnectionStrings:PasswordConnectionString %>" DeleteCommand="DELETE FROM [TableFTE] WHERE [AutoID] = @AutoID" InsertCommand="INSERT INTO [TableFTE] ([INST_ID], [FT_UNDERGR], [FT_GRAD], [FTE_UNDERG], [FTE_GRAD], [NON_CREDIT], [TOTAL_FTE], [FTEYR], [UserName], [DATE], [FCFTUHC], [FCFTPBHC], [FCPTUHC], [FCPTPBHC], [NCHC], [TIME], [key], [UnderG12], [Postb9], [Total123b4b], [THCAS], [FTE40], [HC50], [FTE4050], [SUBMITTED], [LongName]) VALUES (@INST_ID, @FT_UNDERGR, @FT_GRAD, @FTE_UNDERG, @FTE_GRAD, @NON_CREDIT, @TOTAL_FTE, @FTEYR, @UserName, @DATE, @FCFTUHC, @FCFTPBHC, @FCPTUHC, @FCPTPBHC, @NCHC, @TIME, @key, @UnderG12, @Postb9, @Total123b4b, @THCAS, @FTE40, @HC50, @FTE4050, @SUBMITTED, @LongName)" SelectCommand="SELECT * FROM [TableFTE] WHERE ([FTEYR] = @FTEYR)" UpdateCommand="UPDATE [TableFTE] SET [INST_ID] = @INST_ID, [FT_UNDERGR] = @FT_UNDERGR, [FT_GRAD] = @FT_GRAD, [FTE_UNDERG] = @FTE_UNDERG, [FTE_GRAD] = @FTE_GRAD, [NON_CREDIT] = @NON_CREDIT, [TOTAL_FTE] = @TOTAL_FTE, [FTEYR] = @FTEYR, [UserName] = @UserName, [DATE] = @DATE, [FCFTUHC] = @FCFTUHC, [FCFTPBHC] = @FCFTPBHC, [FCPTUHC] = @FCPTUHC, [FCPTPBHC] = @FCPTPBHC, [NCHC] = @NCHC, [TIME] = @TIME, [key] = @key, [UnderG12] = @UnderG12, [Postb9] = @Postb9, [Total123b4b] = @Total123b4b, [THCAS] = @THCAS, [FTE40] = @FTE40, [HC50] = @HC50, [FTE4050] = @FTE4050, [SUBMITTED] = @SUBMITTED, [LongName] = @LongName WHERE [AutoID] = @AutoID"> <DeleteParameters> <asp:Parameter Name="AutoID" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="INST_ID" Type="Int32" /> <asp:Parameter Name="FT_UNDERGR" Type="Int32" /> <asp:Parameter Name="FT_GRAD" Type="Int32" /> <asp:Parameter Name="FTE_UNDERG" Type="Int32" /> <asp:Parameter Name="FTE_GRAD" Type="Int32" /> <asp:Parameter Name="NON_CREDIT" Type="Int32" /> <asp:Parameter Name="TOTAL_FTE" Type="Int32" /> <asp:Parameter Name="FTEYR" Type="Int32" /> <asp:Parameter Name="UserName" Type="String" /> <asp:Parameter Name="DATE" Type="String" /> <asp:Parameter Name="FCFTUHC" Type="Int32" /> <asp:Parameter Name="FCFTPBHC" Type="Int32" /> <asp:Parameter Name="FCPTUHC" Type="Int32" /> <asp:Parameter Name="FCPTPBHC" Type="Int32" /> <asp:Parameter Name="NCHC" Type="Int32" /> <asp:Parameter Name="TIME" Type="Double" /> <asp:Parameter Name="key" Type="String" /> <asp:Parameter Name="UnderG12" Type="Int32" /> <asp:Parameter Name="Postb9" Type="Int32" /> <asp:Parameter Name="Total123b4b" Type="Int32" /> <asp:Parameter Name="THCAS" Type="Int32" /> <asp:Parameter Name="FTE40" Type="Int32" /> <asp:Parameter Name="HC50" Type="Int32" /> <asp:Parameter Name="FTE4050" Type="Int32" /> <asp:Parameter Name="SUBMITTED" Type="String" /> <asp:Parameter Name="LongName" Type="String" /> </InsertParameters> <SelectParameters> <asp:Parameter DefaultValue="2015" Name="FTEYR" Type="Int32" /> </SelectParameters> <UpdateParameters> <asp:Parameter Name="INST_ID" Type="Int32" /> <asp:Parameter Name="FT_UNDERGR" Type="Int32" /> <asp:Parameter Name="FT_GRAD" Type="Int32" /> <asp:Parameter Name="FTE_UNDERG" Type="Int32" /> <asp:Parameter Name="FTE_GRAD" Type="Int32" /> <asp:Parameter Name="NON_CREDIT" Type="Int32" /> <asp:Parameter Name="TOTAL_FTE" Type="Int32" /> <asp:Parameter Name="FTEYR" Type="Int32" /> <asp:Parameter Name="UserName" Type="String" /> <asp:Parameter Name="DATE" Type="String" /> <asp:Parameter Name="FCFTUHC" Type="Int32" /> <asp:Parameter Name="FCFTPBHC" Type="Int32" /> <asp:Parameter Name="FCPTUHC" Type="Int32" /> <asp:Parameter Name="FCPTPBHC" Type="Int32" /> <asp:Parameter Name="NCHC" Type="Int32" /> <asp:Parameter Name="TIME" Type="Double" /> <asp:Parameter Name="key" Type="String" /> <asp:Parameter Name="UnderG12" Type="Int32" /> <asp:Parameter Name="Postb9" Type="Int32" /> <asp:Parameter Name="Total123b4b" Type="Int32" /> <asp:Parameter Name="THCAS" Type="Int32" /> <asp:Parameter Name="FTE40" Type="Int32" /> <asp:Parameter Name="HC50" Type="Int32" /> <asp:Parameter Name="FTE4050" Type="Int32" /> <asp:Parameter Name="SUBMITTED" Type="String" /> <asp:Parameter Name="LongName" Type="String" /> <asp:Parameter Name="AutoID" Type="Int32" /> </UpdateParameters> </asp:SqlDataSource> </div> </form> </body> </html>





There is no code behind.



There is no code behind.


相关推荐