I have created a report and added a table to the detail section.
I have set the sql datasource of this table at design time. The sql data source is dynamic and can return a different number of columns at run time.
I would like to be able to get (or convert) the sqldatasource into a datatable at run time so I can identify the number of columns and column names returned by the datasource and build the table dynamically.
I have managed to build a dynamic table but I cannot figure out how to convert or access the sql datasources dataset/datatable/rawdata. How do I do this? is it even possible?
Thanks in advance.
I have set the sql datasource of this table at design time. The sql data source is dynamic and can return a different number of columns at run time.
I would like to be able to get (or convert) the sqldatasource into a datatable at run time so I can identify the number of columns and column names returned by the datasource and build the table dynamically.
I have managed to build a dynamic table but I cannot figure out how to convert or access the sql datasources dataset/datatable/rawdata. How do I do this? is it even possible?
Thanks in advance.
1 Answer, 1 is accepted
0
Hadib Ahmabi
Top achievements
Rank 1
Rank 1
answered on 01 Feb 2013, 01:18 PM
Since you are building your tables programmatically, it is pointless to use SqlDataSource. Simply use SqlDataAdapter and fill the data to a DataTable/Set.