or
<
telerik:RadGrid ID="RadGrid1" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateEditColumn="True" CellSpacing="0" DataSourceID="objGetHaulsByTripcode" GridLines="Horizontal" AutoGenerateColumns="False">
<MasterTableView DataSourceID="objGetHaulsByTripcode">
<Columns>
<telerik:GridBoundColumn DataField="TripCode" FilterControlAltText="Filter TripCode column" HeaderText="TripCode" SortExpression="TripCode" UniqueName="TripCode"></telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="VessReg" FilterControlAltText="Filter VessReg column" HeaderText="VessReg" SortExpression="VessReg" UniqueName="VessReg"></telerik:GridBoundColumn>
<telerik:GridDropDownColumn DataField="TechniqueName" DataSourceID="getTechniques"
HeaderText="Technique" ListTextField="TechniqueFullName"
ListValueField="TechniqueCode" UniqueName="TechniqueName"
ColumnEditorID="TechniqueName" Reorderable="False"
Resizable="False"></telerik:GridDropDownColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
<asp:SqlDataSource ID="objGetHaulsByTripcode" runat="server" ConnectionString="<%$ ConnectionStrings:FisheriesConnectionString %>"
SelectCommand="SELECT [TripCode], [VessReg], [TechniqueName] FROM [vwDisHaulsDetailsAll] WHERE ([TripCode] = @TripCode) ORDER BY [TripCode], [VessReg]">
<SelectParameters>
<asp:ControlParameter ControlID="ddlTripCode" Name="TripCode" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="getTechniques" runat="server" ConnectionString="<%$ ConnectionStrings:FisheriesConnectionString %>"
ProviderName="System.Data.SqlClient" SelectCommand="SELECT DisTechnique.Code AS [TechniqueCode], DisTechnique.Name AS [TechniqueFullName] FROM DisTechnique INNER JOIN DisGearTechniqueAllowed ON DisTechnique.Code = DisGearTechniqueAllowed.Code INNER JOIN DisTrips ON DisGearTechniqueAllowed.METHOD_CODE = DisTrips.GearCode WHERE ([TripCode] = @TripCode)">
<SelectParameters>
<asp:ControlParameter ControlID="ddlTripCode" Name="TripCode" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
bool isExport = false;protected void Button1_Click(object sender, EventArgs e){ Session["SelectedItems"] = RadGrid1.SelectedItems; isExport = true; RadGrid1.ExportSettings.IgnorePaging = true; RadGrid1.ExportSettings.UseItemStyles = true; RadGrid1.ExportSettings.ExportOnlyData = true; RadGrid1.MasterTableView.ExportToExcel();}protected void RadGrid1_PreRender(object sender, EventArgs e){ if (isExport) { foreach (GridDataItem item in RadGrid1.MasterTableView.Items) { item.Expanded = true; } }}