[Solved] RadGrid Update not working

[Jon Morris]

 have a radgrid which is bound to a sqldatasource. When I click on the "Edit" option and make changes to click "Update", the changes are not saved to the Database. I am sure I am doing something wrong(but don't know what).

Related Information:


RadGrid Code:

telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1"   AutoGenerateColumns="False"
      GridLines="None" AllowAutomaticUpdates="True" AllowAutomaticDeletes="True"
        AllowAutomaticInserts="True">
<MasterTableView DataSourceID="SqlDataSource1" DataKeyNames="DateTime,SourceID" EditMode="InPlace">
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>

<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
    <Columns>
        <telerik:GridEditCommandColumn>
        </telerik:GridEditCommandColumn>
        <telerik:GridBoundColumn DataField="DateTime" HeaderText="DateTime"
            SortExpression="DateTime" UniqueName="column1" DataFormatString="{0:g}"
            ReadOnly="True">
        </telerik:GridBoundColumn>
         <telerik:GridTemplateColumn DataField="N1" HeaderText="Heater Duty (63 MMBTU/HR)"
            SortExpression="N1" UniqueName="column3">
             <EditItemTemplate>
                 <asp:TextBox ID="N1TextBox" runat="server" Text='<%# Bind("N1", "{0:F3}") %>'></asp:TextBox>
             </EditItemTemplate>
             <ItemTemplate>
                 <asp:Label ID="N1Label" runat="server" Text='<%# Eval("N1", "{0:F3}") %>'></asp:Label>
             </ItemTemplate>
             <ItemStyle HorizontalAlign="Right" />
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn DataField="N2" HeaderText="NOX (2.52 lb/hr)" SortExpression="N2"
            UniqueName="column2">
            <EditItemTemplate>
                <asp:TextBox ID="N2TextBox" runat="server" Text='<%# Bind("N2", "{0:F3}") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:Label ID="N2Label" runat="server" Text='<%# Eval("N2", "{0:F3}") %>'></asp:Label>
            </ItemTemplate>
            <ItemStyle HorizontalAlign="Right" />
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn DataField="N3" HeaderText="CO (4.46 lb/hr)" SortExpression="N3"
            UniqueName="column5">
            <EditItemTemplate>
                <asp:TextBox ID="N3TextBox" runat="server" Text='<%# Bind("N3", "{0:F3}") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:Label ID="N3Label" runat="server" Text='<%# Eval("N3", "{0:F3}") %>'></asp:Label>
            </ItemTemplate>
            <ItemStyle HorizontalAlign="Right" />
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn DataField="N4" HeaderText="SO2 (1.67 lb/hr)" SortExpression="N4"
            UniqueName="column6">
            <EditItemTemplate>
                <asp:TextBox ID="N4TextBox" runat="server" Text='<%# Bind("N4", "{0:F3}") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:Label ID="N4Label" runat="server" Text='<%# Eval("N4", "{0:F3}") %>'></asp:Label>
            </ItemTemplate>
            <ItemStyle HorizontalAlign="Right" />
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn DataField="N5" HeaderText="VOC (0.33 lb/hr)" SortExpression="N5"
            UniqueName="column7">
            <EditItemTemplate>
                <asp:TextBox ID="N5TextBox" runat="server" Text='<%# Bind("N5", "{0:F3}") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:Label ID="N5Label" runat="server" Text='<%# Eval("N5", "{0:F3}") %>'></asp:Label>
            </ItemTemplate>
            <ItemStyle HorizontalAlign="Right" />
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn DataField="N6" HeaderText="PM (0.47 lb/hr)" SortExpression="N6"
            UniqueName="column8">
            <EditItemTemplate>
                <asp:TextBox ID="N6TextBox" runat="server" Text='<%# Bind("N6", "{0:F3}") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:Label ID="N6Label" runat="server" Text='<%# Eval("N6", "{0:F3}") %>'></asp:Label>
            </ItemTemplate>
            <ItemStyle HorizontalAlign="Right" />
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn DataField="N7" HeaderText="Fuel Gas Flow"
            SortExpression="N7" UniqueName="column9">
            <EditItemTemplate>
                <asp:TextBox ID="N7TextBox" runat="server" Text='<%# Bind("N7", "{0:F3}") %>'></asp:TextBox>
            </EditItemTemplate>
            <ItemTemplate>
                <asp:Label ID="N7Label" runat="server" Text='<%# Eval("N7", "{0:F3}") %>'></asp:Label>
            </ItemTemplate>
            <ItemStyle HorizontalAlign="Right" />
        </telerik:GridTemplateColumn>
         <telerik:GridCheckBoxColumn DataField="Deviation" DataType="System.Boolean"
           HeaderText="Deviation" SortExpression="Deviation" UniqueName="Deviation" ReadOnly="True">
                </telerik:GridCheckBoxColumn>
         <telerik:GridTemplateColumn  HeaderText="Event" UniqueName="EventHyperlink">
             <ItemTemplate>
                 <asp:HyperLink ID="hplEvent" runat="server"
                     NavigateUrl='<%# String.Format("Event.aspx?EventID={0}&datetime={1}&sourceid={2}", Eval("EventID"), Eval("DateTime"), Eval("SourceID")) %>'
                     Text='<%# DataBinder.Eval(Container, "DataItem.ImpactNo") %>'></asp:HyperLink>
             </ItemTemplate>
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn HeaderText="Comment" UniqueName="Comments">
             <EditItemTemplate>
                <asp:TextBox ID="txtComments" runat="server"></asp:TextBox>
             </EditItemTemplate>
              <ItemTemplate>
              <a id="commlink" onclick="javascript:popup=void(window.open('Comments.aspx?datetime=<%#DataBinder.Eval(Container.DataItem,"DateTime")%>&sourceid=<%#DataBinder.Eval(Container.DataItem,"SourceID")%>','popup','left=400,top=300,height=450,width=450,status=no,resizable=no,scrollbars=no,toolbar=no,location=no,menubar=no,titlebar=no'));" href="#" id="a6" ><%#DataBinder.Eval(Container, "DataItem.Comments")%></a>
              </ItemTemplate>
        </telerik:GridTemplateColumn>
        <telerik:GridTemplateColumn HeaderText="Report" UniqueName="TemplateColumn">
            <ItemTemplate>
                <asp:HyperLink ID="hplReport" runat="server"
                    NavigateUrl='<%# DataBinder.Eval(Container, "DataItem.ImpactNo", "Test.aspx?ImpactNo={0}") %>'
                    Text="Report"></asp:HyperLink>
            </ItemTemplate>
        </telerik:GridTemplateColumn>
      
    </Columns>

<EditFormSettings>
<EditColumn UniqueName="EditCommandColumn1"></EditColumn>
</EditFormSettings>
</MasterTableView>
    </telerik:RadGrid>



SQL DataSource Code:
-----------------------------------

 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:TotalConn %>"
SelectCommand="SELECT GV.DateTime, GV.EventID, GV.SourceID, GV.N1, GV.N2, GV.N3, GV.N4, GV.N5, GV.N6, GV.N7, GV.Deviation, GV.Comments, E.ImpactNo FROM stGridView GV LEFT JOIN Events E ON GV.EventID = E.EventID WHERE GV.SourceID = 2 AND GV.DateTime BETWEEN '1-22-2010' AND '1-23-2010' ORDER BY GV.DateTime"
 UpdateCommand="UPDATE stGridView SET N1 = @N1, N2 = @N2, N3 = @N3, N4 = @N4, N5 = @N5, N6 = @N6, N7 = @N7 WHERE DateTime = @DateTime AND SourceID = @SourceID">
        <UpdateParameters>
            <asp:Parameter Name="DateTime" Type="DateTime" />
            <asp:Parameter Name="SourceID" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource> 


Related Information:
-----------------------------

In the sqldatasource update command (UpdateCommand="UPDATE stGridView SET N1 = @N1.......), if I replace "@N1" with a value, say "5", that value is correctly saved. It seems that the update command is unable to get "@N1" value. I am not sure if there needs to be anything in the code-behind to handle this.


Thanks for any help!
Sri

[Princy]

Hi,

Please take a look at the code library sample on how to perform Automatic Operations using SqlDataSource.

http://www.telerik.com/community/code-library/aspnet-ajax/grid/automatic-operations-with-sqldatasource-control.aspx

Thanks,

Princy