hello...
i want to populate dinamically a gridtableview in the detailtables of my radgrid.
the datasource for this gridtableview must come from a List<myobject>
this is radgrid and c#:
// datasource for radgrid
protected void gridBooth_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
List<Business.SE2_CatalogueSubscription> _stands = new List<Business.SE2_CatalogueSubscription>();
_stands = _dataContext.SE2_CatalogueSubscriptions
.Where(e => e.idExhibition == _exhibitionId)
.ToList();
gridBooth.DataSource = _stands ;
gridBooth.VirtualItemCount = _stands.Count;;
}
the source for my detailtable is :
public List<Business.SE2_CatalogueSubscriptionsMerceologiche> GetMerceologiche(int idSubscription)
{
return
(_dataContext.SE2_CatalogueSubscriptionsMerceologiches
.Where(a => a.idSubscription == idSubscription)
.OrderBy(b => b.idSubscriptionMerceologico)
).ToList();
}
// i want to Bind the GridTableView with this List<> and the parameter is idSubscription (idSubscription is the GridRelationFields and also DataKeyfor RadGrid)
<telerik:RadGrid ID="gridBooth" runat="server" AllowPaging="True" AllowCustomPaging="True"
AllowSorting="True" AutoGenerateColumns="False" GridLines="None" EnableAJAX="true"
OnNeedDataSource="gridBooth_NeedDataSource" OnSortCommand="RadGrid1_SortCommand"
OnPageIndexChanged="gridBooth_PageIndexChanged" Height="500px"
onitemcreated="gridBooth_ItemCreated" Skin="Vista">
<PagerStyle Mode="NextPrevAndNumeric" />
<MasterTableView CommandItemDisplay="Top" Name="Subscriptions" HierarchyLoadMode="Client">
<DetailTables>
<telerik:GridTableView DataKeyNames="idSubscriptionMerceologico" DataMember="Categories"
ShowHeader="true"
AllowPaging="False" Width="70%" runat="server" AllowCustomPaging="False"
NoDetailRecordsText="Nessuna categoria selezionata." NoMasterRecordsText="">
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="idSubscription" MasterKeyField="idSubscription" />
</ParentTableRelation>
<Columns>
<telerik:GridBoundColumn SortExpression="idSubscriptionMerceologico" HeaderText="ID" DataField="idSubscriptionMerceologico" UniqueName="idSubscriptionMerceologico">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="merceologico" HeaderText="merceologico" DataField="merceologico" UniqueName="merceologico">
</telerik:GridBoundColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
<CommandItemTemplate>
<table width="100%" cellpadding=2 cellspacing=2 border=0>
<tr>
<td class="normal" width="25%" align=left><asp:LinkButton ID="btnExportXLS" runat=server CausesValidation=false OnClick="btnExportXLS_Click"><img src="/images/xls.jpg" border=0 /> Totale</asp:LinkButton></td>
<td class="normal" width="25%" align=left><asp:LinkButton ID="btnExportCSV" runat=server CausesValidation=false OnClick="btnExportCSV_Click">CSV Totale</asp:LinkButton></td>
<td class="normal" width="50%" align=center> </td>
</tr>
</table>
</CommandItemTemplate>
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<Columns>
<telerik:GridTemplateColumn DataField="idSubscription" HeaderText="ID" UniqueName="idSubscription" SortExpression="idSubscription">
<ItemTemplate>
<%# GetIDLink(DataBinder.Eval(Container.DataItem, "idSubscription"), "y")%>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn DataField="idSubscription" HeaderText="ID" visible=false UniqueName="idSubscriptionData" SortExpression="idSubscription">
<ItemTemplate>
<%# GetIDLink(DataBinder.Eval(Container.DataItem, "idSubscription"), "n")%>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn DataField="UserId" HeaderText="Espositore" UniqueName="EspositoreData" SortExpression="UserId">
<ItemTemplate>
<%# GetEspositore(DataBinder.Eval(Container.DataItem, "UserId"), "n")%>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn AllowFiltering="False" DataField="CompanyName" EmptyDataText=""
HeaderText="Azienda" UniqueName="CompanyName">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn AllowFiltering="False" DataField="Address" EmptyDataText=""
HeaderText="Indirizzo" UniqueName="Address">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ClientSettings AllowColumnsReorder="True">
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
</ClientSettings>
<FilterMenu EnableTheming="True">
<CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation>
</FilterMenu>
<sortingsettings sorttooltip="Clicca per ordinare" />
</telerik:RadGrid>
i want to populate dinamically a gridtableview in the detailtables of my radgrid.
the datasource for this gridtableview must come from a List<myobject>
this is radgrid and c#:
// datasource for radgrid
protected void gridBooth_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
{
List<Business.SE2_CatalogueSubscription> _stands = new List<Business.SE2_CatalogueSubscription>();
_stands = _dataContext.SE2_CatalogueSubscriptions
.Where(e => e.idExhibition == _exhibitionId)
.ToList();
gridBooth.DataSource = _stands ;
gridBooth.VirtualItemCount = _stands.Count;;
}
the source for my detailtable is :
public List<Business.SE2_CatalogueSubscriptionsMerceologiche> GetMerceologiche(int idSubscription)
{
return
(_dataContext.SE2_CatalogueSubscriptionsMerceologiches
.Where(a => a.idSubscription == idSubscription)
.OrderBy(b => b.idSubscriptionMerceologico)
).ToList();
}
// i want to Bind the GridTableView with this List<> and the parameter is idSubscription (idSubscription is the GridRelationFields and also DataKeyfor RadGrid)
<telerik:RadGrid ID="gridBooth" runat="server" AllowPaging="True" AllowCustomPaging="True"
AllowSorting="True" AutoGenerateColumns="False" GridLines="None" EnableAJAX="true"
OnNeedDataSource="gridBooth_NeedDataSource" OnSortCommand="RadGrid1_SortCommand"
OnPageIndexChanged="gridBooth_PageIndexChanged" Height="500px"
onitemcreated="gridBooth_ItemCreated" Skin="Vista">
<PagerStyle Mode="NextPrevAndNumeric" />
<MasterTableView CommandItemDisplay="Top" Name="Subscriptions" HierarchyLoadMode="Client">
<DetailTables>
<telerik:GridTableView DataKeyNames="idSubscriptionMerceologico" DataMember="Categories"
ShowHeader="true"
AllowPaging="False" Width="70%" runat="server" AllowCustomPaging="False"
NoDetailRecordsText="Nessuna categoria selezionata." NoMasterRecordsText="">
<ParentTableRelation>
<telerik:GridRelationFields DetailKeyField="idSubscription" MasterKeyField="idSubscription" />
</ParentTableRelation>
<Columns>
<telerik:GridBoundColumn SortExpression="idSubscriptionMerceologico" HeaderText="ID" DataField="idSubscriptionMerceologico" UniqueName="idSubscriptionMerceologico">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn SortExpression="merceologico" HeaderText="merceologico" DataField="merceologico" UniqueName="merceologico">
</telerik:GridBoundColumn>
</Columns>
</telerik:GridTableView>
</DetailTables>
<CommandItemTemplate>
<table width="100%" cellpadding=2 cellspacing=2 border=0>
<tr>
<td class="normal" width="25%" align=left><asp:LinkButton ID="btnExportXLS" runat=server CausesValidation=false OnClick="btnExportXLS_Click"><img src="/images/xls.jpg" border=0 /> Totale</asp:LinkButton></td>
<td class="normal" width="25%" align=left><asp:LinkButton ID="btnExportCSV" runat=server CausesValidation=false OnClick="btnExportCSV_Click">CSV Totale</asp:LinkButton></td>
<td class="normal" width="50%" align=center> </td>
</tr>
</table>
</CommandItemTemplate>
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<Columns>
<telerik:GridTemplateColumn DataField="idSubscription" HeaderText="ID" UniqueName="idSubscription" SortExpression="idSubscription">
<ItemTemplate>
<%# GetIDLink(DataBinder.Eval(Container.DataItem, "idSubscription"), "y")%>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn DataField="idSubscription" HeaderText="ID" visible=false UniqueName="idSubscriptionData" SortExpression="idSubscription">
<ItemTemplate>
<%# GetIDLink(DataBinder.Eval(Container.DataItem, "idSubscription"), "n")%>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumn DataField="UserId" HeaderText="Espositore" UniqueName="EspositoreData" SortExpression="UserId">
<ItemTemplate>
<%# GetEspositore(DataBinder.Eval(Container.DataItem, "UserId"), "n")%>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumn AllowFiltering="False" DataField="CompanyName" EmptyDataText=""
HeaderText="Azienda" UniqueName="CompanyName">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn AllowFiltering="False" DataField="Address" EmptyDataText=""
HeaderText="Indirizzo" UniqueName="Address">
</telerik:GridBoundColumn>
</Columns>
</MasterTableView>
<ClientSettings AllowColumnsReorder="True">
<Scrolling AllowScroll="True" UseStaticHeaders="True" />
</ClientSettings>
<FilterMenu EnableTheming="True">
<CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation>
</FilterMenu>
<sortingsettings sorttooltip="Clicca per ordinare" />
</telerik:RadGrid>