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.