Spire.DataExport for .NET is a 100% pure data .NET component suit for exporting data into MS Word, Excel, RTF, Access, PDF, XPS, HTML, XML, Text, CSV, DBF, SYLK, SQL Script, DIF, Clipboard, etc.

Tue Feb 22, 2011 5:28 am

"Yesterday, I used Spire.DataExport to export data from database, but I can't connect my database, here I give you my code:
OleDbConnection oleDbConnection = new OleDbConnection();
oleDbConnection.ConnectionString = this.txtCollectionString.Text;
System.Data.OleDb.OleDbCommand oleDbCommand = new System.Data.OleDb.OleDbCommand();
oleDbCommand.CommandText = this.txtCommandText.Text;
Can you help me?? Thank you in advance."

Finalsky
 
Posts: 13
Joined: Wed Dec 22, 2010 1:12 am

Thu Feb 24, 2011 2:43 am

I have realized your problem. After initializing the oleDbConnection and oleDbCommand, you should connect them with the following code: oleDbCommand.Connection = oleDbConnection;
e-iceblue support
User avatar

iceblue support
 
Posts: 240
Joined: Tue Dec 21, 2010 2:56 am

Return to Spire.DataExport