SQL to limit selection

3 posts, 0 answers
  1. Rob
    Rob avatar
    61 posts
    Member since:
    Jan 2012

    Posted 14 Oct 2012 Link to this post

    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.


  2. Rob
    Rob avatar
    61 posts
    Member since:
    Jan 2012

    Posted 15 Oct 2012 Link to this post

    Never Mind, got it sorted.

  3. Julian Benkov
    Julian Benkov avatar
    1135 posts

    Posted 17 Oct 2012 Link to this post

    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.
Back to Top