FlexCelReport.AddTable Method
Overloads
- FlexCelReport.AddTable(DataSet)
- FlexCelReport.AddTable(String, DataTable)
- FlexCelReport.AddTable(String, DataView)
- FlexCelReport.AddTable(DataSet, TDisposeMode)
- FlexCelReport.AddTable(String, VirtualDataTable)
- FlexCelReport.AddTable<T>(String, IEnumerable<T>)
- FlexCelReport.AddTable(String, DataTable, TDisposeMode)
- FlexCelReport.AddTable(String, DataView, TDisposeMode)
- FlexCelReport.AddTable(String, VirtualDataTable, TDisposeMode)
- FlexCelReport.AddTable<T>(String, IEnumerable<T>, TDisposeMode)
FlexCelReport.AddTable(DataSet)
Use this method to load all tables on a dataset at once. This is equivalent to calling AddTable(String, DataTable) for each of the tables on the dataset.
Syntax
Namespace: FlexCel.Report
public void AddTable(DataSet tables)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
tables | DataSet | Dataset containing the tables to add. |
Examples
See AddTable(String, DataTable) for an example.
See also
FlexCelReport.AddTable(String, DataTable)
Use this method to tell FlexCel which DataTables or DataViews are available for the report. Note: If you don't know the tables before running the report (and you are not using User Tables or Direct SQL) you can use the LoadTable event to load them in demand instead of using AddTable. This way you will only load the tables you need.
Syntax
Namespace: FlexCel.Report
public void AddTable(String tableName, DataTable table)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
tableName | String | Name that the table will have on the report. | |
table | DataTable | Table that will be available to the report. |
Examples
To allow a report to use Customers and Orders tables, you can use the code:
flexCelReport.AddTable("Customers", CustomersDataTable); //Add datatable Customers to the report.
flexCelReport.AddTable("Orders", OrdersDataView); //Add dataview OrdersDataView to the report.
flexCelReport.AddTable(MyDataSet); //Add all the tables on MyDataSet to the report.
See also
FlexCelReport.AddTable(String, DataView)
Use this method to tell FlexCel which DataTables or DataViews are available for the report. Note: If you don't know the tables before running the report (and you are not using User Tables or Direct SQL) you can use the LoadTable event to load them in demand instead of using AddTable. This way you will only load the tables you need.
Syntax
Namespace: FlexCel.Report
public void AddTable(String tableName, DataView table)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
tableName | String | Name that the table will have on the report. | |
table | DataView | Table that will be available to the report. |
Examples
To allow a report to use Customers and Orders tables, you can use the code:
flexCelReport.AddTable("Customers", CustomersDataTable); //Add datatable Customers to the report.
flexCelReport.AddTable("Orders", OrdersDataView); //Add dataview OrdersDataView to the report.
flexCelReport.AddTable(MyDataSet); //Add all the tables on MyDataSet to the report.
See also
FlexCelReport.AddTable(DataSet, TDisposeMode)
Use this method to load all tables on a dataset at once. When disposeMode is DoNotDispose, this is equivalent to calling AddTable(String, DataTable) for each of the tables on the dataset. If disposeMode is DisposeTable, this will make the same as calling AddTable() with disposeTable equal to false for each table on the dataset. And when finished all the dataset will be disposed.
Syntax
Namespace: FlexCel.Report
public void AddTable(DataSet tables, TDisposeMode disposeMode)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
tables | DataSet | Dataset containing the tables to add. | |
disposeMode | TDisposeMode | When disposeMode is TDisposeMode.DisposeTable, FlexCel will take care of disposing this dataset after running the report. Use it when adding datasets created on the fly, so you do not have to dispose them yourself. |
Examples
See AddTable(String, DataTable) for an example.
See also
FlexCelReport.AddTable(String, VirtualDataTable)
Use this method to add any custom object as a datasource for FlexCel. Make sure to read 'Appendix virtual datasets' in the Reports Developer Guide.
Syntax
Namespace: FlexCel.Report
public void AddTable(String tableName, VirtualDataTable table)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
tableName | String | Name that the table will have on the report. | |
table | VirtualDataTable | Table that will be available in the report. |
See also
FlexCelReport.AddTable<T>(String, IEnumerable<T>)
Use this method to add any IEnumerable as a datasource for FlexCel. You can use this method to add LINQ tables.
Syntax
Namespace: FlexCel.Report
public void AddTable<T>(String tableName, IEnumerable<T> table)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
tableName | String | Name that the table will have on the report. | |
table | IEnumerable<T> | Table that will be available in the report. |
Type Parameters
Type Parameter | Description |
---|---|
T | Type of table being inserted. It must implement IEnumerable. |
See also
FlexCelReport.AddTable(String, DataTable, TDisposeMode)
Use this method to tell FlexCel which DataTables or DataViews are available for the report. Note: If you don't know the tables before running the report (and you are not using User Tables or Direct SQL) you can use the LoadTable event to load them in demand instead of using AddTable. This way you will only load the tables you need.
Syntax
Namespace: FlexCel.Report
public void AddTable(String tableName, DataTable table, TDisposeMode disposeMode)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
tableName | String | Name that the table will have on the report. | |
table | DataTable | Table that will be available to the report. | |
disposeMode | TDisposeMode | When disposeMode is TDisposeMode.DisposeTable, FlexCel will take care of disposing this table after running the report. Use it when adding tables created on the fly, so you do not have to dispose them yourself. |
Examples
To allow a report to use Customers and Orders tables, you can use the code:
flexCelReport.AddTable("Customers", CustomersDataTable); //Add datatable Customers to the report.
flexCelReport.AddTable("Orders", OrdersDataView); //Add dataview OrdersDataView to the report.
flexCelReport.AddTable(MyDataSet); //Add all the tables on MyDataSet to the report.
See also
FlexCelReport.AddTable(String, DataView, TDisposeMode)
Use this method to tell FlexCel which DataTables or DataViews are available for the report. Note: If you don't know the tables before running the report (and you are not using User Tables or Direct SQL) you can use the LoadTable event to load them in demand instead of using AddTable. This way you will only load the tables you need.
Syntax
Namespace: FlexCel.Report
public void AddTable(String tableName, DataView table, TDisposeMode disposeMode)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
tableName | String | Name that the table will have on the report. | |
table | DataView | Table that will be available to the report. | |
disposeMode | TDisposeMode | When disposeMode is TDisposeMode.DisposeTable, FlexCel will take care of disposing this table after running the report. Use it when adding tables created on the fly, so you do not have to dispose them yourself. |
Examples
To allow a report to use Customers and Orders tables, you can use the code:
flexCelReport.AddTable("Customers", CustomersDataTable); //Add datatable Customers to the report.
flexCelReport.AddTable("Orders", OrdersDataView); //Add dataview OrdersDataView to the report.
flexCelReport.AddTable(MyDataSet); //Add all the tables on MyDataSet to the report.
See also
FlexCelReport.AddTable(String, VirtualDataTable, TDisposeMode)
Use this method to add any custom object as a datasource for FlexCel. Make sure to read 'Appendix virtual datasets' in the Reports Developer Guide.
Syntax
Namespace: FlexCel.Report
public void AddTable(String tableName, VirtualDataTable table, TDisposeMode disposeMode)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
tableName | String | Name that the table will have on the report. | |
table | VirtualDataTable | Table that will be available in the report. | |
disposeMode | TDisposeMode | When disposeMode is TDisposeMode.DisposeTable, FlexCel will take care of disposing this table after running the report. Use it when adding tables created on the fly, so you do not have to dispose them yourself. |
See also
FlexCelReport.AddTable<T>(String, IEnumerable<T>, TDisposeMode)
Use this method to add any IEnumerable as a datasource for FlexCel. You can use this method to add LINQ tables.
Syntax
Namespace: FlexCel.Report
public void AddTable<T>(String tableName, IEnumerable<T> table, TDisposeMode disposeMode)
Parameters
<-> | Parameter | Type | Description |
---|---|---|---|
tableName | String | Name that the table will have on the report. | |
table | IEnumerable<T> | Table that will be available in the report. | |
disposeMode | TDisposeMode | When disposeMode is TDisposeMode.DisposeTable, FlexCel will take care of disposing this table after running the report. Use it when adding tables created on the fly, so you do not have to dispose them yourself. |
Type Parameters
Type Parameter | Description |
---|---|
T | Type of the table. |