

Protected Sub btnTest_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If txtNoOfInd.Text.Trim IsNot String.Empty Then
CreatePanels(txtNoOfFrm.Text)
end if
End Sub
Sub CreatePanels(ByVal NoOfFrm As Integer)
For i As Integer = 1 To NoOfInd
Dim NoOfPersons As Integer = txtNoOfInd.Text
Dim table1 As HtmlTable
Dim Row As HtmlTableRow
Dim Cell As HtmlTableCell
Dim txtName As TextBox
Dim lblName As Label
Dim btnNext As Button
txtName = New TextBox
txtName.ID = "txtName" & i.ToString
lblName = New Label
lblName.ID = "lblName" & i.ToString
lblName.AssociatedControlID = "txtName" & i.ToString
lblName.Text = "Name:"
btnNext = New Button
btnNext.ID = "btnNext" & i.ToString
btnNext.Text = "Next"
table1 = New HtmlTable
Row = New HtmlTableRow
Cell = New HtmlTableCell
Cell.Controls.Add(lblName)
Cell.Controls.Add(txtName)
Cell.Controls.Add(btnNext)
Row.Cells.Add(Cell)
table1.Rows.Add(Row)
Dim newParentItem As RadPanelItem = New RadPanelItem()
Dim newChildItem As RadPanelItem = New RadPanelItem()
newParentItem.Items.Add(newChildItem)
newChildItem.Controls.Add(table1)
newParentItem.Text = i.ToString
If i = 1 Then
newParentItem.Expanded = True
End If
RadPanelBar1.Items.Add(newParentItem)
Next
End Sub
| <telerik:RadGrid ID="rgMonthly" runat="server" GridLines="None" DataSourceID="odsAcctsByPI" |
| OnColumnCreated="rgMonthly_ColumnCreated" OnItemDataBound="rgMonthly_ItemDataBound" |
| OnPreRender="rgMonthly_PreRender" AutoGenerateColumns="true"> |
| <MasterTableView DataSourceID="odsAcctsByPI" DataKeyNames="SlAcct6Num" HierarchyLoadMode="ServerOnDemand" |
| EnableColumnsViewState="False"> |
| <NestedViewSettings DataSourceID="odsGroupsByAcct"> |
| <ParentTableRelation> |
| <telerik:GridRelationFields DetailKeyField="SlAcct6Num" MasterKeyField="SlAcct6Num" /> |
| </ParentTableRelation> |
| </NestedViewSettings> |
| <NestedViewTemplate> |
| <telerik:RadGrid ID="rgSubs" runat="server" GridLines="None" DataSourceID="odsGroupsByAcct" |
| AutoGenerateColumns="true" OnColumnCreated="rgSubs_ColumnCreated" OnItemDataBound="rgSubs_ItemDataBound"> |
| <MasterTableView DataSourceID="odsGroupsByAcct" DataKeyNames="SlAcct6Num,GroupID" |
| HierarchyLoadMode="ServerOnDemand" EnableColumnsViewState="False"> |
| <DetailTables> |
| <telerik:GridTableView Width="100%" runat="server" HierarchyLoadMode="ServerOnDemand" |
| AutoGenerateColumns="true" EnableColumnsViewState="False" DataKeyNames="SlAcct6Num,GroupID" |
| DataSourceID="odsSubAcctsByGroup"> |
| <ParentTableRelation> |
| <telerik:GridRelationFields DetailKeyField="GroupID" MasterKeyField="GroupID" /> |
| <telerik:GridRelationFields DetailKeyField="SlAcct6Num" MasterKeyField="SlAcct6Num" /> |
| </ParentTableRelation> |
| </telerik:GridTableView> |
| </DetailTables> |
| </MasterTableView> |
| </telerik:RadGrid> |
| </NestedViewTemplate> |
| </MasterTableView> |
| </telerik:RadGrid> |
| protected void btnExcel_Click(object sender, EventArgs e) |
| { |
| rgMonthly.ExportSettings.OpenInNewWindow = true; |
| rgMonthly.ExportSettings.ExportOnlyData = true; |
| rgMonthly.ExportSettings.IgnorePaging = true; |
| foreach (GridDataItem gi in rgMonthly.MasterTableView.Items) |
| { |
| gi.Expanded = true; |
| if (gi.HasChildItems) |
| { |
| RadGrid rgSubs = (RadGrid)gi.ChildItem.NestedViewCell.Controls[0].Controls[1]; |
| foreach (GridDataItem gilvl3 in rgSubs.MasterTableView.Items) |
| { |
| if (!gilvl3.KeyValues.Contains("-1")) |
| { |
| gilvl3.Expanded = true; |
| } |
| } |
| } |
| } |
| rgMonthly.MasterTableView.ExportToExcel(); |
| } |