data binding radgrid using linq and a stored procedure

[Aviram]

Hi,

I have a RadGrid control which I want to bind to a linq data source which uses a stored procedure.
The data bind should happen in the code behind and not on the aspx page cause I use my own filter to search on grid results.
I would appreciate a code sample.

Thanks,
Aviram 

[Rosen]

Hello Aviram,

Generally speaking there should be no substantial difference between usage of store procedures, mapped to the DataContext or a Table<> to feed data to RadGrid control. For example:

protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
    //GetAllProducts is a store procedure mapped to the dataContext
    ((RadGrid)source).DataSource = _db.GetAllProducts();
}

Please refer to this online demo for a simple implementation of manual CRUD operation using RadGrid and LinqToSql.

Best wishes,
Rosen
the Telerik team