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

SQL to limit selection

2 Answers 72 Views

GridView

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

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

SQL to limit selection

2 Answers, 1 is accepted