Hi all,

I'm having huge problems attempting to bind a radgrid to a WCF service using JSON using the built-in ClientSettings-DataBinding

The various code components:

I know the service is returning results, and I can output data using jquery, but the grid simple refuses to bind.
I've searched the forums and examples and can't find anything that will help me resolve this problem.

Any help would be appreciated
Cheers!

Anyone?  Help!

Hello Rich,

The experienced error (which could be observed thrown by the browser in the console) is "Origin is not allowed by Access-Control-Allow-Origin." which is caused from the fact that you do not have access to the requested service. Could you verify that if you place an jQuery ajax call on the page it will succeed?

Note that there are various topics around the internet you could search for on how to resolve the Access-Control-Allow-Origin error. Additionally, you could try setting the ResponseType to JSONP.

Regards,
Antonio Stoilkov
Telerik

Hi Antonio, thanks for your response!

I'm not getting any errors related to Origin as you describe.
The grid is making the call and data IS being returned (I can see this in fiddler).
Using a test ajax call also works and I can iterate through the results (as per the last lines in my original post).

Do you have any other suggestions I might try?

Cheers
Rich

Hello,

Based on your description it seems that the setup is correct and it is hard to pinpoint the problem. In such cases we recommend assembling a sample runnable project showing the unwanted behavior so we could debug it on our side and advice you with the best possible solution. You could open a formal ticket and upload the project or provide a URL from a public sharing provider where you have attached it.

Regards,
Antonio Stoilkov
Telerik

Hi

I'm am having similar problems. I think I have tracked it down to the different JSON formats returned from the different WCF calls. If I compare with the sample grid/examples/data-binding/client-side/declarative/defaultcs.aspx (which works)

            <ClientSettings >
                    <DataBinding SelectMethod="GetDataAndCount" Location="GridWcfService.svc" SortParameterType="Linq"
                    FilterParameterType="Linq"> 
 
                </DataBinding>

the response from the example GetDataAndCount WCF call contains the __type info

{"d":{"__type":"ResultData:#","Count":77,"Data":[{"__type":"Product:#","Discontinued":false,"ProductID":1,"ProductName":"Chai","ReorderLevel":10,"UnitPrice":18.00},{"__type":"Product:#","Discontinued":false,"ProductID":2,"ProductName":"Chang","ReorderLevel":25,"UnitPrice":19.00},{"__type":"Product:#","Discontinued":false,"ProductID":3,"ProductName":"Aniseed Syrup","ReorderLevel":25,"UnitPrice":10.00},{"__type":"Product:#","Discontinued":false,"ProductID":4,"ProductName":"Chef Anton's Cajun Seasoning","ReorderLevel":0,"UnitPrice":22.00},{"__type":"Product:#","Discontinued":true,"ProductID":5,"ProductName":"Chef Anton's Gumbo Mix","ReorderLevel":0,"UnitPrice":21.35}]}}

If I return from my WCF call (built using ASP.net 4.6) I get the following format which doesn't seem to want to bind as it doesn't contain the __type info

{"GetProductsResult":{"Count":1,"Data":[{"Discontinued":false,"ProductID":3,"ProductName":"tim","ReorderLevel":2,"UnitPrice":3}]}}

Is there a way of telling the grid bindings that it should accept this format?

The returns contains no errors, the headers look ok and the calls are  on the same domain

 

    [ServiceContract]
    public interface IExamMeister
    {

        [OperationContract]

        //[EnableCors(origins: "http://localhost", headers: "*", methods: "*")]

        [WebInvoke(Method = "POST", ResponseFormat = WebMessageFormat.Json, RequestFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped,
                    UriTemplate = "GetProducts")]
        PResultData GetProducts(int startRowIndex, int maximumRows, string sortExpression, string filterExpression);
        // TODO: Add your service operations here
    }

Hello,

The JSON format of the response of the WCF service can be configured through the attributes applied over the method:

You can leave the default values for these attributes (or remove them)  as shown in the example: grid/examples/data-binding/client-side/declarative/defaultcs.aspx and the response should look the same way as in the demo.
This client-side data binding uses the default WCF format of the response. If you require further customizations you can use client-side databinding with RadClientDataSource as shown here:
http://demos.telerik.com/aspnet-ajax/grid/examples/data-binding/client-side/client-data-source-binding/defaultcs.aspx

Regards,
Marin
Telerik by Progress