Free Support Forum - aspose.com

Support powerbuilder

Hello,

Does the Aspose.Total Product Family support powerbuilder ?

Thanks!

Best Regards,

Candy

Hi

Thanks for your request. Sure, you can use Aspose.Words in PowerBuilder. Please follow the link for more information:

http://www.aspose.com/documentation/.net-components/aspose.words-for-.net/powerbuilder-aspose-words-for-net.html

Best regards,

Hello,

Could you give me a complete example(application) about using aspose word for .net in powerbuilder?

Thanks!

Best Regards,

Candy

Hello,
Thank you for your inquiry.
I have no installed PowerBuilder. While I set up a virtual environment, could you tell me please what difficulties you are having. This will help us make the article in our documentation better and clearer. Also, have you read this article: http://www.aspose.com/documentation/.net-components/aspose.words-for-.net/use-aspose-words-for-net-via-com-interop.html?

Hello,

I create a example in pb which about binding data, but it doesn't works well, the data of datatable doesn't fill into the table of my document. The attachment is my application.

Thanks!

Hi Candy,

Thank you for additional information. Could you please post your code here? I will check it and provide you more information.

Best regards,

Hello,

Thanks for your reply.The following is my code in pb:

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.mdb";

string commandString = "SELECT * FROM Employees";

oleobject connection;
oleobject RS;
oleobject helper;
oleobject doc;


helper = CREATE oleobject;

helper.ConnectToNewObject("Aspose.Words.ComHelper");


doc = helper.Open("EmployeesReportDemo.doc");

// Create database connection

connection = CREATE oleobject;

connection.ConnectToNewObject("ADODB.Connection");

connection.Open(connectionString);

//Perform data selection

RS = connection.Execute(commandString);

//Execute mail merge

doc.MailMerge.ExecuteADO(RS);

RS.Close();

connection.Close();

doc.Save("D:\out.doc");

Thanks!

Hi Candy,

Thank you for additional information. The problem occurs because you are using ExecuteADO method, but in your case, you should use ExecuteWithRegionsADO. Please follow the link for more information:

http://www.aspose.com/documentation/.net-components/aspose.words-for-.net/aspose.words.reporting.mailmerge.executewithregionsado.html

Your code should look like the following:

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.mdb";

string commandString = "SELECT * FROM Employees";

oleobject connection;

oleobject RS;

oleobject helper;

oleobject doc;

helper = CREATE oleobject;

helper.ConnectToNewObject("Aspose.Words.ComHelper");

doc = helper.Open("EmployeesReportDemo.doc");

// Create database connection

connection = CREATE oleobject;

connection.ConnectToNewObject("ADODB.Connection");

connection.Open(connectionString);

//Perform data selection

RS = connection.Execute(commandString);

//Execute mail merge

doc.MailMerge.ExecuteWithRegionsADO(RS, "Employees");

RS.Close();

connection.Close();

doc.Save("D:\out.doc");

Hope this helps.

Best regards,

Hello,

Thanks for your reply ,it works well now.

Best Regards!

Hello,

The last post I binding only one table in my document, but if there's multi table I used in the document mailmerge filed , how could I do in the code and how should I set the document template? Thanks!

Best Regards

Hi

Thanks for your request. You should just call ExecuteWithRegionsADO method for each region in your template.

Best regards,