[Solved] Row Number in group

[L]

hi

How do get row number for a groupby expression? I am able to get the row number but not the row number gor group. Thanks

 

Protected Sub RadGrid1_ItemDataBound(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridItemEventArgs) Handles RadGrid1.ItemDataBound

 

 

If (TypeOf e.Item Is GridDataItem AndAlso e.Item.OwnerTableView.DataSourceID = "sdsSQLr") Then

 

 

Dim lbl As Label = CType(e.Item.FindControl("numberLabel"), Label)

 

lbl.Text = e.Item.ItemIndex + 1

 

End If

 

 

End Sub

 

<

 

telerik:GridTemplateColumn UniqueName="TemplateColumn" HeaderText="Row number">

 

 

 

 

 

<ItemTemplate>

 

 

 

 

 

<asp:Label ID="numberLabel" runat="server" Width="30px" />

 

 

 

 

 

</ItemTemplate>

 

 

 

 

 

<HeaderStyle Width="30px" />

 

 

 

 

 

</telerik:GridTemplateColumn>

 

[Princy]

Hi,

Try the code snippet below to access the child rows  for each group header item and their coressponding controls .

C#

protected void RadGrid1_PreRender(object sender, EventArgs e)
    {
        foreach (GridGroupHeaderItem groupHeader in RadGrid1.MasterTableView.GetItems(GridItemType.GroupHeader))
        {
            GridItem[] children = groupHeader.GetChildItems();
            foreach (GridDataItem child in children)
            {
                GridDataItem childItem = child as GridDataItem;
                Label lbl = (Label)childItem["SupplierID"].FindControl("Label1");
            }
        }
    }

Thanks,

Princy

[L]

hi

What should i do to the aspx? Should I create an item template? Thanks

[Princy]

Hi,

Try the code snippet to add  row numbers  to the grid group header .You can access the group index and modify the DataCell text .

C#

 protected void RadGrid1_ItemDataBound(object sender, GridItemEventArgs e)
    {
        if (e.Item is GridGroupHeaderItem)
        {
            GridGroupHeaderItem headerItem=(GridGroupHeaderItem)e.Item;
            DataRowView groupDataRow = (DataRowView) headerItem.DataItem;
            headerItem.DataCell.Text = headerItem.GroupIndex.ToString() + groupDataRow["UnitPrice"].ToString();
        }
    }

Hope this helps.

Thanks,

Princy