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

SQL to limit selection

2 Answers 54 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Rob
Top achievements
Rank 2
Iron
Veteran
Iron
Rob asked on 15 Oct 2012, 12:41 AM
I have an embarrassingly simple question. 

I'm new to the RadGridView but need to build something for a customer. I have done a mock up of the interface using the built in Project Datasource to show how the grid will work. ( hierarchical presentation etc) and using SQL Database. This was all nice and straightforward.
But now I need to build the actual application using customer selected parameters to form the SQL query. ( does not change the columns, just changes the data returned).

Do I need to completely change the datasource type or can I adapt the DatasetGenerator to update the SQL statement. I have tracked down the CommandText , but this is all private to the class.

What the best approach to use? I have a master and 1 sub level of data to get  or if the user selects to see the data in another way, a completely separate data set to query and display ( with different columns and no hierarchical data).

Thanks a million.

Rob


2 Answers, 1 is accepted

Sort by
0
Rob
Top achievements
Rank 2
Iron
Veteran
Iron
answered on 15 Oct 2012, 08:56 AM
Never Mind, got it sorted.

Thanks
0
Julian Benkov
Telerik team
answered on 17 Oct 2012, 01:31 PM
Hi Rob,

I am glad to hear that you have solved your issue. 

Do not hesitate to contact us if you have further questions or issues. 

Greetings, Julian Benkov
the Telerik team
You’ve been asking for it and now it’s time for us to deliver. RadControls for WinForms Q3 2012 release is just around the corner. Sign up for a free webinar to see first all the latest enhancements.
Tags
GridView
Asked by
Rob
Top achievements
Rank 2
Iron
Veteran
Iron
Answers by
Rob
Top achievements
Rank 2
Iron
Veteran
Iron
Julian Benkov
Telerik team
Share this question
or