content //com.android.browser.home/ Generate pdf document from gridview data and store on web server - Part 59

The HTML and the code used in the demo, can be found at the link below.
http://csharp-video-tutorials.blogspo...

Link for csharp, asp.net, ado.net, dotnet basics and sql server video tutorial playlists
http://www.youtube.com/user/kudvenkat...

Please watch Part 58, before proceeding with this video.
http://www.youtube.com/watch?v=urw4D2...

Step 1: Create an asp.net web application project. Add a folder with name "PDFDocuments" to the project. We will be using this folder to store the dynamically generated pdf document.

Step 2: Drag and drop a gridview control and a button control on webform1.aspx. Autoformat the gridview control to use "BrownSugar" scheme. Double click on the button control, to generate click event handler method.

Step 3: To generate PDF documents we will be using open source assembly - iTextSharp.dll. This assembly can be downloaded from http://sourceforge.net/projects/itext.... After you download the assembly, add a reference to it, from your web application.
a) In Solution Explorer, right click on the "References" folder and select "Add Reference"
b) Browse to the folder where you have downloaded the assembly and Click OK.

Step 4: Add the following "USING" statements, in your code-behind file.
using iTextSharp.text;
using iTextSharp.text.html.simpleparser;
using iTextSharp.text.pdf;

Step 5: Copy and paste the following code. The code is well commented and is self-explanatory.
protected void Page_Load(object sender, EventArgs e)
{ if (!IsPostBack) { BindGridViewData(); }
}

private void BindGridViewData()
{ string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString; using (SqlConnection con = new SqlConnection(CS)) { SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployee", con); DataSet ds = new DataSet(); da.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); }
}

protected void Button1_Click(object sender, EventArgs e)
{ PdfPTable pdfTable = new PdfPTable(GridView1.HeaderRow.Cells.Count); foreach (TableCell gridViewHeaderCell in GridView1.HeaderRow.Cells) { Font font = new Font(); font.Color = new BaseColor(GridView1.HeaderStyle.ForeColor); PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewHeaderCell.Text, font)); pdfCell.BackgroundColor = new BaseColor(GridView1.HeaderStyle.BackColor); pdfTable.AddCell(pdfCell); } foreach (GridViewRow gridViewRow in GridView1.Rows) { foreach (TableCell gridViewCell in gridViewRow.Cells) { Font font = new Font(); font.Color = new BaseColor(GridView1.RowStyle.ForeColor); PdfPCell pdfCell = new PdfPCell(new Phrase(gridViewCell.Text, font)); pdfCell.BackgroundColor = new BaseColor(GridView1.RowStyle.BackColor); pdfTable.AddCell(pdfCell); } } Document pdfDocument = new Document(PageSize.A4, 10f, 10f, 10f, 10f); // Roate page using Rotate() function, if you want in Landscape // pdfDocument.SetPageSize(PageSize.A4.Rotate()); // Using PageSize.A4_LANDSCAPE may not work as expected // Document pdfDocument = new Document(PageSize.A4_LANDSCAPE, 10f, 10f, 10f, 10f); PdfWriter.GetInstance(pdfDocument, new FileStream(Server.MapPath("~/PDFDocuments/Employees.pdf"), FileMode.Create)); pdfDocument.Open(); pdfDocument.Add(pdfTable); pdfDocument.Close();
}

At this point, run the application and click on the button. The data gets exported to a PDF as expected and is stored in the folder "PDFDocuments". Notice that the PDF document, is generated using "Portrait" orientation.

To generate the PDF document in "Landscape" orientation, uncomment the following line
// pdfDocument.SetPageSize(PageSize.A4.Rotate());

Now, run the application and click on the button. The PDF document should be generated in landscape orientation.

content //com.android.browser.home/ Generate pdf document from gridview data and store on web server - Part 59
56 Likes	56 Dislikes
22,462 views views	524K followers
Education	Upload TimePublished on 21 Apr 2013

Related keywords

asp.net core docker,wcf vs web api,ado.net core,sql server management studio,c#.net versions,webkinz,webadvisor,document.ua,craigslist nj,gridview datasource,wcf one piece,asp.net core 3,document flow,ajax players,c#.net core,weber grill parts,webtoon,tutorials by hugo,csharp corner,mvc design pattern,asp.net machine account,servers for minecraft,asp.net core dependency injection,ado.net tutorial,c#.net developer,document onload,services angular,document.addeventlistener,ajax ontario,tutorial definition,tutorial on excel,c#.net online compiler,asp.net mvc tutorial,asp.net cos'è,csharp assembly,content lab la nacion,tutorialspoint python,sql join,c#.net interview questions,services briefcase,asp.net core web api,data entry,ajax jquery,wccftech,craigslist ny,gridview flutter,data warehouse,asp.net zero,csharp foreach,server memes,document ready,sql date format,services online,chase,c#.net tutorial pdf,serverless architecture,server resume,data science,wcf c#,server books,tutorialspoint javascript,gridview rowcommand,mvcc connect,ado.net mysql,services technologies gps,data scientist,document js,ajax deadpool,server jobs,cvs,website,mvc tutorial,costco hours,wcf service application,tutorialspoint spring,serverless,wcf soap,document ready js,wcf cat,wcf test client,cool math games,services & training hse colombia sas,servicestack,citibank,asp.net core identity,sql union,ajax parking,sql database,asp.net core logging,gridview devexpress c#,mvconnect,asp.net guida,cunyfirst,documents,wcf nba,csharp download,wcfi foundation,csharp online,wcf authentication,tutorials near me,c#.net notes pdf,http://asp.net,server 2019,ado.net descargar,web of dreams,chernobyl,documents google,serverminer,gridview pagination,ajax cleaner,ado.net visual studio 2019,tutorial for windows 10,webassign,ado.net vs entity framework,data star trek,data lake,ado.net visual studio 2017,csharp list,gridview height,contentamiento,sql like,asp.net mvc,asp.net core tutorial,sqlite,wcfm,gridview c#,ajax roster,tutorial gateway,mvc architecture,http://ado.net,asp.net core mvc,ajax soccer,server hosting,document.cookie,data scientist salary,wcfi,ajax dish soap,capital one,server rack,tutorialspoint html,data mining,csharp interface,contento sinonimos,craigslist,webroot,tutorialspoint reactjs,ajax request,wcf dragon ball,asp.net core 2.2,tutorialspoint python 3,sql developer,webster,services transmission company sas,content marketing,sql group by,gridviewrow,asp.net core signalr,services manager,mvc framework,ajax paving,mvc near me,data analysis,tutorialspoint spring boot,c#.net framework,c#.net concatenate strings,mvc map,csharp online compiler,asp.net download,sql between,data analyst salary,ado.net c# pdf,wcf 2019 nba,services tag dell,csharp switch,c#.net mvc,ado.net ventajas y desventajas,csharpstar,wcf tutorial,tutorialspoint,ajax meaning,contentina,csharp-video-tutorials.blogspot,document.write,tutorials dojo,tutorial mission gta online,csharp string format,central park 5,ado.net c#,asp.net core github,document online,gridview android example,server status,ajax fc,server jobs nyc,asp.net core swagger,sql formatter,credit karma,services group,gridview css,gridview yii2,server error in '/' application,data entry jobs,services windows,asp.net core 3.0,sql injection,gridview asp.net,wcf ria services,tutorialspoint c#,calculator,c#.net vs asp.net,ado.net entity data model,sql insert,data analytics,tutorialspoint tableau,document.getelementsbytagname,contenta,services google play apk,sqlyog,asp.net core 3 release date,sql server,c#.net tutorial,server job description,tutorials by a,servicenow,webcam,mvc hours,c#.net to vb.net,webmd symptom,c#.net w3schools,contento,csharp array,c#.net projects,csharp enum,ajax call,asp.net core 2. guida completa per lo sviluppatore,asp.net core,gridview c# asp.net,server pro,server status ffxiv,c#.net basics,document.createelement,webcrims,cheap flights,asp.net core hosting,services sas,tutorialspoint java,document.getelementsbyclassname,tutorialspoint java compiler,datadog,webmd,document object model,csharp to json,college football,documentary,ado.net dataset,csharp dictionary,tutorial meaning,cnn,website builder,tutorial.mc-complex,tutorialspoint sql,asp.net web api,server side rendering,weber grills,sql server 2017,mvc nj,tutorialspoint spark,data breach,ado.net oracle,asp.net core download,csharp to vb.net,document.queryselector,webster bank,gridview column width,document.getelementbyid,webstaurant,tutorial systems,datacamp,tutorial teacher,tutorialsystems,ajax post,services fms publish announcement,gridview devexpress,services.msc no abre,content manager assetto corsa,ajax jersey,content creator,csharp operator,asp.net core razor pages,content manager,server duties,asp.net core environment variables,contentura,tutorial on variational autoencoders,csharp random,century 21,c#.net latest version,services consultores,services consulting,gridview hide column,mvcsd,mvcsc,services.msc,ado.net pdf,asp.net core configuration,ajax marvel,contentful,tutorial synonym,sql update,asp.net tutorial,mvc medical,ado.net entity data model visual studio 2019,wcfs international curriculum,mvc2,ado.net entity data model visual studio 2017,c#.net tutorialspoint,chase online,wcf api,costco,server jobs near me,webex,gridview bootstrap 4,sql meaning,sql tutorial,sql commands,data universe,ado.net entity framework,ajax tavern,tutorialsteacher,ajax javascript,content lab,c#.net pdf,c#.net programs,database,services desk,document.queryselectorall,contentar,data visualization,contento significado,content id,ajax greek,content traduccion,csharp tutorial,mvc pattern,ado.net sql server,ado.net connection,asp.net identity,mvcu,gridview android,databricks,contento es un adjetivo,gridview bootstrap,content words,asp.net core middleware,data analyst,wcf web service,gridview xamarin forms,mvc webadvisor,tutorial music,web store,mvcc,webmail,mvci,mvctc,