Find a column using a Contains approach

[Karl Wilkens]

Hi,

We have data coming in where we want to find columns that contain keywords such as 'Upload' but the full column name could contain other words. Once we find that column, we want to change the text of each cell to a link - either by just injecting a hand built a href string, or alternately, adding in a hyperlink.

Is this even possible. Virtually all examples assume the grid column and data column are known - in this case we dont know the names exactly.

Thanks!

[Daniel]

Hello Karl,

You could try the following approach:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
{
    if (e.Item is GridDataItem)
    {
        foreach(GridColumn col in RadGrid1.MasterTableView.Columns)
        {
            if(col.UniqueName.Contains("Upload"))
                (e.Item as GridDataItem)[col].Text ...
        }
    }
}

I hope this helps.

Best regards,
Daniel
the Telerik team

[Karl Wilkens]

Hi and thanks. We tried your suggestion. The for Next loop never executes, as if there are no columns in RadGrid1.MasterTableView.Columns. Any thoughts on what we are doing wrong? This is in ItemDataBound and I stripped out everything else to get the the essential code.
  
 
            Dim dataitem As Telerik.Web.UI.GridDataItem = CType(e.Item, Telerik.Web.UI.GridDataItem)
            Dim col As Telerik.Web.UI.GridColumn

            For Each col In RadGrid1.MasterTableView.Columns
                If col.UniqueName.ToLower.Contains("upload") Then
                    dataitem(col).Text = "Test"
                End If
            Next

[Princy]

Hello Karl,

I guess your RadGrid have AutoGeneratedColumns. If that the case you can try the following code snippet to loop through each column in grid.

C#:

protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
   {
       if (e.Item is GridDataItem)
       {
          foreach(GridColumn col in RadGrid1.MasterTableView.AutoGeneratedColumns)
            {
                   .   .    .    .   .
            }
         }
   }

Thanks,
Princy.

[Karl Wilkens]

Thanks! That was the issue.

I now have a working solution!