Change grid values on itemdatabound

[newbie]

I have a grid bound to a datasource.
However, I have a settings page where the user can specify the number of characters to be displayed for any field in the grid.

I want to trim the column value based on that setting before the grid is displayed.
I was trying to do that in the ItemDataBound event.

Any suggestions how I can do that.

[Princy]

Hello,

One approach is by using Substring() method , you can display a specified number of characters in a cell value.

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
   {
       int count=3;    //count is the no of characters that should be displayed
       if (e.Item is GridDataItem)
       {
           GridDataItem item = (GridDataItem)e.Item;
           string CategoryName = item["ColumnUniqueName"].Text;
           item["ColumnUniqueName"].Text = CategoryName.Substring(0, count);
      }
  }

Thanks,
Princy.

[newbie]

Hi Princy.

The issue i am having here is in my ItemDataBound event item["ColumnUniqueName"].Text returns empty string.
But I know there is a value because when I do  the below I can see the values.

DataRowView groupDataRow = (DataRowView)e.Item.DataItem;
string text = groupDataRow.Row.ItemArray[i].ToString();

 I am using a template column as below. Is that the reason why item["ColumnUniqueName"] is returned blank?

<telerik:GridTemplateColumn UniqueName="Status" HeaderText="Status" Visible="false"
                                    DataField="Status" AllowFiltering="true">
                                    <ItemStyle BorderStyle="None"></ItemStyle>
                                    <HeaderStyle HorizontalAlign="Center" />
                                    <ItemTemplate>
                                        <div>
                                            <%# Eval("Status")%>
                                        </div>
                                    </ItemTemplate>
                                </telerik:GridTemplateColumn>

[Princy]

Hello,

Since the TemplateColumn is rendered after ItemDataBound event, you can access its value by using DataRowView object. Then after executing your code to customize the value, assign new value to TemplateColumn's TableCell by using its 'UniqueName'.

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
   {
       int count = 3;
       if (e.Item is GridDataItem)
       {
           GridDataItem item = (GridDataItem)e.Item;
           DataRowView groupDataRow = (DataRowView)e.Item.DataItem;
           string text = groupDataRow["Status"].ToString();
           item["Status"].Text = text.Substring(0, count);
       }
   }

Thanks,
Princy.

[ShaneUlker]

I want to truncate the text which is in html format. Do you have suggestion for that. Using the below method all html gets messed up inside RadGrid.

[Princy]

Hi ShaneUlker,

Please take a look into the following code snippet i tried to show only the text inside an html tag.

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
   if (e.Item is GridDataItem)
          {
              GridDataItem item = (GridDataItem)e.Item;
              DataRowView groupDataRow = (DataRowView)e.Item.DataItem;
              string text = groupDataRow["UniqueName"].ToString();
              text=Regex.Replace(text, "<.*?>", string.Empty);
              item["UniqueName"].Text = text;
          }
}

 Let me know if you have any concern.

Thanks,
Princy.