<asp:GridView ID="gdv" runat="server" AutoGenerateColumns="False"

DataKeyNames="QNo" DataSourceID="EntityDataSource1">

<asp:BoundField DataField="QNo" HeaderText="QNo" ReadOnly="True"

SortExpression="QNo" />

<asp:BoundField DataField="Question" HeaderText="Question"

SortExpression="Question" />

<asp:BoundField DataField="choice1" HeaderText="choice1"

SortExpression="choice1" />

<asp:BoundField DataField="choice2" HeaderText="choice2"

SortExpression="choice2" />

<asp:BoundField DataField="choice3" HeaderText="choice3"

SortExpression="choice3" />

<asp:BoundField DataField="choice4" HeaderText="choice4"

SortExpression="choice4" />

<asp:BoundField DataField="choice5" HeaderText="choice5"

SortExpression="choice5" />

<asp:BoundField DataField="choice6" HeaderText="choice6"

SortExpression="choice6" />

<asp:BoundField DataField="correctAnswer" HeaderText="correctAnswer"

SortExpression="correctAnswer" />

</Columns>

</asp:GridView>

<asp:EntityDataSource ID="EntityDataSource1" runat="server"

ConnectionString="name=naniEntities" DefaultContainerName="naniEntities"

EnableFlattening="False" EntitySetName="Sheet1_">

</asp:EntityDataSource>

<br />

<asp:DropDownList ID="DropDownList1" runat="server" Height="16px">

<asp:ListItem>Excel</asp:ListItem>

<asp:ListItem>Word</asp:ListItem>

<asp:ListItem>PDF</asp:ListItem>

</asp:DropDownList>

using System.Text;

using System.Web;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using iTextSharp;

using iTextSharp.text;

using iTextSharp.text.html.simpleparser;

using iTextSharp.text.pdf;

protected void Button1_Click(object sender, EventArgs e)

{

if (DropDownList1.SelectedIndex >= 0)

{

if (DropDownList1.SelectedValue == "Excel")

{

string attachment = "attachment; filename=Export.xls";

Response.ClearContent();

Response.AddHeader("content-disposition", attachment);

Response.ContentType = "application/ms-excel";

StringWriter sw = new StringWriter();

HtmlTextWriter htw = new HtmlTextWriter(sw);

HtmlForm frm = new HtmlForm();

gdv.HeaderRow.Style.Add("background-color", "#FFFFFF");

gdv.HeaderRow.Cells[0].Style.Add("background-color", "green");

gdv.HeaderRow.Cells[1].Style.Add("background-color", "green");

gdv.HeaderRow.Cells[2].Style.Add("background-color", "green");

gdv.Parent.Controls.Add(frm);

frm.Attributes["runat"] = "server";

frm.Controls.Add(gdv);

frm.RenderControl(htw);

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

Response.Write(style);

Response.Write(sw.ToString());

Response.End();

}

if (DropDownList1.SelectedValue == "Word")

{

Response.AddHeader("content-disposition", "attachment;filename=Export.doc");

Response.Cache.SetCacheability(HttpCacheability.NoCache);

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

StringWriter stringWrite = new StringWriter();

HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);

HtmlForm frm = new HtmlForm();

gdv.Parent.Controls.Add(frm);

frm.Attributes["runat"] = "server";

frm.Controls.Add(gdv);

gdv.HeaderRow.Cells[0].Visible = false;

gdv.HeaderRow.Cells[1].Visible = false;

gdv.HeaderRow.Cells[2].Visible = false;

gdv.HeaderRow.Cells[3].Visible = false;

gdv.HeaderRow.Cells[4].Visible = false;

gdv.HeaderRow.Cells[5].Visible = false;

gdv.HeaderRow.Cells[6].Visible = false;

gdv.HeaderRow.Cells[7].Visible = false;

gdv.HeaderRow.Cells[8].Visible = false;

gdv.BorderWidth = 0;

gdv.HeaderRow.Style.Add("background-color", "#FFFFFF");

gdv.HeaderRow.Cells[0].Style.Add("background-color", "green");

gdv.HeaderRow.Cells[1].Style.Add("background-color", "green");

gdv.HeaderRow.Cells[2].Style.Add("background-color", "green");

for (int i = 0; i < gdv.Rows.Count; i++)

{

GridViewRow row = gdv.Rows[i];

row.Cells[8].Visible = false;

string p = row.Cells[1].ToString();

//row.Cells[1].Text = p;

row.BackColor = System.Drawing.Color.White;

row.Attributes.Add("class", "textmode");

Response.Write(stringWrite.ToString());

}

frm.RenderControl(htmlWrite);

Response.Write(stringWrite.ToString());

Response.End();

}

if (DropDownList1.SelectedValue == "PDF")

{ Response.ContentType = "application/pdf";

Response.AddHeader("content-disposition", "attachment;filename=Export.pdf");

Response.Cache.SetCacheability(HttpCacheability.NoCache);

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

HtmlForm frm = new HtmlForm();

gdv.Parent.Controls.Add(frm);

frm.Attributes["runat"] = "server";

frm.Controls.Add(gdv);

frm.RenderControl(hw);

StringReader sr = new StringReader(sw.ToString());

Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);

HTMLWorker htmlparser = new HTMLWorker(pdfDoc);

PdfWriter.GetInstance(pdfDoc, Response.OutputStream);

pdfDoc.Open();

htmlparser.Parse(sr);

pdfDoc.Close();

Response.Write(pdfDoc);

Response.End();

}

2. Using to stringBuilder :

using System.Text;

using System.Web;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using iTextSharp;

using iTextSharp.text;

using iTextSharp.text.html.simpleparser;

using iTextSharp.text.pdf;

if (DropDownList1.SelectedIndex >= 0)

{

if (DropDownList1.SelectedValue == "Word")

{

string d = gdv.Rows[7].Cells[8].Text;

System.Text.StringBuilder str = new System.Text.StringBuilder();

foreach (GridViewRow oItem in gdv.Rows)

{

for (int j = 0; j <= oItem.Cells.Count - 2; j++)

{

str.Append(oItem.Cells[j].Text + " ");

str.Append("\r\n");

}

Response.Clear();

Response.AddHeader("content-disposition", "attachment;filename=SupplierList.doc");

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

Response.Write(str.ToString());

Response.End();

}

if (DropDownList1.SelectedValue == "PDF")

{

System.Text.StringBuilder str = new System.Text.StringBuilder();

foreach (GridViewRow oItem in gdv.Rows)

{

for (int j = 0; j <= oItem.Cells.Count - 2; j++)

{

str.Append(oItem.Cells[j].Text + " ");

str.Append("\r\n");

}

Response.Clear();

Response.AddHeader("content-disposition", "attachment;filename=SupplierList.pdf");

Response.ContentType = "application/pdf";

Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);

PdfWriter.GetInstance(pdfDoc, Response.OutputStream);

pdfDoc.Open();

pdfDoc.Add(new Paragraph(str .ToString ()));

pdfDoc.Close();

Response.Write(pdfDoc);

Response.End();

}

DOTNET INFORMANTION BY VIJAY

how to convert into data grid view to word,excel in asp.net using c#.net