Demo

Subscribe to this RSS feed

Demo (8)

Sunday, 01 August 2010 18:57

Data Export Text/SYLK/CSV/DIF for C#, VB.NET

Written by Administrator

Demo
C# source
VB.Net source

This sample demonstrates how to export data table to text/sylk/csv/dif file.

The picture above represents using Excel application to open the a SYLK type output file.

private void btnText_Click(object sender, EventArgs e)
{
    System.Data.OleDb.OleDbConnection oleDbConnection1
         = new System.Data.OleDb.OleDbConnection();
    oleDbConnection1.ConnectionString
        = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb";

    System.Data.OleDb.OleDbCommand oleDbCommand1
        = new System.Data.OleDb.OleDbCommand();
    oleDbCommand1.CommandText = "select * from parts";
    oleDbCommand1.Connection = oleDbConnection1;

    Spire.DataExport.TXT.TXTExport txtExport1
        = new Spire.DataExport.TXT.TXTExport();

    txtExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
    txtExport1.DataFormats.CultureName = "zh-CN";
    txtExport1.DataFormats.Currency = "c";
    txtExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
    txtExport1.DataFormats.Float = "g";
    txtExport1.DataFormats.Integer = "g";
    txtExport1.DataFormats.Time = "H:mm";
    txtExport1.DataEncoding = Spire.DataExport.Common.EncodingType.ASCII;
    txtExport1.SQLCommand = oleDbCommand1;

    oleDbConnection1.Open();

    txtExport1.ExportType = Spire.DataExport.TXT.TextExportType.SYLK;
    txtExport1.FileName = "sample.slk";
    txtExport1.SaveToFile();

    txtExport1.ExportType = Spire.DataExport.TXT.TextExportType.CSV;
    txtExport1.FileName = "sample.csv";
    txtExport1.SaveToFile();

    txtExport1.ExportType = Spire.DataExport.TXT.TextExportType.DIF;
    txtExport1.FileName = "sample.dif";
    txtExport1.SaveToFile();

    txtExport1.ExportType = Spire.DataExport.TXT.TextExportType.TXT;
	txtExport1.FileName = "sample.txt";
	txtExport1.SaveToFile();
}

Private Sub btnText_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnText.Click
    Dim oleDbConnection1 As New System.Data.OleDb.OleDbConnection()
    oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb"

    Dim oleDbCommand1 As New System.Data.OleDb.OleDbCommand()
    oleDbCommand1.CommandText = "select * from parts"
    oleDbCommand1.Connection = oleDbConnection1

    Dim txtExport1 As New Spire.DataExport.TXT.TXTExport()

    txtExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
    txtExport1.DataFormats.CultureName = "zh-CN"
    txtExport1.DataFormats.Currency = "c"
    txtExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
    txtExport1.DataFormats.Float = "g"
    txtExport1.DataFormats.[Integer] = "g"
    txtExport1.DataFormats.Time = "H:mm"
    txtExport1.DataEncoding = Spire.DataExport.Common.EncodingType.ASCII
    txtExport1.SQLCommand = oleDbCommand1

    oleDbConnection1.Open()

    txtExport1.ExportType = Spire.DataExport.TXT.TextExportType.SYLK
    txtExport1.FileName = "sample.slk"
    txtExport1.SaveToFile()

    txtExport1.ExportType = Spire.DataExport.TXT.TextExportType.CSV
    txtExport1.FileName = "sample.csv"
    txtExport1.SaveToFile()

    txtExport1.ExportType = Spire.DataExport.TXT.TextExportType.DIF
    txtExport1.FileName = "sample.dif"
    txtExport1.SaveToFile()

    txtExport1.ExportType = Spire.DataExport.TXT.TextExportType.TXT
    txtExport1.FileName = "sample.txt"
    txtExport1.SaveToFile()
End Sub

Published in Demo

Tagged under

Sunday, 01 August 2010 18:50

Data Export SQL Script for C#, VB.NET

Written by Administrator

Demo
C# source
VB.Net source

This sample demonstrates how to export data table to sql script.

private void btnSQLScript_Click(object sender, EventArgs e)
{
    System.Data.OleDb.OleDbConnection oleDbConnection1
         = new System.Data.OleDb.OleDbConnection();
    oleDbConnection1.ConnectionString
        = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb";

    System.Data.OleDb.OleDbCommand oleDbCommand1
        = new System.Data.OleDb.OleDbCommand();
    oleDbCommand1.CommandText = "select * from parts";
    oleDbCommand1.Connection = oleDbConnection1;

    Spire.DataExport.SQL.SQLExport sqlExport1
        = new Spire.DataExport.SQL.SQLExport();

    sqlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
    sqlExport1.CommitStatement = "COMMIT;";
    sqlExport1.DataFormats.CultureName = "zh-CN";
    sqlExport1.DataFormats.Currency = "c";
    sqlExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
    sqlExport1.DataFormats.Float = "g";
    sqlExport1.DataFormats.Integer = "g";
    sqlExport1.DataFormats.Time = "H:mm";
    sqlExport1.FileName = "sample.sql";
    sqlExport1.SQLCommand = oleDbCommand1;
    sqlExport1.TableName = "TestTable";

    oleDbConnection1.Open();
    sqlExport1.SaveToFile();
}

Private Sub btnSQLScript_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSQLScript.Click
    Dim oleDbConnection1 As New System.Data.OleDb.OleDbConnection()
    oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb"

    Dim oleDbCommand1 As New System.Data.OleDb.OleDbCommand()
    oleDbCommand1.CommandText = "select * from parts"
    oleDbCommand1.Connection = oleDbConnection1

    Dim sqlExport1 As New Spire.DataExport.SQL.SQLExport()

    sqlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
    sqlExport1.CommitStatement = "COMMIT;"
    sqlExport1.DataFormats.CultureName = "zh-CN"
    sqlExport1.DataFormats.Currency = "c"
    sqlExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
    sqlExport1.DataFormats.Float = "g"
    sqlExport1.DataFormats.[Integer] = "g"
    sqlExport1.DataFormats.Time = "H:mm"
    sqlExport1.FileName = "sample.sql"
    sqlExport1.SQLCommand = oleDbCommand1
    sqlExport1.TableName = "TestTable"

    oleDbConnection1.Open()
    sqlExport1.SaveToFile()
End Sub

Published in Demo

Tagged under

Sunday, 01 August 2010 18:38

Data Export XML for C#, VB.NET

Written by Administrator

Demo
C# source
VB.Net source

This sample demonstrates how to export data table into xml file.

private void btnXML_Click(object sender, EventArgs e)
{
    System.Data.OleDb.OleDbConnection oleDbConnection1
         = new System.Data.OleDb.OleDbConnection();
    oleDbConnection1.ConnectionString
        = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb";

    System.Data.OleDb.OleDbCommand oleDbCommand1
        = new System.Data.OleDb.OleDbCommand();
    oleDbCommand1.CommandText = "select * from parts";
    oleDbCommand1.Connection = oleDbConnection1;

    Spire.DataExport.XML.XMLExport xmlExport1
        = new Spire.DataExport.XML.XMLExport();

    xmlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
    xmlExport1.DataFormats.CultureName = "zh-CN";
    xmlExport1.DataFormats.Currency = "c";
    xmlExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
    xmlExport1.DataFormats.Float = "g";
    xmlExport1.DataFormats.Integer = "g";
    xmlExport1.DataFormats.Time = "H:mm";
    xmlExport1.FileName = "sample.xml";
    xmlExport1.SQLCommand = oleDbCommand1;

    oleDbConnection1.Open();
    xmlExport1.SaveToFile();
}

Private Sub btnXML_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnXML.Click
    Dim oleDbConnection1 As New System.Data.OleDb.OleDbConnection()
    oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb"

    Dim oleDbCommand1 As New System.Data.OleDb.OleDbCommand()
    oleDbCommand1.CommandText = "select * from parts"
    oleDbCommand1.Connection = oleDbConnection1

    Dim xmlExport1 As New Spire.DataExport.XML.XMLExport()

    xmlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
    xmlExport1.DataFormats.CultureName = "zh-CN"
    xmlExport1.DataFormats.Currency = "c"
    xmlExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
    xmlExport1.DataFormats.Float = "g"
    xmlExport1.DataFormats.[Integer] = "g"
    xmlExport1.DataFormats.Time = "H:mm"
    xmlExport1.FileName = "sample.xml"
    xmlExport1.SQLCommand = oleDbCommand1

    oleDbConnection1.Open()
    xmlExport1.SaveToFile()
End Sub

Published in Demo

Tagged under

Sunday, 01 August 2010 18:20

Data Export MS Access for C#, VB.NET

Written by Administrator

Demo
C# source
VB.Net source

This sample demonstrates how to export data table into ms-access file.

The picture above represents using Excel application to open the result ms-access file.

private void btnMSAccess_Click(object sender, EventArgs e)
{
    System.Data.OleDb.OleDbConnection oleDbConnection1
         = new System.Data.OleDb.OleDbConnection();
    oleDbConnection1.ConnectionString
        = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb";

    System.Data.OleDb.OleDbCommand oleDbCommand1
        = new System.Data.OleDb.OleDbCommand();
    oleDbCommand1.CommandText = "select * from parts";
    oleDbCommand1.Connection = oleDbConnection1;

    Spire.DataExport.Access.AccessExport accessExport1
        = new Spire.DataExport.Access.AccessExport();

    accessExport1.DatabaseName = "test.mdb";
    accessExport1.DataFormats.CultureName = "zh-CN";
    accessExport1.DataFormats.Currency = "c";
    accessExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
    accessExport1.DataFormats.Float = "g";
    accessExport1.DataFormats.Integer = "g";
    accessExport1.DataFormats.Time = "H:mm";
    accessExport1.SQLCommand = oleDbCommand1;
    accessExport1.TableName = "ExportData";

    oleDbConnection1.Open();
    accessExport1.SaveToFile();
}

Private Sub btnMSAccess_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnMSAccess.Click
    Dim oleDbConnection1 As New System.Data.OleDb.OleDbConnection()
    oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb"

    Dim oleDbCommand1 As New System.Data.OleDb.OleDbCommand()
    oleDbCommand1.CommandText = "select * from parts"
    oleDbCommand1.Connection = oleDbConnection1

    Dim accessExport1 As New Spire.DataExport.Access.AccessExport()

    accessExport1.DatabaseName = "test.mdb"
    accessExport1.DataFormats.CultureName = "zh-CN"
    accessExport1.DataFormats.Currency = "c"
    accessExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
    accessExport1.DataFormats.Float = "g"
    accessExport1.DataFormats.[Integer] = "g"
    accessExport1.DataFormats.Time = "H:mm"
    accessExport1.SQLCommand = oleDbCommand1
    accessExport1.TableName = "ExportData"

    oleDbConnection1.Open()
    accessExport1.SaveToFile()
End Sub

Published in Demo

Tagged under

Sunday, 01 August 2010 18:05

Data Export DBF for C#, VB.NET

Written by Administrator

Demo
C# source
VB.Net source

This sample demonstrates how to export data table into dbf file.

The picture above represents using Excel application to open the result dbf file.

private void btnDBF_Click(object sender, EventArgs e)
{
    System.Data.OleDb.OleDbConnection oleDbConnection1
         = new System.Data.OleDb.OleDbConnection();
    oleDbConnection1.ConnectionString
        = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb";

    System.Data.OleDb.OleDbCommand oleDbCommand1
        = new System.Data.OleDb.OleDbCommand();
    oleDbCommand1.CommandText = "select * from parts";
    oleDbCommand1.Connection = oleDbConnection1;

    Spire.DataExport.DBF.DBFExport dbfExport1
        = new Spire.DataExport.DBF.DBFExport();

    dbfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
    dbfExport1.FileName = "sample.dbf";
    dbfExport1.SQLCommand = oleDbCommand1;

    oleDbConnection1.Open();
    dbfExport1.SaveToFile();
}

Private Sub btnDBF_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDBF.Click
    Dim oleDbConnection1 As New System.Data.OleDb.OleDbConnection()
    oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb"

    Dim oleDbCommand1 As New System.Data.OleDb.OleDbCommand()
    oleDbCommand1.CommandText = "select * from parts"
    oleDbCommand1.Connection = oleDbConnection1

    Dim dbfExport1 As New Spire.DataExport.DBF.DBFExport()

    dbfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
    dbfExport1.FileName = "sample.dbf"
    dbfExport1.SQLCommand = oleDbCommand1

    oleDbConnection1.Open()
    dbfExport1.SaveToFile()
End Sub

Published in Demo

Tagged under

Sunday, 01 August 2010 17:53

Data Export Clipboard for C#, VB.NET

Written by Administrator

Demo
C# source
VB.Net source

This sample demonstrates how to export data table into clipboard.

private void btnClipboard_Click(object sender, EventArgs e)
{
    System.Data.OleDb.OleDbConnection oleDbConnection1
         = new System.Data.OleDb.OleDbConnection();
    oleDbConnection1.ConnectionString
        = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb";

    System.Data.OleDb.OleDbCommand oleDbCommand1
        = new System.Data.OleDb.OleDbCommand();
    oleDbCommand1.CommandText = "select * from parts";
    oleDbCommand1.Connection = oleDbConnection1;

    Spire.DataExport.Clipboard.ClipboardExport clipboardExport1
        = new Spire.DataExport.Clipboard.ClipboardExport();

    clipboardExport1.DataFormats.CultureName = "zh-CN";
    clipboardExport1.DataFormats.Currency = "c";
    clipboardExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
    clipboardExport1.DataFormats.Float = "g";
    clipboardExport1.DataFormats.Integer = "g";
    clipboardExport1.DataFormats.Time = "H:mm";
    clipboardExport1.ShowContent = true;
    clipboardExport1.SQLCommand = oleDbCommand1;

    oleDbConnection1.Open();
    clipboardExport1.SaveToFile();
}

Private Sub btnClipboard_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClipboard.Click
    Dim oleDbConnection1 As New System.Data.OleDb.OleDbConnection()
    oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb"

    Dim oleDbCommand1 As New System.Data.OleDb.OleDbCommand()
    oleDbCommand1.CommandText = "select * from parts"
    oleDbCommand1.Connection = oleDbConnection1

    Dim clipboardExport1 As New Spire.DataExport.Clipboard.ClipboardExport()

    clipboardExport1.DataFormats.CultureName = "zh-CN"
    clipboardExport1.DataFormats.Currency = "c"
    clipboardExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
    clipboardExport1.DataFormats.Float = "g"
    clipboardExport1.DataFormats.[Integer] = "g"
    clipboardExport1.DataFormats.Time = "H:mm"
    clipboardExport1.ShowContent = True
    clipboardExport1.SQLCommand = oleDbCommand1

    oleDbConnection1.Open()
    clipboardExport1.SaveToFile()
End Sub

Published in Demo

Tagged under

Sunday, 01 August 2010 17:47

Data Export RTF for C#, VB.NET

Written by Administrator

Demo
C# source
VB.Net source

This sample demonstrates how to export data table into rtf file.

private void btnRTF_Click(object sender, EventArgs e)
{
    System.Data.OleDb.OleDbConnection oleDbConnection1
         = new System.Data.OleDb.OleDbConnection();
    oleDbConnection1.ConnectionString
        = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb";

    System.Data.OleDb.OleDbCommand oleDbCommand1
        = new System.Data.OleDb.OleDbCommand();
    oleDbCommand1.CommandText = "select * from parts";
    oleDbCommand1.Connection = oleDbConnection1;

    Spire.DataExport.RTF.RTFExport rtfExport1
        = new Spire.DataExport.RTF.RTFExport();

    rtfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
    rtfExport1.DataFormats.CultureName = "zh-CN";
    rtfExport1.DataFormats.Currency = "c";
    rtfExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
    rtfExport1.DataFormats.Float = "g";
    rtfExport1.DataFormats.Integer = "g";
    rtfExport1.DataFormats.Time = "H:mm";
    rtfExport1.FileName = "sample.doc";
    rtfExport1.RTFOptions.DataStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
    rtfExport1.RTFOptions.FooterStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
    rtfExport1.RTFOptions.HeaderStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
    rtfExport1.RTFOptions.TitleStyle.Alignment = Spire.DataExport.RTF.RtfTextAlignment.Center;
    rtfExport1.RTFOptions.TitleStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
    rtfExport1.SQLCommand = oleDbCommand1;

    oleDbConnection1.Open();
    rtfExport1.SaveToFile();
}

Private Sub btnRTF_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRTF.Click
    Dim oleDbConnection1 As New System.Data.OleDb.OleDbConnection()
    oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb"

    Dim oleDbCommand1 As New System.Data.OleDb.OleDbCommand()
    oleDbCommand1.CommandText = "select * from parts"
    oleDbCommand1.Connection = oleDbConnection1

    Dim rtfExport1 As New Spire.DataExport.RTF.RTFExport()

    rtfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
    rtfExport1.DataFormats.CultureName = "zh-CN"
    rtfExport1.DataFormats.Currency = "c"
    rtfExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
    rtfExport1.DataFormats.Float = "g"
    rtfExport1.DataFormats.[Integer] = "g"
    rtfExport1.DataFormats.Time = "H:mm"
    rtfExport1.FileName = "sample.doc"
    rtfExport1.RTFOptions.DataStyle.Font = New System.Drawing.Font("Arial", 10.0F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World)
    rtfExport1.RTFOptions.FooterStyle.Font = New System.Drawing.Font("Arial", 10.0F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World)
    rtfExport1.RTFOptions.HeaderStyle.Font = New System.Drawing.Font("Arial", 10.0F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World)
    rtfExport1.RTFOptions.TitleStyle.Alignment = Spire.DataExport.RTF.RtfTextAlignment.Center
    rtfExport1.RTFOptions.TitleStyle.Font = New System.Drawing.Font("Arial", 10.0F, System.Drawing.FontStyle.Bold)
    rtfExport1.SQLCommand = oleDbCommand1

    oleDbConnection1.Open()
    rtfExport1.SaveToFile()
End Sub

Published in Demo

Tagged under

Sunday, 01 August 2010 17:22

Data Export PDF for C#, VB.NET

Written by Administrator

Demo
C# source
VB.Net source

This sample demonstrates how to export data table into pdf file.

private void btnPDF_Click(object sender, EventArgs e)
{
    System.Data.OleDb.OleDbConnection oleDbConnection1
         = new System.Data.OleDb.OleDbConnection();
    oleDbConnection1.ConnectionString
        = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb";

    System.Data.OleDb.OleDbCommand oleDbCommand1
        = new System.Data.OleDb.OleDbCommand();
    oleDbCommand1.CommandText = "select * from parts";
    oleDbCommand1.Connection = oleDbConnection1;

    Spire.DataExport.PDF.PDFExport pdfExport1 = new Spire.DataExport.PDF.PDFExport();
    pdfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
    pdfExport1.DataFormats.CultureName = "zh-CN";
    pdfExport1.DataFormats.Currency = "c";
    pdfExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
    pdfExport1.DataFormats.Float = "g";
    pdfExport1.DataFormats.Integer = "g";
    pdfExport1.DataFormats.Time = "H:mm";
    pdfExport1.FileName = "sample.pdf";
    pdfExport1.PDFOptions.DataFont.CustomFont = new System.Drawing.Font("Arial", 10F);
    pdfExport1.PDFOptions.FooterFont.CustomFont = new System.Drawing.Font("Arial", 10F);
    pdfExport1.PDFOptions.HeaderFont.CustomFont = new System.Drawing.Font("Arial", 10F);
    pdfExport1.PDFOptions.PageOptions.Format = Spire.DataExport.PDF.PageFormat.User;
    pdfExport1.PDFOptions.PageOptions.Height = 11.67;
    pdfExport1.PDFOptions.PageOptions.MarginBottom = 0.78;
    pdfExport1.PDFOptions.PageOptions.MarginLeft = 1.17;
    pdfExport1.PDFOptions.PageOptions.MarginRight = 0.57;
    pdfExport1.PDFOptions.PageOptions.MarginTop = 0.78;
    pdfExport1.PDFOptions.PageOptions.Width = 10.25;
    pdfExport1.PDFOptions.TitleFont.CustomFont = new System.Drawing.Font("Arial", 10F);
    pdfExport1.SQLCommand = oleDbCommand1;

    oleDbConnection1.Open();
    pdfExport1.SaveToFile();
}

Private Sub btnPDF_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnPDF.Click
    Dim oleDbConnection1 As New System.Data.OleDb.OleDbConnection()
    oleDbConnection1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\..\Database\demo.mdb"

    Dim oleDbCommand1 As New System.Data.OleDb.OleDbCommand()
    oleDbCommand1.CommandText = "select * from parts"
    oleDbCommand1.Connection = oleDbConnection1

    Dim pdfExport1 As New Spire.DataExport.PDF.PDFExport()
    pdfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
    pdfExport1.DataFormats.CultureName = "zh-CN"
    pdfExport1.DataFormats.Currency = "c"
    pdfExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
    pdfExport1.DataFormats.Float = "g"
    pdfExport1.DataFormats.[Integer] = "g"
    pdfExport1.DataFormats.Time = "H:mm"
    pdfExport1.FileName = "sample.pdf"
    pdfExport1.PDFOptions.DataFont.CustomFont = New System.Drawing.Font("Arial", 10.0F)
    pdfExport1.PDFOptions.FooterFont.CustomFont = New System.Drawing.Font("Arial", 10.0F)
    pdfExport1.PDFOptions.HeaderFont.CustomFont = New System.Drawing.Font("Arial", 10.0F)
    pdfExport1.PDFOptions.PageOptions.Format = Spire.DataExport.PDF.PageFormat.User
    pdfExport1.PDFOptions.PageOptions.Height = 11.67
    pdfExport1.PDFOptions.PageOptions.MarginBottom = 0.78
    pdfExport1.PDFOptions.PageOptions.MarginLeft = 1.17
    pdfExport1.PDFOptions.PageOptions.MarginRight = 0.57
    pdfExport1.PDFOptions.PageOptions.MarginTop = 0.78
    pdfExport1.PDFOptions.PageOptions.Width = 10.25
    pdfExport1.PDFOptions.TitleFont.CustomFont = New System.Drawing.Font("Arial", 10.0F)
    pdfExport1.SQLCommand = oleDbCommand1

    oleDbConnection1.Open()
    pdfExport1.SaveToFile()
End Sub

Published in Demo

Tagged under