Intersoft Community - WebGrid Enterprise - WebGrid bind to ObjectDataSource problem with customPagging and filtering

WebGrid bind to ObjectDataSource problem with customPagging and filtering

yudi — Tue, 09 Aug 2011 21:18:54 GMT

Glad to hear that the trick helps.

Should you need further assistance or run into any problems regarding our controls, feel free to post it into our forum. We would be happy to assist you again.

WebGrid bind to ObjectDataSource problem with customPagging and filtering

mpodbielski — Tue, 09 Aug 2011 16:42:41 GMT

I do that. thanks

WebGrid bind to ObjectDataSource problem with customPagging and filtering

yudi — Mon, 08 Aug 2011 00:54:35 GMT

There are three general types of client data source:

Server-side data source.
Service-based data source.
ClientBinding™ includes three built-in data providers implementation for data service, which are Web Service, WCF Service and ADO Data Service.
Client-side data source.

The exporting functionality needs to be processed at server-side. By nature, only server-side data source type which produce export result without any issues.

However, there is a trick to have such feature work on the other two types of client data source (the service-based data source and client-side data source). In order to export the data when service-based data source or client-side data source is used, the BindingOperationMode should be modified back to “ServerBinding” temporarily.

We can utilize the OnBeforeRequest client-side event to modify the property only when the action is “Export”. Please try to add following code inside the OnBeforeRequest client-side event.

function WebGrid1_OnBeforeRequest(controlId, action) {
    var WebGrid1 = ISGetObject(controlId);
            
    if (action == "Export")
        WebGrid1.BindingOperationMode = "ServerBinding";    

    return true;
}

Add the data source on WebGrid’s InitializeDataSource server-side event.

protected void WebGrid1_InitializeDataSource(object sender, ISNet.WebUI.WebGrid.DataSourceEventArgs e)
{
    dsNorthwind.ProductsDataTable dt = new dsNorthwind.ProductsDataTable();
    dsNorthwindTableAdapters.ProductsTableAdapter da = new dsNorthwindTableAdapters.ProductsTableAdapter();
    da.Fill(dt);
    e.DataSource = dt;
}

Last, configure the BindingOperationMode property back to “ClientBinding”.

function WebGrid1_OnBeforeRequest(controlId, action) {
    var WebGrid1 = ISGetObject(controlId);
            
    if (action == "Export")
        WebGrid1.BindingOperationMode = "ServerBinding";
    else
        WebGrid1.BindingOperationMode = "ClientBinding";

    return true;
}

Hope this helps.

WebGrid bind to ObjectDataSource problem with customPagging and filtering

mpodbielski — Sun, 07 Aug 2011 18:49:13 GMT

Any news?

Best regards,

Michal

WebGrid bind to ObjectDataSource problem with customPagging and filtering

yudi — Tue, 26 Jul 2011 17:43:15 GMT

I was able to reproduce the problematic behavior on my local end. I will have this forwarded to WebGrid development team to be investigated further. Should I hear any news from the team regarding this issue, I will let you know as soon as possible.

WebGrid bind to ObjectDataSource problem with customPagging and filtering

mpodbielski — Mon, 25 Jul 2011 19:31:10 GMT

I use ClientBingdigMode with WebService and filtering and pagging works but when i try to export data to any format i've got JS error: "Invalid client service command"

dynamic js code

Best regards,

Michal

WebGrid bind to ObjectDataSource problem with customPagging and filtering

yudi — Thu, 21 Jul 2011 21:24:08 GMT

The PagedData mode of Data Loading Mode in WebGrid’s 7 ClientBinding scenario works for client-based data service.

WebGrid bind to ObjectDataSource problem with customPagging and filtering

mpodbielski — Wed, 20 Jul 2011 08:55:05 GMT

Could I use ClientBinding and PaggedData with ObjectDataSource ?

WebGrid bind to ObjectDataSource problem with customPagging and filtering

yudi — Wed, 20 Jul 2011 08:10:38 GMT

It seems that the Select method in custom paging scenario doesn’t accept FilterExpression parameter. That should explain why does the FilterExpression parameter is always null.

I suggest you to try PagedData mode of Data Loading Mode in WebGrid 7’s ClientBinding scenario. When data operation - such as sorting and filtering - is performed in PagedData mode, WebGrid will send a request to the specified data service by including complete request data in the selectArguments parameter. Developers are responsible to handle the sorting, filtering and paging based on the select arguments. In addition, WebGrid will also send a SelectCount request when it needs to invalidate the paging status.

ClientBinding encapsulates essential select arguments into an object called DataSourceSelectArguments. This object is always passed to the parameter of your Select method.

For more detail information, please check the “Data Loading Mode” topic in WebGrid’s documentation.

WebGrid bind to ObjectDataSource problem with customPagging and filtering

mpodbielski — Tue, 19 Jul 2011 19:30:59 GMT

Thanks for answer, the first issue is solved so I'm looking forward to hearing from you soon about the second one.

Best regards,

Michal

WebGrid bind to ObjectDataSource problem with customPagging and filtering

mpodbielski — Sun, 17 Jul 2011 08:48:06 GMT

Hello,

I bind WG to ObjectDataSource ,

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"  EnablePaging="true"
           MaximumRowsParameterName="maximumRows" SelectCountMethod="GetAllCount"
            SelectMethod="GetData" TypeName="ObjectDataSourceFilteringSample.DataItem">
            <SelectParameters>
                <asp:Parameter Name="FilterExpression" Type="String" />
                 </SelectParameters>
        </asp:ObjectDataSource>

Pagging works almost perfect but when I go to second page ( from first to second or from third to second it doesn't matter) rows in change don't change , number of page change, when I click RefreshData button all rows disappear. I check selectMethod it return correct rows, and in another function where is another pagging logic also second page doesn't show proper no matter of page size.

public List<Item> GetData(string FilterExpression, int startRowIndex, int maximumRows, string sortExpression)

Second problem is filtering with customPagging. Parameter FilterExpression is always null, I don't know how to pass what users type in web.

I attach a simple solutions with both issue.

Sample Code