[CLOSED] Remote paging/sorting/filtering on SQLDataSource for GridPanel

  1. #1

    [CLOSED] Remote paging/sorting/filtering on SQLDataSource for GridPanel

    Is there an example of remote sorting, filtering, and paging with an SQLDataSource? I have a fairly large table that I want user to have ability to view. I looked at the various GridPanel examples in Examples Explorer, but the only remote Filtering example is based on objects.
  2. #2

    RE: [CLOSED] Remote paging/sorting/filtering on SQLDataSource for GridPanel

    Hi jchau,

    https://examples1.ext.net/#/GridPane...g_and_Sorting/

    it is example with ObjectDataSource but you can easly convert it to SqlDataSource


  3. #3

    RE: [CLOSED] Remote paging/sorting/filtering on SQLDataSource for GridPanel

    just want to know how exactly the gridpanel put default value for sort and dir parameter. here's the problem, i convert the gridpanel sorting and paging code to VB.NET (code behind) and the other things are exactly the same. but when i run it, on first load there is no data, when i sort it then the data load properly.*i do debugging and see during the first load sort parameter always return nothing. and also based on the example, you never set the default value for sort and dir parameter. so anythings i missing here?


  4. #4

    RE: [CLOSED] Remote paging/sorting/filtering on SQLDataSource for GridPanel

    Hi aswad32,

    This example does not require sort and dir for retrieve data (if sort and dir are absent then unsorted data return). It seems that your business logic requires these parameters. You can set default sort and dir in Store

    <SortInfo Field="LastName" Direction="ASC" />
    or in AutoLoadParams of store

                <AutoLoadParams>
                    <ext:Parameter Name="sort" Value="LastName" />
                    <ext:Parameter Name="dir" Value="ASC" />
                </AutoLoadParams>

  5. #5

    RE: [CLOSED] Remote paging/sorting/filtering on SQLDataSource for GridPanel

    *yosh, one problem solved, in autoloadparam previously i put s'thing like this
    	<AutoLoadParams>
    
         	<ext:Parameter Name="sort" Value="={'LastName'}" />
            <ext:Parameter Name="dir" Value="={'ASC'}" />
        </AutoLoadParams>

    thanks for showing me the right way...
  6. #6

    RE: [CLOSED] Remote paging/sorting/filtering on SQLDataSource for GridPanel



    Hi aswad32,

    You shouldn't require the ={''} token wrapper around the Value properties. The following code sample should reproduce the exact same result.

    Example

    <AutoLoadParams>
        <ext:Parameter Name="sort" Value="LastName" />
        <ext:Parameter Name="dir" Value="ASC" />
    </AutoLoadParams>
    Hope this helps.
    Geoffrey McGill
    Founder
  7. #7
    Quote Originally Posted by Vladimir View Post
    Hi jchau,

    https://examples1.ext.net/#/GridPane...g_and_Sorting/

    it is example with ObjectDataSource but you can easly convert it to SqlDataSource
    Hi Vladimir,
    https://examples1.ext.net/#/GridPane...g_and_Sorting/
    link doesn't work for some reason
    Thank You

Similar Threads

  1. GridPanel Remote Paging with SqlDatasource
    By Aod47 in forum 1.x Help
    Replies: 1
    Last Post: Oct 25, 2013, 6:00 AM
  2. Replies: 11
    Last Post: Jun 13, 2012, 4:53 PM
  3. [CLOSED] remote paging and sorting with SQL
    By marco.morreale in forum 2.x Legacy Premium Help
    Replies: 13
    Last Post: Apr 27, 2012, 4:02 PM
  4. Replies: 0
    Last Post: Aug 16, 2010, 10:28 PM
  5. Replies: 5
    Last Post: Jul 23, 2010, 8:52 AM

Posting Permissions