Intersoft Community - WebGrid Enterprise - Get Filtered Rows of webgrid in server side

Get Filtered Rows of webgrid in server side

Glayaar — Mon, 23 Aug 2010 00:30:50 GMT

Based on my disucssion with the developer regarding this issue, for this scenario he suggest not to use the programmatic binding and GetCachedDataSource method. He suggest using binding the ObjectDataSource control ID to the WebGrid using the DataSourceID property.

In order to retrieve the filtered row count, you will need to use the RootTable rows count property if the grid is not using any paging. If the grid is using paging, you will need to retrieve the DataView rows count from one of the RootTable rows. Here is the snippet for the WebGrid with paging enabled:

int rowCount = 0;
if(WebGrid1.RootTable.Rows.Count > 0)
{
    rowCount = ((DataRowView)(WebGrid1.RootTable.Rows[0].DataRow)).DataView.Count;
}

Get Filtered Rows of webgrid in server side

Glayaar — Fri, 20 Aug 2010 04:54:25 GMT

Testing the code using ObjectDataSource I also encounter the same issue. I am still discussing this issue with the developer. Currently, as a workaround you will need to bind the individual column manually similar to client binding scenario.

Get Filtered Rows of webgrid in server side

babman — Thu, 19 Aug 2010 13:17:42 GMT

Glenn,

If I do that in the InitializeDataSource event handler, then I also have to add this to my PrepareDataBinding handler:

   If (Not IsPostBack) Then
            WebGrid1.RetrieveStructure()
   End If

Doing that, however, causes the following error (on the RetrieveStructure line):

[NullReferenceException: Object reference not set to an instance of an object.]
ISNet.WebUI.WebGrid.WebGrid.RetrieveStructure() +711

Brian

Get Filtered Rows of webgrid in server side

Glayaar — Tue, 17 Aug 2010 22:48:19 GMT

In order for the GetCachedDataSource to have a value, you will need to bind the data using InitializeDataSource server side event. Even if you are using ObjectDataSource, under such scenario, the GetCachedDataSource already returned the dataview object.

Here is the InitializeDataSource event handler:

protected void WebGrid1_InitializeDataSource(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
{
    e.DataSource = ObjectDataSource1.Select();
}

Get Filtered Rows of webgrid in server side

babman — Tue, 17 Aug 2010 16:24:05 GMT

What if we can't use a DataTable? We have a WebGrid that uses an objectdatasource to retrieve about 90000 records. GetCacheDataSource returns nothing, and our project must use an objectdatasource.

Is there any way to get the filtered rows, server-side?

Thanks!

Get Filtered Rows of webgrid in server side

vinsdeon — Thu, 18 Feb 2010 00:10:35 GMT

Thanks for the solution. It worked.

Get Filtered Rows of webgrid in server side

Glayaar — Mon, 15 Feb 2010 22:23:51 GMT

After filtering WebGrid, if the DataSource is DataTable, you will need to get the DataSource using GetCacheDataSource() method. This will return all the Row in the WebGrid. If you would like to retrieve the filtered row you will need to use the DataTable DefaultView property.

Here is the snippet:

((DataTable)[GridObject].GetCachedDataSource()).DefaultView

Get Filtered Rows of webgrid in server side

vinsdeon — Mon, 15 Feb 2010 01:16:39 GMT

I have a webgrid with 30k rows. After a filtering it reduces to 500 rows. Now from server i would like to get these datarows together in a table or get the filtered data in a dataset or whatever possible as a form of datasource. How is it possible?