How to create PDFs with data stored in a dataset?

Aspose.PDF Product Family
1
Hello,
I just downloaded the entire Aspose.PDF demo project. Every sample uses XML files? Is there anyway to not use XML files. How do you create these XML files? All I would like to do is simply display a dataset in a PDF. Can you please
show me some sample code to accomplish my task?
Thank you very much for your help in advance!
Susan
2

Hi,

Thank you for considering Aspose.

Please have a look at the following example:

If you need more help, please do let us know.

Thanks.

Adeel Ahmad
Support Developer
Aspose Changsha Team
http://www.aspose.com/Wiki/default.aspx/Aspose.Corporate/ContactChangsha.html

3

Thank you!

table.importDataTable() is exactly what I need. My other question is: how do I format a column inside this table. One of my table column is a date format and I would like it to display it in ShortDate format instead of the default LongDateTime format. Can you please show me how to do that?

Thanks.

4

Hi,

You can define column in your datatable as Datetime. But it is better that you define string column in Datatable and convert your Datetime value to ShortDateString. Please check the code below.

//Add Another Column
dt.Columns.Add("ShortDate", typeof(string));

//Get Your date Value
DateTime testDate = DateTime.Now;

//Convert Date value to Short Date String Format
string myShortDate = testDate.ToShortDateString();

//Add Date value to Datatable
dr[3] = myShortDate;

If you need more help, please do let us know.

Thanks.

Adeel Ahmad
Support Developer
Aspose Changsha Team
http://www.aspose.com/Wiki/default.aspx/Aspose.Corporate/ContactChangsha.html

5
My datatable was predefined to be DateTime format in the business layer and I am referencing in the presentation layer. Therefore, I can't change the datatype for that column.
Is there anyway to format the entire table column to ShortDateString in the Aspose.Pdf.Table
or how would I " //Convert Date value to Short Date String Format" for the the entire datatable as mentioned in your reply?
6

Hi,

You have two options. You can either create a new datatable with the desired columns and populate it form the data that you have in the current datatable. Or, instead of using the ImportDataTable function, you should create the table manually by looping through all the rows in the datatable and in the mean while perform the conversion.

Thanks.

Adeel Ahmad
Support Developer
Aspose Changsha Team
http://www.aspose.com/Wiki/default.aspx/Aspose.Corporate/ContactChangsha.html