To convert database table in sql server into pdf file using c#.net

Question

Hi,
I want to know how to convert datatable into pdf file.I am using a database table in sql server and it contains the values as follows

p_id    name           city
1         hansen       sandnes
2        syendson    sandnes
3        pettersen    stavanger
4    krishna       chennai
6       raman        banglore
7       kumar         coimbatore
9      raman         sandnes

i want to convert the above table into a pdf file using c#.net ,how to do it please help me

thanks in advance

Trinity · Answer

Try to use crystal report there is a method that exports the data in the report to excel word or even pdf You create a crsytal report file separatly that consumes data from your sql server data base then you export it to pdf using this code //Instantiate a new report document ReportDocument oDoc = new ReportDocument(); //load myCrReport oDoc.Load(@"C:\myCrReport.rpt"); DataSet myDataSet = new DataSet(); // write code here to fill the data set DiskFileDestinationOptions destination = new DiskFileDestinationOptions(); destination.DiskFileName = @"C:\Content.pdf"; // Set the data source of the report document oDoc.SetDataSource(myDataSet.Tables["Table"]); CrystalDecisions.Shared.ExportOptions option = new ExportOptions(); option.ExportFormatType = ExportFormatType.PortableDocFormat; oDoc.Export(option);

To convert database table in sql server into pdf file using c#.net

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (1)