This is a migrated thread and some comments may be shown as answers.

Edit and updating columns in radgrid

1 Answer 109 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Babu Puchakayala
Top achievements
Rank 1
Babu Puchakayala asked on 01 Jul 2010, 07:58 PM
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; 







1 Answer, 1 is accepted

Sort by
0
Accepted
Mira
Telerik team
answered on 06 Jul 2010, 12:23 PM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Tags
Grid
Asked by
Babu Puchakayala
Top achievements
Rank 1
Answers by
Mira
Telerik team
Share this question
or