Export to PDF from a RadGrid in ASP.NET

Priti Ranjan Dash
8y
6.2k
0
0

Blog

Export to PDF from a RadGrid

I am using the data from the RadGrid here to export.

Table

Design of the Grid

<divclass="row TopBar"><%--
<telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server">--%>
<telerik:RadGridID="RadGridTotalCOD"runat="server"AutoGenerateColumns="False"GroupPanelPosition="Top"AllowPaging="True"AllowFilteringByColumn="True"AllowMultiRowSelection="True"Skin="Outlook"OnItemCommand="RadGridTotalCOD_ItemCommand"OnPageIndexChanged="RadGridTotalCOD_PageIndexChanged"OnPageSizeChanged="RadGridTotalCOD_PageSizeChanged"PageSize="8"OnPdfExporting="RadGridTotalCOD_PdfExporting">
<ClientSettingsEnablePostBackOnRowClick="true">
<SelectingAllowRowSelect="true"/>
</ClientSettings>
<ExportSettingsExportOnlyData="true"Excel-Format="Html"OpenInNewWindow="true">
<PdfPageHeight="210mm"PageWidth="297mm"DefaultFontFamily="Arial Unicode MS"PageTopMargin="45mm"
BorderStyle="Thin"BorderColor="#666666">
</Pdf>
</ExportSettings>
<MasterTableViewDataKeyNames="OrderId">
<CommandItemSettingsShowExportToExcelButton="true"/>
<Columns>
<telerik:GridTemplateColumnFilterControlAltText="Filter TemplateColumn column"UniqueName="TemplateColumn"Display="true"AllowFiltering="false"ShowFilterIcon="false">
<ItemTemplate><%#Container.DataSetIndex+1 %>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumnFilterControlAltText="Filter TemplateColumn column"UniqueName="TemplateColumn2"Display="false"AllowFiltering="false"ShowFilterIcon="false"HeaderStyle-Width="100">
<ItemTemplate>
<asp:LabelID="LblOrderId"runat="server"Text='<%#Eval("OrderId") %>'>
</asp:Label>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="OrderId"HeaderText="ORDER ID"DataField="OrderId"Display="false"AllowFiltering="false"ShowFilterIcon="false">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="OrderNo"HeaderText="ORDER NO"DataField="OrderNo">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridDateTimeColumnFilterControlAltText="Filter column column"UniqueName="OrderDate"HeaderText="ORDER DATE"DataField="OrderDate"AllowFiltering="true"ShowFilterIcon="true"HeaderStyle-Width="150px"DataFormatString="{0:dd/MMM/yyyy}">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridDateTimeColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="ApplicantName"HeaderText="APPLICANT NAME"DataField="ApplicantName"HeaderStyle-Width="150px">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="ContactNo"HeaderText="CONTACT NO"DataField="ContactNo"AllowFiltering="true"ShowFilterIcon="true"HeaderStyle-Width="150px">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="Email"HeaderText="EMAIL"DataField="Email"AllowFiltering="true"ShowFilterIcon="true">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="ShippingAddress"HeaderText="SHIPPING ADDRESS"DataField="ShippingAddress"AllowFiltering="false"ShowFilterIcon="false"Display="false">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="Pincode"HeaderText="PIN CODE"DataField="Pincode"AllowFiltering="false"ShowFilterIcon="false"Display="false">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="CityName"HeaderText="CityName"DataField="CityName"AllowFiltering="false"ShowFilterIcon="false"Display="false">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="StateName"HeaderText="StateName"DataField="StateName"AllowFiltering="false"ShowFilterIcon="false"Display="false">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="CountryName"HeaderText="CountryName"DataField="CountryName"AllowFiltering="false"ShowFilterIcon="false"Display="false">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="PaymentId"HeaderText="Payment Id"DataField="PaymentId"AllowFiltering="false"ShowFilterIcon="false"Display="false">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="Prices"HeaderText="TOTAL AMOUNT"DataField="Prices"AllowFiltering="false"ShowFilterIcon="false">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridBoundColumnFilterControlAltText="Filter column column"UniqueName="Status"HeaderText="STATUS"DataField="Status">
<ColumnValidationSettings>
<ModelErrorMessageText=""/>
</ColumnValidationSettings>
</telerik:GridBoundColumn>
<telerik:GridTemplateColumnAllowFiltering="false"ShowFilterIcon="false">
<ItemTemplate>
<telerik:RadButtonID="RadBtnAction"runat="server"Text="Action"Skin="Glow"CommandName="cmd_action"CommandArgument='<%#Eval("OrderId") %>'>
</telerik:RadButton>
</ItemTemplate>
</telerik:GridTemplateColumn>
</Columns>
<NestedViewTemplate>
<telerik:RadGridID="RadGridChild"runat="server"AutoGenerateColumns="false"GroupPanelPosition="Top"Skin="Silk">
<ClientSettings>
<SelectingAllowRowSelect="true"/>
</ClientSettings>
<MasterTableViewDataKeyNames="OrderId">
<Columns>
<telerik:GridTemplateColumnFilterControlAltText="Filter TemplateColumn column"UniqueName="TemplateColumn1"Display="false"AllowFiltering="false"ShowFilterIcon="false">
<ItemTemplate><%#Container.DataSetIndex+1 %>
</ItemTemplate>
</telerik:GridTemplateColumn>
<telerik:GridTemplateColumnFilterControlAltText="Filter TemplateColumn column"UniqueName="TemplateColumn3"Display="true"AllowFiltering="false"ShowFilterIcon="false">
<ItemTemplate>
<tablestyle="width: 100%;">
<tr>
<tdstyle="width: 20px;">
</td>
<tdstyle="width: 150px;">
</td>
<tdstyle="width: 2px;">
</td>
<tdstyle="width: 200px;">
</td>
<td></td>
</tr>
<tr>
<td></td>
<td>Your Application No</td>
<td>:</td>
<td>
<asp:LabelID="LblApplicationNo"runat="server"Text='<%#Eval("ApplicationNo") %>'>
</asp:Label>
</td>
<td></td>
</tr>
<tr>
<td></td>
<td>Order No</td>
<td>:</td>
<td>
<asp:LabelID="LblOrderNo"runat="server"Text='<%#Eval("OrderNo") %>'>
</asp:Label>
</td>
<td></td>
</tr>
<tr>
<td></td>
<td>Payment Mode</td>
<td>:</td>
<td>
<asp:LabelID="LblPaymentMode"runat="server"Text='<%#Eval("PaymentMode") %>'>
</asp:Label>
</td>
<td></td>
</tr>
<tr>
<td></td>
<tdcolspan="4">
<tablestyle="width:350px; border:1px solid black;">
<tr>
<tdstyle="width:144px;"class="InnerTblHeadTop">Item Name
</td>
<tdclass="InnerTblHeadTop">
</td>
<tdclass="InnerTblHeadTop">Amount
</td>
</tr>
<tr>
<td>Prospectus Fees</td>
<td>:</td>
<td>
<asp:LabelID="LblProspectusFees"runat="server"Text='<%#Eval("ProspectusFees") %>'>
</asp:Label>
</td>
</tr>
<tr>
<td>EMD1</td>
<td>:</td>
<td>
<asp:LabelID="LblEMD1"runat="server"Text='<%#Eval("EMD1") %>'>
</asp:Label>
</td>
</tr>
<tr>
<tdclass="InnerTblHead">Total Amount
</td>
<tdclass="InnerTblHead">
</td>
<tdclass="InnerTblHead">
<asp:LabelID="LblTotalPrice"runat="server"Text='<%#Eval("Prices") %>'>
</asp:Label>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td></td>
<td>Email</td>
<td>:</td>
<td>
<asp:LabelID="LblEmail"runat="server"Text='<%#Eval("Email") %>'>
</asp:Label>
</td>
<td></td>
</tr>
<tr>
<td></td>
<td>Shipping Address</td>
<td>:</td>
<tdcolspan="2">
<asp:LabelID="Label1"runat="server"Text='<%#Eval("ShippingAddress") %>'>
</asp:Label>
</td>
</tr>
<tr>
<td></td>
<td>City Name</td>
<td>:</td>
<td>
<asp:LabelID="Label3"runat="server"Text='<%#Eval("CityName") %>'>
</asp:Label>
</td>
<tdstyle="width:150px;">State Name
</td>
<td>:</td>
<td>
<asp:LabelID="Label4"runat="server"Text='<%#Eval("StateName") %>'>
</asp:Label>
</td>
<tdstyle="width:150px;">Country Name
</td>
<td>:</td>
<td>
<asp:LabelID="Label5"runat="server"Text='<%#Eval("CountryName") %>'>
</asp:Label>
</td>
</tr>
<tr>
<td></td>
<td>Pincode</td>
<td>:</td>
<td>
<asp:LabelID="Label2"runat="server"Text='<%#Eval("Pincode") %>'>
</asp:Label>
</td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</table>
<tablestyle="width:100%;">
<tr>
<tdstyle="width:3px;">
</td>
<td>Thank you, for applying in the Kencloud Partnership Program. Your Application
<b><%#Eval("ApplicationNo") %>
</b> has been successfully submitted
<br/>
and Order No.
<b><%#Eval("OrderNo") %>
</b>has been confirmed for the value of INR
<b><%#Eval("Prices") %>
</b> . The application prospectus kit along with the
<br/>
reciept will be dispatched to your given address shortly.
</td>
</tr>
</table>
</ItemTemplate>
</telerik:GridTemplateColumn>
</Columns>
</MasterTableView>
</telerik:RadGrid>
</NestedViewTemplate>
</MasterTableView>
</telerik:RadGrid><%--
</telerik:RadAjaxPanel>--%>
</div>

Code at the .cs file

Formatting The PDF

#region--Declaring Head Part
for The Pdf Export--
stringheaderMiddleCell = "<h2>My Contact Details </h2>";
stringheaderLeftCell = "<imgsrc=\"Images/sushibar.jpg\" alt=\"sushi bar\" style=\"width:64px; height: 64px;\" />";
stringfooterMiddleCell = "<?page-number?>";#
endregion
privatevoidExportToPdf()
{#region--Export Selected Data To Pdf--
try
{
RadGridTotalCOD.AllowPaging = true;
RadGridTotalCOD.AllowFilteringByColumn = false;
// loading the Grid with data
LoadTotalCod();#
region--Export with format removed--
RadGridTotalCOD.ExportSettings.ExportOnlyData = true;
RadGridTotalCOD.ExportSettings.Pdf.BorderStyle = GridPdfSettings.GridPdfBorderStyle.Thin;
RadGridTotalCOD.ExportSettings.Pdf.BorderType = GridPdfSettings.GridPdfBorderType.NoBorder;
RadGridTotalCOD.ExportSettings.Pdf.BorderType = GridPdfSettings.GridPdfBorderType.AllBorders;
RadGridTotalCOD.ExportSettings.Pdf.PageHeader.MiddleCell.Text = headerMiddleCell;
RadGridTotalCOD.ExportSettings.Pdf.PageHeader.MiddleCell.TextAlign = GridPdfPageHeaderFooterCell.CellTextAlign.Center;
// RadGridTotalCOD.ExportSettings.Pdf.PageHeader.LeftCell.Text = headerLeftCell;
RadGridTotalCOD.ExportSettings.Pdf.PageHeader.LeftCell.TextAlign = GridPdfPageHeaderFooterCell.CellTextAlign.Center;
RadGridTotalCOD.ExportSettings.Pdf.PageFooter.MiddleCell.Text = footerMiddleCell;
RadGridTotalCOD.ExportSettings.Pdf.PageFooter.MiddleCell.TextAlign = GridPdfPageHeaderFooterCell.CellTextAlign.Center;#
endregion
string Date = DateTime.Now.ToString("dd/MMM/yyyy");
RadGridTotalCOD.ExportSettings.FileName = "Client Address " + " " + Date;#
region--Making Visible false some of the column before exporting--
// TemplateColumn, TemplateColumn2, OrderId, OrderNo, OrderDate, Email, Prices, Status
(RadGridTotalCOD.MasterTableView.GetColumn("TemplateColumn") asGridTemplateColumn).Visible = false;
(RadGridTotalCOD.MasterTableView.GetColumn("TemplateColumn") asGridTemplateColumn).Display = false;
(RadGridTotalCOD.MasterTableView.GetColumn("TemplateColumn2") asGridTemplateColumn).Visible = false;
(RadGridTotalCOD.MasterTableView.GetColumn("TemplateColumn2") asGridTemplateColumn).Display = false;
(RadGridTotalCOD.MasterTableView.GetColumn("OrderId") asGridBoundColumn).Visible = false;
(RadGridTotalCOD.MasterTableView.GetColumn("OrderId") asGridBoundColumn).Display = false;
(RadGridTotalCOD.MasterTableView.GetColumn("OrderNo") asGridBoundColumn).Visible = false;
(RadGridTotalCOD.MasterTableView.GetColumn("OrderNo") asGridBoundColumn).Display = false;
(RadGridTotalCOD.MasterTableView.GetColumn("OrderDate") asGridBoundColumn).Visible = false;
(RadGridTotalCOD.MasterTableView.GetColumn("OrderDate") asGridBoundColumn).Display = false;
(RadGridTotalCOD.MasterTableView.GetColumn("Email") asGridBoundColumn).Visible = false;
(RadGridTotalCOD.MasterTableView.GetColumn("Email") asGridBoundColumn).Display = false;
(RadGridTotalCOD.MasterTableView.GetColumn("Prices") asGridBoundColumn).Visible = false;
(RadGridTotalCOD.MasterTableView.GetColumn("Prices") asGridBoundColumn).Display = false;
(RadGridTotalCOD.MasterTableView.GetColumn("Status") asGridBoundColumn).Visible = false;
(RadGridTotalCOD.MasterTableView.GetColumn("Status") asGridBoundColumn).Display = false;#
endregion# region--Making visible true on a Regular Basis--(RadGridTotalCOD.MasterTableView.GetColumn("ShippingAddress") asGridBoundColumn).Visible = true;
(RadGridTotalCOD.MasterTableView.GetColumn("ShippingAddress") asGridBoundColumn).Display = true;
(RadGridTotalCOD.MasterTableView.GetColumn("Pincode") asGridBoundColumn).Visible = true;
(RadGridTotalCOD.MasterTableView.GetColumn("Pincode") asGridBoundColumn).Display = true;
(RadGridTotalCOD.MasterTableView.GetColumn("CityName") asGridBoundColumn).Visible = true;
(RadGridTotalCOD.MasterTableView.GetColumn("CityName") asGridBoundColumn).Display = true;
(RadGridTotalCOD.MasterTableView.GetColumn("StateName") asGridBoundColumn).Visible = true;
(RadGridTotalCOD.MasterTableView.GetColumn("StateName") asGridBoundColumn).Display = true;
(RadGridTotalCOD.MasterTableView.GetColumn("CountryName") asGridBoundColumn).Visible = true;
(RadGridTotalCOD.MasterTableView.GetColumn("CountryName") asGridBoundColumn).Display = true;#
endregion
// Export Only the Parent Grid Data not tHe Inner Grid
RadGridTotalCOD.MasterTableView.HierarchyDefaultExpanded = false; // first level
RadGridTotalCOD.MasterTableView.ExportToPdf();
// Making visible true
RadGridTotalCOD.AllowFilteringByColumn = true;
}
catch (ArgumentNullExceptionExc)
{
LblErrorMsg.Text = "Application Error : " + Exc.Message;
}
catch (InvalidCastExceptionExc)
{
LblErrorMsg.Text = "Application Error : " + Exc.Message;
}
catch (InvalidOperationExceptionExc)
{
LblErrorMsg.Text = "Application Error : " + Exc.Message;
}
catch (FormatExceptionExc)
{
LblErrorMsg.Text = "Application Error : " + Exc.Message;
}
catch (ExceptionExc)
{
LblErrorMsg.Text = "Application Error : " + Exc.Message;
}#
endregion
}

Export to PDF from a RadGrid in ASP.NET

Up Next

Export GridView Data to Excel, Word, Pdf, Text and Csv Format and Print in Asp.Net

Ebook Download

View all

Getting Started with ASP.NET 4.5 Web Forms and Visual Studio 2013

Read by 7.6k people

Download Now!

Learn

View all