Today I saw this blog post and I couldn't resist to test RadGridView for WPF using the same data :)

Looks like by default our grid will sort approximately 10 times faster - no need to build your own custom comparers.

Enjoy!

[Download]

I'm pleased to announce that the next version of RadGrid for ASP.NET AJAX will support natively EntityDataSource.
All operations like paging, sorting and filtering will be applied directly on the data-base server:

and of course you will able to insert, update and delete records completely codeless.

Enjoy!

[Download]

I've made small example how to perform paging, sorting and filtering directly on the data-base sever using LINQ to SQL and RadGridView for WPF.

The data-base is not included however you can use the same code with any data-base with following modifications:

- change the connection string in the app.config file

- change the table name in BindGrid() method:

    IQueryable queryable = new DataClasses1DataContext().[Your Table].AsQueryable();

- define desired total number of items per page and total page count

- change the filter expression in the filter button click event handler to desired (currently Contains for Name column)

Enjoy!

Download...

Every once in a while we receive support about how to create hierarchical grid directly from objects hierarchy and I decided to post small example how to achieve this easily:

  protected void RadGrid1_NeedDataSource(object source, GridNeedDataSourceEventArgs e)
  {
    RadGrid1.DataSource = MyList;
  }

  protected void RadGrid1_DetailTableDataBind(object source, GridDetailTableDataBindEventArgs e)
  {
    e.DetailTableView.DataSource = MyList.Find(
         delegate(Master master)
         {
           return master.ID == Convert.ToInt32(e.DetailTableView.ParentItem.GetDataKeyValue("ID"));
         }
       ).Details;
  }

  public List<Master> MyList
  {
    get
    {
        List<Master> items = new List<Master>();
        for (int i = 0; i < 5; i++) ...

I've made small example how to bind RadGrid for ASP.NET AJAX on the client to an RSS and ATOM feeds:

Enjoy!

Download

We just extended RadGrid for ASP.NET AJAX with native client-side data binding to ADO.NET DataServices. Now you can use getDataServiceQuery() method and the grid will construct ADO.NET DataService style query:

var northwindService = new Sys.Data.DataService("NorthwindDataService.svc");
var tableView = $find("<%= RadGrid1.ClientID %>").get_masterTableView();
northwindService.query(tableView.getDataServiceQuery("Customers"), updateGrid);

All operations like paging, sorting and filtering are automatically persisted using $top, $skip, $orderby and $filter parameters!

Download

I've made three demos on how to use RadGrid templates to build completely client-side edit and update:

- server-side GridTemplateColumn

- server-side GridTableView ItemTemplate

- client-side GridTableView ItemTemplate (ASP.NET AJAX 4.0 style)

Enjoy!

Download

As I mentioned in one of my previous posts with RadGrid for ASP.NET AJAX Q2 2008 you can access the grid sort and filter expressions on the client.

While filter expressions toString() method will create SQL syntax representing current grid filtering now you have toDynamicLinq() method which will create LINQ expression that can be used directly with Dynamic LINQ library.

With few lines of code you will get minimum transfer between server and client (pure JSON):

and on the server side LINQ to SQL will apply all requested operations directly on the data-base server:

Live Demo | Download

Ever wonder how to make a pageable & sortable grid Section 508 compliant? Well with RadGrid this is trivial task! The tricky part is to tell the grid to not render or require any JavaScript on the page:

1. Inherit from RadGrid and override three methods:

    public class MyGrid : RadGrid
    {
        public MyGrid()
        {
            //
        }

        protected override void RegisterScriptControl()
        {
            // do not register as ScriptControl
        }

        protected override void RegisterScriptDescriptors()
        {
            // do not register script descriptors
        }

        protected override void RegisterCssReferences() ...

I've spent few minutes to create small control called RadPageStylist which will style all Telerik RadControls on desired page with desired Skin. The control is fairly simple - you have Skin property where you can set your skin and ApplySkin() method which can be executed for particular ASP.NET Control. The method is recursive and will locate all child ISkinableControls to set selected Skin.

Other possible approach is "Global skin setting for the entire web site/web application project" however in this case the skin registration is static.

Live Demo | Download