This is a migrated thread and some comments may be shown as answers.

Parameters

1 Answer 51 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
alex alex
Top achievements
Rank 1
alex alex asked on 05 Jun 2014, 10:15 PM
Hello.
telerik reporting:

I'm doing some reports but I think consultation with a string and pass it to SqlQuery.SelectCommand need.

example:
this.SqlQuery.SelectCommand = "SELECT * FROM WHERE EMBARQUE_HISTORICO_DOV (FECHA_EMBARQUE> = TO_DATE (\ '22 / 05/2014" + "\ ', \' dd / MM / yyyy \ ')) AND (FECHA_EMBARQUE <= TO_DATE (\ '23 / 05/2014 \ ', \' dd / MM / yyyy \ ')) ";
I enter that manually and it generates the report, we mention that this database pl / sql developer.

So I think my string and the select, from and where I need and what happened as a parameter to the report. As the recovery of the parameter string in telerik reporting.
Should be:
this.SqlQuery.SelectCommand = Mystring

1 Answer, 1 is accepted

Sort by
0
Peter
Telerik team
answered on 10 Jun 2014, 11:26 AM
Hello Alex,

Our recommendation is to use our declarative datasource components. In your case our suggestion is to try the SqlDataSource component.  Using SqlDataSource allows you to access and display data in a report without using ADO.NET classes directly. The component supports any ADO.NET data provider.
Additionally check out the SqlDataSource Wizard that helps you to setup the SqlDataSource component. 

Regards,
Peter
Telerik
 

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

 
Tags
General Discussions
Asked by
alex alex
Top achievements
Rank 1
Answers by
Peter
Telerik team
Share this question
or