Export Multiple GridViews to Word Document in ASP.Net

I have already explained how to Export GridView to Microsoft Word Document in my following articles

Export GridView To Word/Excel/PDF/CSV in ASP.Net

Export GridView with Images to Word, Excel and PDF Formats in ASP.Net

Export GridView with Images from database to Word, Excel and PDF Formats

But this is something different that is how to export multiple GridViews to single Word document

GridViews

Below is the HTML markup of the two GridViews

<asp:GridView ID="GridView1" runat="server"

AutoGenerateColumns = "false" Font-Names = "Arial"

Font-Size = "11pt" AlternatingRowStyle-BackColor = "#C2D69B"

HeaderStyle-BackColor = "green" AllowPaging ="true"

OnPageIndexChanging = "OnPaging">

<asp:BoundField ItemStyle-Width = "150px" DataField = "CustomerID"

HeaderText = "CustomerID" />

<asp:BoundField ItemStyle-Width = "150px" DataField = "City"

HeaderText = "City"/>

</Columns>

</asp:GridView>

<asp:GridView ID="GridView2" runat="server"

AutoGenerateColumns = "false" Font-Names = "Arial"

Font-Size = "11pt" AlternatingRowStyle-BackColor = "#C2D69B"

HeaderStyle-BackColor = "green" AllowPaging ="true"

OnPageIndexChanging = "OnPaging" >

<asp:BoundField ItemStyle-Width = "150px" DataField = "OrderID"

HeaderText = "Order ID" />

<asp:BoundField ItemStyle-Width = "150px" DataField = "CustomerID"

HeaderText = "Customer ID"/>

</Columns>

</asp:GridView>

Namespaces

You will need to import the following namespaces

using System.IO;

using System.Text;

using System.Configuration;

VB.Net

Imports System.IO

Imports System.Text

Imports System.Configuration

Connection String

Below is the connection string used for this tutorial. As you will notice I am using the NorthWind SQL Server Data base which you can download by clicking here

<add name="conString" connectionString="Data Source=.\SQLEXPRESS;

database=Northwind;Integrated Security=true" />

</connectionStrings>

DataBinding GridViews

Below is the how I bind the two GridViews in the Page Load Event of the ASP.Net Web Page. You will notice I am running a simple Select Query and binding the data to both the GridViews using the GetData function

protected void Page_Load(object sender, EventArgs e)

{

string strQuery = "select CustomerID,City,Country from customers";

SqlCommand cmd = new SqlCommand(strQuery);

DataTable dt = GetData(cmd);

GridView1.DataSource = dt;

GridView1.DataBind();

strQuery = "select OrderID, CustomerID, EmployeeID from Orders";

cmd = new SqlCommand(strQuery);

dt = GetData(cmd);

GridView2.DataSource = dt;

GridView2.DataBind();

}

private DataTable GetData(SqlCommand cmd)

{

DataTable dt = new DataTable();

String strConnString = ConfigurationManager

.ConnectionStrings["conString"].ConnectionString;

SqlConnection con = new SqlConnection(strConnString);

SqlDataAdapter sda = new SqlDataAdapter();

cmd.CommandType = CommandType.Text;

cmd.Connection = con;

try

{

con.Open();

sda.SelectCommand = cmd;

sda.Fill(dt);

return dt;

}

catch (Exception ex)

{

throw ex;

}

finally

{

con.Close();

sda.Dispose();

con.Dispose();

}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load

Dim strQuery As String = "select CustomerID,City,Country from customers"

Dim cmd As New SqlCommand(strQuery)

Dim dt As DataTable = GetData(cmd)

GridView1.DataSource = dt

GridView1.DataBind()

strQuery = "select OrderID, CustomerID, EmployeeID from Orders"

cmd = New SqlCommand(strQuery)

dt = GetData(cmd)

GridView2.DataSource = dt

GridView2.DataBind()

End Sub

Private Function GetData(ByVal cmd As SqlCommand) As DataTable

Dim dt As New DataTable()

Dim strConnString As String = ConfigurationManager _

.ConnectionStrings("conString").ConnectionString()

Dim con As New SqlConnection(strConnString)

Dim sda As New SqlDataAdapter()

cmd.CommandType = CommandType.Text

cmd.Connection = con

Try

con.Open()

sda.SelectCommand = cmd

sda.Fill(dt)

Return dt

Catch ex As Exception

Throw ex

Finally

con.Close()

sda.Dispose()

con.Dispose()

End Try

End Function

The figure below displays the two GridViews we just populated using the NorthWind Database.

GridView Populated using Northwind database in ASP.Net

Concept

Now in order to export multiple GridViews you will need to wrap the GridViews in a Control that will act as a container and then export that control instead f the GridViews. Hence here I am creating a fake dynamic table and exporting the table instead of GridViews.

Option of Paging Enable Disable and GridView Alignment

Here I provided the user facility whether user wants complete records or only the records for the current page. Secondly I have also provided the choice whether the two GridViews should be aligned horizontally next to each other or vertically one after another using the two RadioButtonLists

<br />Paging Enabled?

<asp:RadioButtonList ID="rbPaging" runat="server">

<asp:ListItem Text = "Yes" Value = "True" Selected = "True">

</asp:ListItem>

<asp:ListItem Text = "No" Value = "False"></asp:ListItem>

</asp:RadioButtonList>

<br />

Export Preference

<asp:RadioButtonList ID="rbPreference" runat="server">

<asp:ListItem Text = "Vertical" Value = "1" Selected = "True">

</asp:ListItem>

<asp:ListItem Text = "Horizontal" Value = "2"></asp:ListItem>

</asp:RadioButtonList>

In the front end they look like below. As you can see user can choose how he wants the output in the Exported Microsoft Word Document.

Paging Enable Disable and Orientation selection

Exporting the Multiple GridViews

Now comes the final part that is exporting the two GridViews to Microsoft Word Document on the click of the Export Button

Refer the code below

protected void btnExportWord_Click(object sender, EventArgs e)

{

Response.Clear();

Response.Buffer = true;

Response.AddHeader("content-disposition",

"attachment;filename=GridViewExport.doc");

Response.Charset = "";

Response.ContentType = "application/vnd.ms-word";

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

GridView1.AllowPaging = Convert.ToBoolean(rbPaging.SelectedItem.Value);

GridView1.DataBind();

GridView2.AllowPaging = Convert.ToBoolean(rbPaging.SelectedItem.Value);

GridView2.DataBind();

Table tb = new Table();

TableRow tr1 = new TableRow();

TableCell cell1 = new TableCell();

cell1.Controls.Add(GridView1);

tr1.Cells.Add(cell1);

TableCell cell3 = new TableCell();

cell3.Controls.Add(GridView2);

TableCell cell2 = new TableCell();

cell2.Text = " ";

if (rbPreference.SelectedValue == "2")

{

tr1.Cells.Add(cell2);

tr1.Cells.Add(cell3);

tb.Rows.Add(tr1);

}

else

{

TableRow tr2 = new TableRow();

tr2.Cells.Add(cell2);

TableRow tr3 = new TableRow();

tr3.Cells.Add(cell3);

tb.Rows.Add(tr1);

tb.Rows.Add(tr2);

tb.Rows.Add(tr3);

}

tb.RenderControl(hw);

//style to format numbers to string

string style = @"<style> .textmode { mso-number-format:\@; } </style>";

Response.Write(style);

Response.Output.Write(sw.ToString());

Response.Flush();

Response.End();

}

VB.Net

Protected Sub btnExportWord_Click(ByVal sender As Object, ByVal e As EventArgs)

Response.Clear()

Response.Buffer = True

Response.AddHeader("content-disposition", _

"attachment;filename=GridViewExport.doc")

Response.Charset = ""

Response.ContentType = "application/vnd.ms-word"

Dim sw As New StringWriter()

Dim hw As New HtmlTextWriter(sw)

GridView1.AllowPaging = Convert.ToBoolean(rbPaging.SelectedItem.Value)

GridView1.DataBind()

GridView2.AllowPaging = Convert.ToBoolean(rbPaging.SelectedItem.Value)

GridView2.DataBind()

Dim tb As New Table()

Dim tr1 As New TableRow()

Dim cell1 As New TableCell()

cell1.Controls.Add(GridView1)

tr1.Cells.Add(cell1)

Dim cell3 As New TableCell()

cell3.Controls.Add(GridView2)

Dim cell2 As New TableCell()

cell2.Text = " "

If rbPreference.SelectedValue = "2" Then

tr1.Cells.Add(cell2)

tr1.Cells.Add(cell3)

tb.Rows.Add(tr1)

Else

Dim tr2 As New TableRow()

tr2.Cells.Add(cell2)

Dim tr3 As New TableRow()

tr3.Cells.Add(cell3)

tb.Rows.Add(tr1)

tb.Rows.Add(tr2)

tb.Rows.Add(tr3)

End If

tb.RenderControl(hw)

'style to format numbers to string

Dim style As String = "<style> .textmode { mso-number-format:\@; } </style>"

Response.Write(style)

Response.Output.Write(sw.ToString())

Response.Flush()

Response.End()

End Sub

As you will notice I am creating a Dynamic Table and adding the GridViews to the Dynamic Table Cells and then rendering the Table instead of the GridViews this is what does the trick of Exporting two or multiple GridViews to a Single Microsoft Word Document

The Screenshots below display the GridViews in the Horizontal and the Vertical Alignments

Vertical Alignment

Vetical Alignment of GridViews Exported Excel File

Horizontal Alignment

Horizontal Alignment of GridViews in Exported Excel File

You might get the following errors. Click on the links below for the solution to resolve them

RegisterForEventValidation can only be called during Render()

Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server.

To View the Live demo Click here

You can download the complete source code in VB.Net and C# using the link below.

ExportMultipleGridViewsToWord.zip (5.48 kb)

Export Multiple GridViews to Word Document in ASP.Net

Here Mudassar Ahmed Khan has explained how to export multiple GridViews to the same Microsoft Word Document using ASP.Net