Convert sqldatasource to dataTable issues

[Fadhli]

I'm trying to convert sqldatasource to dataTable but I recieved an error.

Here is the error:
'Telerik.Reporting.SqlDataSource' does not contain a definition for 'Select' and no extension method 'Select' accepting a first argument of type 'Telerik.Reporting.SqlDataSource' could be found (are you missing a using directive or an assembly reference?)

DataSourceSelectArguments args = new DataSourceSelectArguments();
DataView view = (DataView)sqlDataSource1.Select(args);
DataTable table = view.ToTable();

Which namespace should I use and which assembly should I add? Or maybe its not supported?

[Steve]

Hello Fadhli,

We would appreciate if you provide more information on your scenario - what is your data, what is your report setup, what are you trying to accomplish and where is this code invoked etc.

Regards,
Steve
the Telerik team

[sulejman Vezi]

Hi.

I'm also interested in how to do this.

            DataView dv = new DataView();
            DataTable dt = new DataTable();
            dv = SQLDataSource1.Select(DataSourceSelectArguments.Empty);
            dt = dv.ToTable();


Best
Suli

[Peter]

Hi Suli,

Telerik Reporting SqlDataSource component is a declarative datasource component that is used internally by the reporting engine. It can't be used to fill DataTable or DataView with data. Instead to fill your DataTable our recommendation is to use the standard .NET approach with SqlDataAdapter. For an example check out the Populate DataTable with records from database? stackoverflow article.

Regards,
Peter
Telerik

[Rahul]

Hi All,
I am facing same issue to sqldatasource to DataTable issues. I need this solution to fix below scenario.

In my report I am calling stored procedure using sqldatasource1.  Let’s say Stored procedure is returning data as below.

Column1      Column2        Column3      Column4
RowData     RowData        RowData      RowData
RowData     RowData        RowData      RowData

And I am assigning those data to Report using
       this.DataSource = sqldatasource1

The actual issue is When I export to .csv, It’s returning all the data which SP is returning. I want to remove some column based on condition before I assign to this.dataSource. In front end I am hiding unwanted column but while exporting to .csv it is exporting all the column.
Using DataTable I can Perform this operation like DT.Column.remove(“Column1”). But I same fix is not working with sqldatasource that I can understand but I have below question.
1 ) Is there any other way to control Data to export in .csv file(remove column from sqldatasource ). Without modify in Stored procedure.?
2 ) If no, Then How to perform above operation using sqldatasource.?

Is there anyone having this issue?
Please suggest fix this issue.

Many Thanks,
Rahul

[Stef]

Hi Rahul,

The CSV rendering mechanism exports the report layout with data, means how data is visualized by the report - Design Considerations for CSV Rendering.

If you want to export only data in CSV format, please consider retrieving data in code and exporting in a text file without going through a report e.g. Export Datatable to CSV Using Extension Method (external resource).


I hope this helps.

Regards,
Stef
Telerik by Progress