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...

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"));
        ...

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

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...

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...

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 |...

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
        }

       ...

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 | ...

Very often you need to use RadDatePicker inside a grid or list component and if you have lots of records the standard approach is not the best choice.

Example:
<telerik:RadGrid ID="RadGrid1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
  <MasterTableView>
    <Columns>
      <telerik:GridTemplateColumn HeaderText="OrderDate" SortExpression="OrderDate">
        <ItemTemplate>
          <telerik:RadDatePicker ID="RadDatePicker1" DbSelectedDate='<%# Eval("OrderDate") %>' runat="server" />
        </ItemTemplate>
      </telerik:GridTemplateColumn>
    </Columns>
  </MasterTableView>
</telerik:RadGrid>

In this case you will get new date picker component for...

How many times you get this in your ASP.NET AJAX 1.0 applications?

After several support tickets we manage to isolate this to very simple case - standard UpdatePanel and a Button writing in Session. How weird?

Here is the code:

<%@ Page Language="VB" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<script runat="server">
    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        Page.Session("test") = "test"
    End Sub
</script>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>...