virtual load custom -on-demand on webgrid 7

yudi — Fri, 27 Jan 2012 02:20:02 GMT

Custom VirtualLoad is one of VirtualLoad features which allow developer to setup a grid with their own implementation and logic for fetching the data. VirtualLoadwithCustomLoadonDemand.aspx sample file in WebGrid samples project can be used for reference. The sample demonstrates how to use custom load on demand to load more data in WebGrid. You need to specify following property.

WebGrid
PagingMode=”VirtualLoad”
VirtualLoadMode=”Custom”
ISDataSourceTable
EnablePaging=”True”
MaximumRowsParameterName=”maximumRows”
SelectCountMethod=”SelectCount”
StartRowIndexParameterName=”startRowIndex”

After create the dataset, write codes that handle virtual load and the total row count in App_Code. The codes, let’s say dsNorthwind.cs class, containing Select Method with three parameters: startRowIndex, MaximumRows, and sortExpression; and SelectCount Method with one parameter: sortExpression.

The exception says that ISDataSource is unable to find SelectCount method that has parameters: startRowIndex, MaximumRows, and sortExpression. Please try to set the SelectCountMethod property of ISDataSourceTable to “SelectCount” and set the SelectMethod property to “GetData”. Please refer to App_Code\dsNorthwind.cs file, in the attached sample, about how to define the GetData and SelectCount.

I created a simple and working web application as sample. Please have the sample evaluated on your end and let me know whether it helps or not.

virtual load custom -on-demand on webgrid 7

schau — Thu, 26 Jan 2012 11:12:52 GMT

I'm trying to achieve loading 150 records of 300 on my webgrid. I'm getting this error below. Please help!

ISDataSource 'ISDataSource1' Table [t_log_entry2] could not find a non-generic method 'SelectCount' that has parameters: startRowIndex, maximumRows, sortExpression.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: ISDataSource 'ISDataSource1' Table [t_log_entry2] could not find a non-generic method 'SelectCount' that has parameters: startRowIndex, maximumRows, sortExpression.

Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[InvalidOperationException: ISDataSource 'ISDataSource1' Table [t_log_entry2] could not find a non-generic method 'SelectCount' that has parameters: startRowIndex, maximumRows, sortExpression.]
   ISNet.WebUI.DataSource.ISDataSourceView.#oj(Type type, String methodName, IDictionary allParameters, DataSourceOperation operation) +1613
   ISNet.WebUI.DataSource.ISDataSourceView.#rj(IOrderedDictionary mergedParameters, DataSourceSelectArguments arguments, Boolean disposeInstance, Object& instance) +166
   ISNet.WebUI.DataSource.ISDataSourceView.ExecuteSelect(String selectMethod, DataSourceSelectArguments arguments) +2260
   ISNet.WebUI.DataSource.ISDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +83
   ISNet.WebUI.DataSource.ISDataSourceView.Select(DataSourceSelectArguments arguments) +23
   ISNet.WebUI.DataSource.ISDataSource.#pi(ISDataSourceTable table) +142
   ISNet.WebUI.DataSource.ISDataSource.#pi(String tableName) +50
   ISNet.WebUI.DataSource.ISDataSource.DoHierarchicalSelect(String tableName) +117
   ISNet.WebUI.DataSource.ISDataSource.DoSelect(Boolean retrieveHierarchical) +46
   ISNet.WebUI.WebGrid.WebGridDataSourceInfo.€Š() +148
   ISNet.WebUI.WebGrid.WebGridDataSourceInfo.PerformSelect() +78
   ISNet.WebUI.DataSourceInfo.DataBind() +41
   ISNet.WebUI.DataSourceInfo.EnsureDataBound() +46
   ISNet.WebUI.DataSourceInfo.set_RequiresDataBinding(Boolean value) +71
   ISNet.WebUI.WebGrid.WebGrid.‡(Boolean forceBind) +1956
   ISNet.WebUI.WebGrid.WebGrid. () +22
   ISNet.WebUI.WebGrid.WebGrid.OnInitializeDataSource(Object dataSource) +135
   ISNet.WebUI.WebGrid.WebGrid.OnLoad(EventArgs e) +183
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Control.LoadRecursive() +146
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

________________________________________
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.225

Intersoft Community - WebGrid Enterprise - virtual load custom -on-demand on webgrid 7

virtual load custom -on-demand on webgrid 7

virtual load custom -on-demand on webgrid 7