Parse out Text in DataField value of GridBoundColumn

[Dan]

Can I modify the Display text value of DataField value of GridBoundColumn ?
I have "4-code"
and need to display just "Code"


Seems like there should be in-house property to handle this rather than in the data retrieval or the subsequent JavaScript display.

[Princy]

Hi Dan,

I assume that you want to change the text of the GridBoundColumn. Please have a look into the following code snippet. 

C#:

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        GridDataItem item = (GridDataItem)e.Item;
        if (item["Cityname"].Text == "4-Code")
        {
            item["Cityname"].Text = "Code";
        }
    }
}

Please elaborate your requirement if it doesn't help.
Thanks,
Princy.

[Dan]

Yes and no, using code behind and with Databound event was a direction I was gonna go but I was hoping for some radgrid attribute or possibly some front-end (jQuery) code sample:

I am using:

        protected void gvwMenuDelayCodes_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
        {
            if (e.Item is GridDataItem)
            {
                GridDataItem item = (GridDataItem)e.Item;
                if (item["dlcCode"].Text.IndexOf('-') > 0)
                {
                    string[] codeParts = item["dlcCode"].Text.Split('-');
                    try
                    {
                        Convert.ToInt16(codeParts[0].Trim());
                        item["dlcCode"].Text = codeParts[1];
                    }
                    catch { }
                }
            }
        }

[Princy]

Hi Dan,

Please try the following JavaScript to achieve your scenario.

JavaScript:

<script type="text/javascript">
    function pageLoad() {
        var grid = $find("<%=RadGrid1.ClientID %>");
        var MasterTable = grid.get_masterTableView();
        var Rows = MasterTable.get_dataItems();
        for (var i = 0; i < Rows.length; i++) {
            var row = Rows[i];
            var text = row.get_cell("Cityname").innerText;
            if (text.indexOf('-') != -1) {
                row._element.outerText = text.split("-")[1];
            }
        }
    }
</script>

Thanks,
Princy.

[Dan]

Thanks Princy:

Worked pretty good after minor corrections:

function pageLoad() {

       var grid = $find("<%=gvwMenuDelayCodes.ClientID %>");

       if (grid != null) {

           var MasterTable = grid.get_masterTableView();

           var Rows = MasterTable.get_dataItems();

           for (var i = 0; i < Rows.length; i++) {

               var row = Rows[i];

               var text = row.get_cell("dlcCode").innerText;

               if (text.indexOf('-') > 0) {
                   row.get_cell("dlcCode").innerText = text.split("-")[1];
                }

           }
       }

   }