How to Build a Table from a DataTable
Often your application will pull data from a database and store it in the form of a DataTable. You may wish to easily insert this data into your document as a new table and quickly apply formatting to the whole table. Using Aspose.Words this task is very simple to achieve. The code presented within this article demonstrates how to do this.
Note that the preferred way of inserting data from a DataTable into a document table is by using Mail Merge with Regions . The technique presented in this article is only suggested if you are unable to create a suitable template before hand to merge data with, in other words if you require everything to happen programmatically.
- Create a new DocumentBuilder object on your Document.
- Start a new table using DocumentBuilder.
- If we want to insert the names of each of the columns from our DataTable as a header row then iterate through each data column and write the column names into a row in the table.
- Iterate through each DataRow in the DataTable.
- Iterate through each object in the DataRow.
- Insert the object into the document using DocumentBuilder. The method used depends on the type of the object being inserted e.g DocumentBuilder.Writeln for text and DocumentBuilder.InsertImage for a byte array which represents an image.
- At the end of processing of the DataRow also end the row being created by the DocumentBuilder by using DocumentBuilder.EndRow.
- Once all rows from the DataTable have been processed finish the table by calling DocumentBuilder.EndTable.
- Finally we can set the desired table style using one of the appropriate table properties such as Table.StyleIdentifier to automatically apply formatting to the entire table.
The following data in our DataTable is used in this example:
The following code demonstrates how to achieve this in Aspose.Words. The ImportTableFromDataTable method accepts a DocumentBuilder object, the DataTable containing the data and a flag which specifies if the column heading from the DataTable are included at the top of the table. This method builds a table from these parameters using the builder’s current position and formatting. Provides a method to import data from the DataTable and insert it into a new table using the DocumentBuilder.
The method can then be easily called using your DocumentBuilder and data. Below code sample shows how to import the data from a DataTable and insert it into a new table in the document.