I have aSqlDataSourcethat showsresults, butnot shownDataExplorerfields, the query isdone througha stored procedure thatcontainsdynamic SQL.
1 Answer, 1 is accepted
0
Steve
Telerik team
answered on 08 Sep 2011, 05:11 PM
Hello Gustavo,
We evaluate expressions in runtime only thus in design time for DataSource parameter value we pass a null value. If your stored procedure doesn't return records when parameter values are null, we can't retrieve the schema. This is a known issue we have already fixed and we will introduce the fix with the next release.
In the meantime our suggestion is to check for null parameter values in the stored procedure and use default value or return some dummy data for the SqlDataSource to retrieve design time data schema.
Regards,
Steve
the Telerik team
Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward!
We'd appreciate your vote for Telerik in this year's DevProConnections Awards. We are competing in mind-blowing 20 categories and every vote counts! VOTE for Telerik NOW >>