get specific column for every row in details tables

[Howard]

Hi everyone.I have a "level2" details tables within a MasterRadGrid.MasterTableView. In my level2  details tables have 5 rows record with column "ID" and "Name",Now I want to use the "for each" loop to get "ID" column only for each row. How do I achieve this. Please help

[Shinu]

Hi,

Please try the following code snippets to loop through the DetailTable items.

1. Please specify the Name property of the GridTableView in ASPX.

ASPX:

<telerik:GridTableView  Name="Second" . . .>

C#:

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
   if (e.Item is GridDataItem)
    {
        if (e.Item.OwnerTableView.Name == "Second")
        {
              GridDataItem dataItem = e.Item as GridDataItem;
              string ID = dataItem["ID"].Text;
        }
    }
}

OR

2) Loop through the items of detail grid on an External button click as follows.

C#:

foreach (GridDataItem item in RadGrid1.MasterTableView.Items)
{
    //loops through each materTable rows
    GridTableView childtableView = (GridTableView)item.ChildItem.NestedTableViews[0];
    foreach (GridDataItem childItem in childtableView.Items)
    {
        string ID1 = childItem["ID"].Text;
    }
}

Hope this helps.

Thanks,
Shinu.

[Howard]

Thanks for your reply,another question is is I wanna use the ID to execute a query from your code below.How should I do?

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
   if (e.Item is GridDataItem)
    {
        if (e.Item.OwnerTableView.Name == "Second")
        {
              GridDataItem dataItem = e.Item as GridDataItem;
              string ID = dataItem["ID"].Text;
        }
    }
}

something like this.

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
   if (e.Item is GridDataItem)
    {
        if (e.Item.OwnerTableView.Name == "Second")
        {
              GridDataItem dataItem = e.Item as GridDataItem;
              string ID = dataItem["ID"].Text;

         --> //SELECT * FROM TABLE WHERE userid=ID
        }
    }
}

please help again.thanks

[Shinu]

Hi,

You can pass the 'ID' to the SELECT query as follows.

C#:

protected void RadGrid1_ItemDataBound(object sender, Telerik.Web.UI.GridItemEventArgs e)
{
   if (e.Item is GridDataItem)
    {
        if (e.Item.OwnerTableView.Name == "Second")
        {
              GridDataItem dataItem = e.Item as GridDataItem;
              string ID = dataItem["ID"].Text;

              string selectQuery="SELECT * FROM TABLE WHERE UserID='" + ID + "'";
              //Execute the query
        }
    }
}

Thanks,
Shinu.