Intersoft Community - WebGrid Enterprise - Pagingloadmode="VirtualLoadmode and Custom Virtual load mode

Pagingloadmode="VirtualLoadmode and Custom Virtual load mode

Skgrid@intersoftpt.com — Tue, 12 Nov 2013 09:49:54 GMT

Hi Yudi,

How the classic paging will help?

Because it is also binding the entire data.

We want to achieve the binding of only specified records.

Please add this paging requirement as a feature request?

Regards,
Madhavan

Pagingloadmode="VirtualLoadmode and Custom Virtual load mode

yudi — Sun, 18 Aug 2013 22:57:54 GMT

Apologize for the delay in sending this.

When enabled, VirtualLoad paging feature work as follow: initially load 50 rows (or n number of rows as specified in VirtualPageSize property); as user scroll the data forward more data will be retrieved from server transparently and virtually; previously displayed data is retained along with the currently required page.

On the custom mode, developers need to specify the data fetching logic. Per your request, you will need to query the data so that it will return n rows of data as specified in VirtualPageSize property (not load top n rows). I use following select query to return n rows of data.

"WITH NumberedMyTable AS ( SELECT ProductId, ProductName, ROW_NUMBER() OVER (ORDER BY ProductId) AS RowNumber FROM Products ) SELECT ProductId, ProductName FROM NumberedMyTable WHERE RowNumber BETWEEN " + fromRown + " AND " + toRowm,

Next, we will need to combine this data with the previously displayed data. To obtain the previously displayed data, we can invoke the GetCachedDataSource() method. This method returns the data source object that kept in cache.

Alternatively, you can try to use the classic paging mode. Hope this helps.

Pagingloadmode="VirtualLoadmode and Custom Virtual load mode

Skgrid@intersoftpt.com — Fri, 16 Aug 2013 05:46:20 GMT

Hi Yudi,

Please advice us with update on this incident.

Regards,

Madhavan

Pagingloadmode="VirtualLoadmode and Custom Virtual load mode

yudi — Sun, 23 Jun 2013 20:56:55 GMT

I haven’t heard any news from the team yet, but I will surely updates in the next couple of days.

Pagingloadmode="VirtualLoadmode and Custom Virtual load mode

Skgrid@intersoftpt.com — Thu, 20 Jun 2013 07:29:05 GMT

Hi Yudi,

Anything you heard from your developement team.

Regards,

Madhavan

Pagingloadmode="VirtualLoadmode and Custom Virtual load mode

yudi — Wed, 12 Jun 2013 05:43:07 GMT

In my opinion, it seems that you wish to use the custom virtual load paging but doesn’t want to use the “select top n rows from [tablename]” as the select query of WebGrid.

I have managed to create a simple sample of custom virtual load-enabled WebGrid where the select query is no longer use “select top n rows from [tablename]”. The select query is made based on the requirement specified in your post (on June 11, 2013).

However, I’m not lucky enough to have the expected result on WebGrid. The first time I click the button to load more data, instead of showing record (for example) 1 – 100, WebGrid shows data 51 – 100.

I will have this discussed with WebGrid development team to find out whether it is ok or not to set the WebGrid’s data source in such way when custom virtual load is enabled. I will get back to you as soon as I heard something from the team regarding this.

Pagingloadmode="VirtualLoadmode and Custom Virtual load mode

Skgrid@intersoftpt.com — Tue, 11 Jun 2013 08:42:54 GMT

Hi Yudi,

Is there any way we can acheive the following scenario?

Say we have 50000 type of records.

Say our paging size is 50.

1.First on load webgrid should load 50 records.(Database call should be for retrieving 50 records).

2.On click of next Webgrid should load 50-100 records.(Database call should be for retrieving 50 records).

3.On click of next Webgrid should load 100-150 records.(Database call should be for

retrieving 50 records).

Please advice us achieving the above mentioned scenario will benefit us heavily.

Thanks in advance,

Regards,

Madhavan

Pagingloadmode="VirtualLoadmode and Custom Virtual load mode

yudi — Mon, 03 Jun 2013 22:10:40 GMT

WebGrid allows you to create efficient multiple rows selection grid interface quickly using WebGridColumn’s IsRowChecker property. In order to obtain the checked rows can be done via server side or client side.

In the provided snippet code, GetCheckedRows() method is used. This method returns the checked rows for the WebGridTable. The return value of this method is object of HTML RowElement Collection.

On the custom mode of virtual load, developers need to specify the data fetching logic. Sorting, editing, and all-other data aware functionalities can work in this mode. However, checking all rows (by checking the IsRowChecker column header) requires all rows to be loaded.

Hope this helps.

Pagingloadmode="VirtualLoadmode and Custom Virtual load mode

Skgrid@intersoftpt.com — Mon, 03 Jun 2013 04:43:29 GMT

Hi Yudi,

One more point to add We have multi select functionality.

We have option to select items across multiple pages and perform the operation based on the selected check box and other column values for the selected row,

SO how this will work in custom virtual mode.

Regards,

Madhavan

for (int j = 0; j < rowsCount; j++)
                    {
                        if (WebGrid1.RootTable.Rows[j] != null)
                        {
                            if (WebGrid1.RootTable.Rows[j].Type == RowType.Record)
                            {
                                if (WebGrid1.RootTable.Rows[j].KeyValue.ToString() == WebGrid1.RootTable.GetCheckedRows()[i].ToString())
                                {
                                    string workflow = WebGrid1.RootTable.Rows[j].Cells.GetNamedItem("Workflow").Text;
                                    Guid WorkitemId = new Guid(WebGrid1.RootTable.GetCheckedRows()[i].ToString());
                                    Skelta.HWS.WorkItem workitem = new Skelta.HWS.WorkItem(new Skelta.Core.WorkflowObject(workflow, new Skelta.Core.ApplicationObject(_ApplicationName)), WorkitemId);
                                    if (multiSelectQueueId == Guid.Empty)
                                    {
                                        if (workitem.QueueId != Guid.Empty)
                                        {
                                            multiSelectQueueId = workitem.QueueId;
                                        }
                                    }
                                    workitemObj.Add(workitem);
                                }
                                else
                                {
                                    continue;
                                }
                            }

Pagingloadmode="VirtualLoadmode and Custom Virtual load mode

yudi — Thu, 30 May 2013 05:13:14 GMT

Thank you for your feedback.

I made a minor modification to the sample – which is enclosed on my previous post (May 27, 2013) – and run it in browser. VirtualPageSize property is set to “10”. Initially, the select command of OleDbDataAdapter will select top 10 of Order Details. Next, when user loads more data, it will select top 20 of Order Details and so on.

WebGrid has a mechanism to handle its custom virtual load paging.

Please try to open Developer Tools of your IE browser and enable the network traffic capturing. It will show you the XML which is returned from the server. The XML contains information of rows when user loads more data.

Initially, the XML will returns with 10 rows.

Next, when user loads more data, instead of returning XML with 20 rows, the XML will contains 10 rows (the information of rows #11 to #20) and so on.

Each POST takes only one hundred something millisecond (less than one second).

Hope this helps.

Pagingloadmode="VirtualLoadmode and Custom Virtual load mode

Skgrid@intersoftpt.com — Wed, 22 May 2013 08:12:36 GMT

Hi All,

We are trying to use Custom VirtualLoadMode for the webgrid as we are having performance issues

with large number of records like 20000.

We are using initialize data source event for binding data to the webgrid.

we have to use our api for populating datatable.Can you please provide us an sample for implementing custom virtualloadmode and Pagingloadmode="VirtualLoadmode".all the existing samples are using adapters. we wnat sample with plain APis.

void WebGrid1_InitializeDataSource(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
    {
        DataTable itemsDataTable = null;
        itemsDataTable = _ListItems.GetRecords(); //Api for getting datatable
        e.DataSource = itemsDataTable;
    }

Regards.

Madhavan