Gridview edit and update button erases data in database. Why?

Question

0.00/5 (No votes)

See more:

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

<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.

Posted 14-Sep-15 3:18am

Computer Wiz99

Add a Solution

Comments

ZurdoDev 11-Jan-16 14:15pm

Make sure your UpdateCommand and UpdateParameters are correct. You can also run Sql Server Profiler to see the exact sql statement being sent to sql.

Sinisa Hajnal 12-Jan-16 2:30am

Are you showing all fields that are in the the update command? If you show only part of them, update will still send the whole update with nulls in place of values if they are not in the grid.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)