Forums Retired Products and Controls
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Paramjeet
55
Looking fo few features from the UltraWebGrid
posted

Hi,

I am looking that how to achieve the following from the Infragistics WebGrid: 

1. I dont want to use the default sorting of the grid, rather want to use custom sorting. What is the way to get which column in grid is clicked for sorting and also its sorting order, as i want to pass them as parameters to my stored procedures to use in 'OrderBy' clause.?

2. I dont want to use the default filter of the grid. Is there any way that i can put an autofill textbox in every column of the grid and whatever i put in the textbox, i should be able to get that on server side and then pass it to my stored procedure to use in 'Like' clause? This should happen ontextchange event of textbox and should be with AJAX.

3. I want to put a context menu whenever i right click on the grid and should be able to create the items in that menu at runtime depending on which row/column is clicked.

4. Since i am using Custom Paging, i am bringing only 50 records in one call from the database and not all the records (i.e, 1000) and i know GridViewExporter exports only those records which are currently in the recordset. Is there any way by which i can export all the 1000 records and not just 50? Can i assign a new datasource to the ASPxGridViewExporter?

Also, Is there any way to export the grid in multiple work sheets in same excel work book. As excel can have a max of 65535 rows, how to export a grid with more then 65535 rows in other worksheet (rows after 65535).

5. I want to display data in Master/Detail form i.e, in first call to database only master records will come and whenever i expand the master row, itshould fetch corresponding details records (Hierarchical data in grid)

I appreciate the quick response.

Thanks in Advance!

Param 

  • 3147
    posted

    Hi Param,

    according to point 2 you can use theOnRowFilterApplying server event which is fired before the filter is applied, then you can get the filtered column and value and then apply your custom logic:

    protected void UltraWebGrid1_RowFilterApplying(object sender, Infragistics.WebUI.UltraWebGrid.FilterEventArgs e)
    {
        string column = e.ActiveColumnFilter.Key;
            string value = e.ActiveColumnFilter.FilterConditions[0].CompareValue as string;
        // your custom logic
    }

  • 7694
    posted

     

    Hello,

    1.  You can use the property AllowSortingDefault="No" of DisplayLayout to disable sorting. 

    3. You can use the property WebMenuTarget=PopupMenu of UltraWebMenu and with JavaScript to catch ClientSideEvents of UltraWebGrid to manipulate your grid.

    4. You can use the properties Pager-AllowPaging="true" and  Pager-PageSize="50" of DisplayLayout tag to allow paging and set rows of aeach page.

    5. You can see this sample at:

    http://samples.infragistics.com/2008.2/webfeaturebrowser/default.htm

    Grid -> Load on Demand- Auto.

     Hope this helps.