Grid / .NET 3.5 Client-side Data Binding

This example demonstrates declarative client-side data-binding of RadGrid for ASP.NET AJAX to WCF Web Service and ADO.NET Data Service. Both RadGrids have enabled paging/sorting/filtering.

The first RadGrid is bound to WCF Web Service. You need to point the control to an existing web service and method with following signiture:

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

[OperationContract]
public ResultData GetDataAndCount(int startRowIndex, int maximumRows, string sortExpression, string filterExpression)

where ResultData is custom class that holds data returned from the service to client:

public class ResultData
{
 public int Count { get; set; }
 public List<Product> Data { get; set; }
}

The second RadGrid is bound to ADO.NET Data Service. You need to point the control to an existing data service and set the following settings:

<ClientSettings>
  <DataBinding Location="GridAdoNetDataService.svc" SelectCountMethod="GetCount">
    <DataService TableName="Products" />
  </DataBinding>
</ClientSettings>

and GetCount method:

[WebGet]
public int GetCount(string where)
{
   return String.IsNullOrEmpty(where) ? CurrentDataSource.Products.Count() : CurrentDataSource.Products.Where(where).Count();
}

More information about how to bind the grid to these types of services you can gather from the relevant help article:
Client binding with WCF service/ADO.NET Data Services