We have built the trial sample PDF Converter project that demonstrates the use of the Export to PDF class and show the results of using the class in several examples.

As you can see on the above figure the sample converter application interface allows you to select data source type you are going to convert. Also it gives you ability to adjust formatting, PDF content merging, font settings, text coloring and other PDF tasks. Download the sample PDF Converter VB.NET and C# projects.

ExportToPDF is helpful to export your SQL Server query result into a formatted PDF file. For this case SourceType property of Rustemsoft.ExportToPDF.Export class object has to be signed as SourceTypes.DataTable. Then the SQL query result should be populated to System.Data.DataTable object. ExportToPDF just converts the DataTable object to PDF.

Imports System.Data

Imports Rustemsoft.ExportToPDF

Imports System.Data.SqlClient

...

Dim ExportToPDFobject As New Rustemsoft.ExportToPDF.Export

Dim Connection As String = "Initial Catalog=[MyDatabaseName];Data Source=[MySQLServerName];UID=[MyUserID];PWD=[psw]"
Dim conn As New SqlConnection(Connection)
conn.Open()
Dim strSQL As String = "SELECT * from MyTable"
Dim cmdMyTable As New SqlCommand(strSQL, conn)
cmdMyTable.CommandType = CommandType.Text
cmdMyTable.CommandTimeout = 6000
' Create a SqlDataAdapter for the MyTable table
Dim tblMyTable As DataTable = New DataTable
Dim adpMyTable As SqlDataAdapter = New SqlDataAdapter
adpMyTable.SelectCommand = cmdMyTable
adpMyTable.Fill(tblMyTable)
ExportToPDFobject.SourceType = SourceTypes.DataTable
ExportToPDFobject.DataSourceTable = tblMyTable

ExportToPDFobject.outputFileName = "C:\MyDirectory\MyTable.pdf"

' Assign specific ExportToPDFobject's PDF formatting, coloring, and others properties
...

' Run conversion to PDF
ExportToPDFobject.Convert()

conn.Close()

using System.Data;

using Rustemsoft.ExportToPDF;

using System.Data.SqlClient;

...

Rustemsoft.ExportToPDF.Export ExportToPDFobject = new Rustemsoft.ExportToPDF.Export();

string Connection = "Initial Catalog=[MyDatabaseName];Data Source=[MySQLServerName];UID=[MyUserID];PWD=[psw]";
SqlConnection conn = new SqlConnection(Connection);
conn.Open();
string strSQL = "SELECT * from MyTable";
SqlCommand cmdMyTable = new SqlCommand(strSQL, conn);
cmdMyTable.CommandType = CommandType.Text;
cmdMyTable.CommandTimeout = 6000;
// Create a SqlDataAdapter for the MyTable table
DataTable tblMyTable = new DataTable();
SqlDataAdapter adpMyTable = new SqlDataAdapter();
adpMyTable.SelectCommand = cmdMyTable;
adpMyTable.Fill(tblMyTable);
ExportToPDFobject.SourceType = SourceTypes.DataTable;
ExportToPDFobject.DataSourceTable = tblMyTable;

ExportToPDFobject.outputFileName = "C:\\MyDirectory\\MyTable.pdf";

// Assign specific ExportToPDFobject's PDF formatting, coloring, and others properties
...

// Run conversion to PDF
ExportToPDFobject.Convert();

conn.Close();