Radgrid Not Sorting

[Mark]

Hi All,

I have C# code-behind RadGrid that uses SQLDataSource and Databinds in NeedDataSource();

I have set

radGrid.AllowSorting = true;
radGrid.MasterTableView.AllowMultiColumnSorting = true;
radGrid.MasterTableView.AllowNaturalSort = true;

I have also set AllowSorting= true; on the columns themselves, but nothing seems to work.  The columns refuse to sort, even though I can see the Arrow Up, Arrow Down and revert to default.  Can you please help?

Thanks,
Mark

[Mark]

A couple more notes:

I set the RadGrid.DataSource = SQLDataSource when I generate the grid, and Ajax is disabled.

[Mark]

Huh, that's interesting . . .

If I set RadGrid.DataSourceID = SQLDataSource.ID the sorting works, but if I set RadGrid.DataSource = SQLDataSource it does not work. 

Why is that?

[Princy]

Hi Mark,

The DataSource- gets or sets objects from which the telerik radgrid control retrieves its list of data items, where as
DataSourceID- gets or sets the ID of the control from which the radgrid control retrieves its list of data items.
Using DataSource you can bind DataTable or Data Sets etc to the RadGrid and using DataSourceID, you can set the ID of the datasource controls like SqlDataSource, AccessDataSource, ObjectDataSource, EntityDataSource, LinqDataSource etc that you use.

C#:

RadGrid1.DataSourceID = "SqlDataSource1";
      //OR
RadGrid1.DataSource = GetDataTable("SELECT * FROM TableName");

Thanks,
Princy