Edit and updating columns in radgrid

[Babu Puchakayala]

Dear Telerik team,

I am migrating gridview to radgrid. I am working on updating my radgrid rows where I am getting some issues.

I updating Clarify Account Nbr, site id, Quote ID columns in "Inplace" editmode. Lets say before update my values are 200, 300, 400 for columns  Clarify Account Nbr, site id, Quote ID. When i click edit button and change the values to 111, 222, 333. when I am debugging my code and trying to see the textbox.text values  It is showing the old values(200, 300, 400) not the new values (111, 222, 333). ( I hope you guys are understand my problem). Where I am doing wrong. Please help me.

I saw this link but no use.

http://www.telerik.com/community/forums/aspnet-ajax/grid/radgrid-vs-gridview.aspx


In the below code if you see

string ClarifyAccountNbr = (editedItem["Clarify Account Nbr"].Controls[0] as TextBox).Text;
        string SiteID = (editedItem["Site ID"].Controls[0] as TextBox).Text;
        string QuoteID = (editedItem["Quote ID"].Controls[0] as TextBox).Text;

when i am debugging and pointing to ClarifyAccountNbr, SiteID, QuoteID I am getting older values not new values.( before updating)


Here is my code

.aspx

<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/MasterPage.master"
    CodeFile="Tsk200.aspx.cs" Inherits="Tak200" EnableEventValidation="false" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="CSS_ScriptPlaceHolder" runat="Server">
    <telerik:RadCodeBlock ID="RadCodeBlock1" runat="server">
        <link href="CSS/Css.css" rel="stylesheet" type="text/css" />

        <script type="text/javascript">

            function onAgrtypeOther() {
                if (document.getElementById('tabTskDet_tabAgreInfo_ddlAgreementType').selectedIndex == 4)
                    document.getElementById('trAgrTypeOther').style.visibility = 'visible';
                else
                    document.getElementById('trAgrTypeOther').style.visibility = 'hidden';
                return false;
            }
            function onPertypeOther() {
                if (document.getElementById('tabTskDet_tabPermit_ddlPermitType').selectedIndex == 3)
                    document.getElementById('tdPerTypeOther').style.visibility = 'visible';
                else
                    document.getElementById('tdPerTypeOther').style.visibility = 'hidden';
                return false;
            }
            function onSitetypeOther() {
                if (document.getElementById('tabTskDet_tabGenTskDet_ddlSiteType').selectedIndex == 4)
                    document.getElementById('tabTskDet_tabGenTskDet_tdSiteTypeOth').style.visibility = 'visible';
                else
                    document.getElementById('tabTskDet_tabGenTskDet_tdSiteTypeOth').style.visibility = 'hidden';
                return false;

            }
            function onPwrtypeOther() {
                if (document.getElementById('tabTskDet_tabGenTskDet_ddlPwrStatus').selectedIndex == 4)
                    document.getElementById('tabTskDet_tabGenTskDet_tdPwrStatusOth').style.visibility = 'visible';
                else
                    document.getElementById('tabTskDet_tabGenTskDet_tdPwrStatusOth').style.visibility = 'hidden';
                return false;
            }
            function onEqiLoctypeOther() {
                if (document.getElementById('tabTskDet_tabGenTskDet_ddlEquiLocDesc').selectedIndex == 3)
                    document.getElementById('tabTskDet_tabGenTskDet_tdEquiLocDescOth').style.visibility = 'visible';
                else
                    document.getElementById('tabTskDet_tabGenTskDet_tdEquiLocDescOth').style.visibility = 'hidden';
                return false;
            }
            function showOthRea() {
                var dt1 = new Date(document.getElementById("tabTskDet_tabGenTskDet_txtConstSchCompDate").value);
                var dt2 = new Date(document.getElementById("tabTskDet_tabGenTskDet_txtConstActCompDate").value);
                if (dt1 < dt2) {
                    document.getElementById("tabTskDet_tabGenTskDet_tdDtLateRea306").style.display = "block"
                }
                else {
                    document.getElementById("tabTskDet_tabGenTskDet_tdDtLateRea306").style.display = "none"
                    document.getElementById("tabTskDet_tabGenTskDet_lblDueDtLateRea").value = ''
                }
            }
            function showOthRea303() {
                var dt1 = new Date(document.getElementById("tabTskDet_tabGenTskDet_txtContSchComDt").value);
                var dt2 = new Date(document.getElementById("tabTskDet_tabGenTskDet_txtConstActComDt").value);
                if (dt1 < dt2) {
                    document.getElementById("tabTskDet_tabGenTskDet_tdDtLateRea303").style.display = "block"
                }
                else {
                    document.getElementById("tabTskDet_tabGenTskDet_tdDtLateRea303").style.display = "none"
                    document.getElementById("tabTskDet_tabGenTskDet_lbl303DueDtLateRea").value = ''
                }
            }
            function DisplayDateToday(sender, args) {
                if (sender._selectedDate == null) {
                    sender._selectedDate = new Date();
                }
            }
            function onRequestStart(sender, args) {
                if (args.get_eventTarget().indexOf("ExportToExcelButton") >= 0 ||
                    args.get_eventTarget().indexOf("ExportToWordButton") >= 0 ||
                    args.get_eventTarget().indexOf("ExportToPdfButton") >= 0 ||
                    args.get_eventTarget().indexOf("ExportToCsvButton") >= 0) {

                    args.set_enableAjax(false);
                }
            }
        </script>

        <style>
            .modalBackground
            {
                background-color: Gray;
                filter: alpha(opacity=70);
                opacity: 0.7;
            }
            .AjaxCalendar .ajax__calendar_container
            {
                border: 1px solid #646464;
                background-color: White;
                color: Black;
            }
            .AjaxCalendar .ajax__calendar_other .ajax__calendar_day, .AjaxCalendar .ajax__calendar_other .ajax__calendar_year
            {
                color: #999999;
            }
            .AjaxCalendar .ajax__calendar_hover .ajax__calendar_day, .AjaxCalendar .ajax__calendar_hover .ajax__calendar_month, .AjaxCalendar .ajax__calendar_hover .ajax__calendar_year
            {
                color: Red;
            }
            .AjaxCalendar .ajax__calendar_active .ajax__calendar_day, .AjaxCalendar .ajax__calendar_active .ajax__calendar_month, .AjaxCalendar .ajax__calendar_active .ajax__calendar_year
            {
                background-color: #78C43C;
                color: Black;
                text-align: center;
                font-weight: bold;
            }
            .rgPageFirst, .rgPagePrev, .rgPageNext, .rgPageLast
            {
                display: none !important;
            }
            div.RadGrid_Default .rgHeader, div.RadGrid_Default th.rgResizeCol
            {
                background-image: none;
            }
        </style>
    </telerik:RadCodeBlock>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="PagePlaceholder" runat="Server">
    <div style="width: 100%; padding-top: 20px">
        <table style="width: 98%">
            <tr>
                <td colspan="2">
                    <asp:Label runat="server" Font-Bold="true" Font-Size="14pt" ID="lblTskName"></asp:Label>
                </td>
            </tr>
            <tr>
                <td colspan="2">
                    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
                    </telerik:RadScriptManager>
                    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
                        <ClientEvents OnRequestStart="onRequestStart" />
                        <AjaxSettings>
                            <telerik:AjaxSetting AjaxControlID="rg200">
                                <UpdatedControls>
                                    <telerik:AjaxUpdatedControl ControlID="rg200" LoadingPanelID="RadAjaxLoadingPanel1" />
                                </UpdatedControls>
                            </telerik:AjaxSetting>
                        </AjaxSettings>
                    </telerik:RadAjaxManager>
                    <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" Skin="Default">
                    </telerik:RadAjaxLoadingPanel>
                    <telerik:RadGrid ID="rg200" runat="server" AutoGenerateColumns="False" PageSize="30"
                        Height="550px" OnNeedDataSource="rg200_NeedDataSource" Width="100%" AllowPaging="True"
                        AllowSorting="True" AllowMultiRowSelection="True" EnableHeaderContextMenu="True"
                        GridLines="None" EnableHeaderContextFilterMenu="True" AllowMultiRowEdit="True"
                        AllowFilteringByColumn="True" OnPreRender="rg200_PreRender" OnItemCreated="rg200_ItemCreated"
                        EnableViewState="False" OnUpdateCommand="rg200_UpdateCommand">
                        <HeaderStyle Height="20px" BackColor="#004000" Font-Size="8pt" Font-Bold="True" ForeColor="White"
                            HorizontalAlign="Center" BorderColor="White" BorderWidth="1px" />
                        <ExportSettings IgnorePaging="true" ExportOnlyData="true">
                            <Pdf AllowModify="false" AllowPrinting="true" PageBottomMargin="" PageFooterMargin=""
                                PageHeaderMargin="" PageHeight="11in" PageLeftMargin="" PageRightMargin="" PageTopMargin=""
                                PageWidth="14in" />
                        </ExportSettings>
                        <MasterTableView GridLines="None" DataKeyNames="orderId" CommandItemDisplay="Top"
                            EditMode="InPlace">
                            <CommandItemSettings ShowExportToWordButton="true" ShowExportToExcelButton="true"
                                ShowExportToCsvButton="true" ShowExportToPdfButton="true" ShowAddNewRecordButton="false" />
                            <Columns>
                                <telerik:GridClientSelectColumn UniqueName="ClientSelectColumn" HeaderStyle-Width="3%"
                                    ItemStyle-Width="3%">
                                    <HeaderStyle Width="3%"></HeaderStyle>
                                    <ItemStyle Width="3%"></ItemStyle>
                                </telerik:GridClientSelectColumn>
                                <telerik:GridBoundColumn UniqueName="sId" HeaderText="sId" DataField="sId" Visible="false">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn UniqueName="orderId" HeaderText="orderId" DataField="orderId">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn UniqueName="Customer Name" HeaderText="Customer Name" DataField="Customer Name"
                                    ReadOnly="true">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn UniqueName="Market Name" HeaderText="Market Name" DataField="Market Name"
                                    ReadOnly="true">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn UniqueName="LOB" HeaderText="LOB" DataField="LOB" ReadOnly="true">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn UniqueName="Headend Name" HeaderText="Headend Name" DataField="Headend Name"
                                    ReadOnly="true">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn UniqueName="Project Name" HeaderText="Project Name" DataField="Project Name"
                                    ReadOnly="true">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn UniqueName="Site Name" HeaderText="Site Name" DataField="Site Name"
                                    ReadOnly="true">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn UniqueName="Task Status" HeaderText="Task Status" DataField="Task Status"
                                    ReadOnly="true">
                                </telerik:GridBoundColumn>
                                <%--<telerik:GridTemplateColumn UniqueName="Clarify Account Nbr" HeaderText="Clarify Account Nbr"
                                    DataField="Clarify Account Nbr">
                                    <ItemTemplate>
                                        <asp:Label ID="lblClarifyAccountNbr" Text='<%# Eval("Clarify Account Nbr") %>' runat="server"></asp:Label>
                                    </ItemTemplate>
                                    <EditItemTemplate>
                                        <asp:TextBox ID="txtClarifyAccountNbr" Text='<%# Eval("Clarify Account Nbr") %>'
                                            runat="server"></asp:TextBox>
                                    </EditItemTemplate>
                                </telerik:GridTemplateColumn>--%>
                                <telerik:GridBoundColumn UniqueName="Clarify Account Nbr" HeaderText="Clarify Account Nbr"
                                    DataField="Clarify Account Nbr">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn UniqueName="Site ID" HeaderText="Site ID" DataField="Site ID">
                                </telerik:GridBoundColumn>
                                <telerik:GridBoundColumn UniqueName="Quote ID" HeaderText="Quote ID" DataField="Quote ID">
                                </telerik:GridBoundColumn>
                                <telerik:GridCheckBoxColumn UniqueName="EDP Created?" HeaderText="EDP Created?" DataField="EDP Created?">
                                </telerik:GridCheckBoxColumn>
                                <telerik:GridEditCommandColumn UniqueName="ECC200">
                                </telerik:GridEditCommandColumn>
                            </Columns>
                            <PagerStyle AlwaysVisible="True"></PagerStyle>
                        </MasterTableView>
                        <ClientSettings EnableRowHoverStyle="true" ReorderColumnsOnClient="false" AllowDragToGroup="false"
                            AllowColumnsReorder="True">
                            <Scrolling AllowScroll="true" EnableVirtualScrollPaging="false" UseStaticHeaders="true" />
                            <Selecting AllowRowSelect="True"></Selecting>
                            <Resizing AllowRowResize="true" AllowColumnResize="True" EnableRealTimeResize="True"
                                ResizeGridOnColumnResize="False"></Resizing>
                            <%--<ClientEvents OnGridCreated="GridCreated" OnCommand="GridCommand" />--%>
                        </ClientSettings>
                        <PagerStyle Mode="NextPrevAndNumeric" AlwaysVisible="true"></PagerStyle>
                    </telerik:RadGrid>
                </td>
            </tr>
            <tr>
                <td colspan="2">
                    &nbsp;
                </td>
            </tr>
        </table>
    </div>
</asp:Content>

.cs file

protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (!IsPostBack)
            {
                Session["SearchRes"] = null;
                if (Session["TaskName"] != null)
                    lblTskName.Text = Session["TaskName"].ToString();
                Session["FilColms"] = null;
                Session["SortExp"] = null;
                Session["FilExp"] = null;
                Session["ViewAll"] = null;
                BindGrid();
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

    private void BindGrid()
    {
        try
        {
            DataSet dsResult = new DataSet();

            clsSearch_BL clsObj = new clsSearch_BL();
            clsObj.TaskID = (string)Session["TaskID"];
            clsObj.CustName = (string)Session["CustName"];
            clsObj.MarketName = (string)Session["MarketName"];
            clsObj.HeadendName = (string)Session["HeadendName"];
            clsObj.SiteName = (string)Session["SiteName"];
            clsObj.TaskStatus = (string)Session["TaskStatus"];
            clsObj.OrdType = (string)Session["OrdType"];
            clsObj.OrdStatus = (string)Session["OrdStatus"];
            clsObj.ProName = (string)Session["ProName"];
            clsObj.LOC = (string)Session["LOC"];
            clsObj.QuoteID = (string)Session["QuoteID"];
            clsObj.CMNumber = (string)Session["CMNumber"];

            if (Session["SearchRes"] == null)
            {
                dsResult = clsObj.getSearchResults_BL(clsObj);
                Session["SearchRes"] = dsResult;
            }
            else
                dsResult = (DataSet)Session["SearchRes"];

            DataView dataView = dsResult.Tables[0].DefaultView;
            rg200.DataSource = dsResult;
            //rg200.DataBind();
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

    protected void rg200_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
    {
        BindGrid();
    }

    protected void rg200_PreRender(object sender, EventArgs e)
    {
        rg200.MasterTableView.GetColumnSafe("RowIndicator").Display = false;

    }

    protected void rg200_ItemCreated(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridPagerItem)
        {
            RadComboBox combo = (e.Item as GridPagerItem).FindControl("PageSizeComboBox") as RadComboBox;

            // The number of items shown when all is selected
            int allRowsCount = int.MaxValue;

            // Remove duplicates
            RadComboBoxItem duplicate = combo.Items.FindItemByValue(allRowsCount.ToString());
            if (duplicate != null)
            {
                duplicate.Remove();
            }

            // Create a new item for showing all
            RadComboBoxItem item = new RadComboBoxItem("All", allRowsCount.ToString());
            item.Attributes.Add("ownerTableViewId", e.Item.OwnerTableView.ClientID);
            combo.Items.Add(item);

            // Set the current pagesize as the selected value
            combo.Items.FindItemByValue(rg200.PageSize.ToString()).Selected = true;
        }
    }

    protected void rg200_UpdateCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
    {
        int intTskID = Convert.ToInt16(Session["TaskID"]);


        GridEditableItem eeditedItem = e.Item as GridEditableItem;
        //Get the primary key value using the DataKeyValue.
        string Id = editedItem.OwnerTableView.DataKeyValues[editedItem.ItemIndex]["orderId"].ToString();
        //Access the textbox from the edit form template and store the values in string variables.
        string ClarifyAccountNbr = (editedItem["Clarify Account Nbr"].Controls[0] as TextBox).Text;
        string SiteID = (editedItem["Site ID"].Controls[0] as TextBox).Text;
        string QuoteID = (editedItem["Quote ID"].Controls[0] as TextBox).Text;
}

[Mira]

Hello Babu,

Please take a look at the Updating values in-place and with edit forms help topic to see how to fetch the data from the edited fields properly.

I hope this helps.

Greetings,
Mira
the Telerik team