Comments on C# Bits: Setting the Initial Sort Order – Dynamic Data

Glad you like it Jim Steve

2012-01-20T18:51:33.652Z

Glad you like it Jim

Steve

Hi Steve, I don't know how I found this post ...

2012-01-20T18:38:43.769Z

Hi Steve,

I don't know how I found this post but it was a great help, and also got me to learn about extension methods.

Thanks again and I'm bookmarking your site.

Thanks,

Jim

Hi Jonathan, I don;t do it that way anymore with ....

2011-08-03T18:48:22.602+01:00

Hi Jonathan, I don;t do it that way anymore with .Net 4. I do it liek this, much more relyable.

// set default sort
if (table.SortColumn != null)
{
var order = new OrderByExpression()
{
DataField = table.SortColumn.Name,
Direction = table.SortDescending ? SortDirection.Descending : SortDirection.Ascending,
};
queryExtender.Expressions.Add(order);
}

To expand on Stuart Whiteford's code example, ...

2011-08-03T18:09:15.091+01:00

To expand on Stuart Whiteford's code example, the order by syntax when working with an EntityDataSource is slightly different:

string orderBy = String.Format("it.{0} {1}", displayColumn.SortColumn, displayColumn.SortDescending ? "desc" : "asc");
GridDataSource.OrderBy = orderBy;

Also, excluding this sorting code from post backs (as fabiocanada pointed out) allows for re-sorting by the user, but after a delete, for example, the default sort order is lost. The user can then re-sort using the column headers but it's not a good user experience , especially when there are several pages of data.

Glad it does Yuri :) Steve

2011-03-26T01:07:38.022Z

Glad it does Yuri :)

Steve

Hi Steve, QueryExtender works fine to me. Thank ...

2011-03-25T16:59:23.863Z

Hi Steve,

QueryExtender works fine to me.

Thank you

Hi Yuri, you can just apply multiple column name t...

2011-03-24T19:16:33.246Z

Hi Yuri, you can just apply multiple column name to the GridView sort, also if you are using VS2010 and .Net 4 then you can add a sort to QueryExtender that should give you the control.

Steve

Hi Steve, Nice tip, but I have a problem. I nee...

2011-03-24T18:31:16.231Z

Hi Steve,

Nice tip, but I have a problem. I need to do sort using 2 fields. I try to put other "DisplayColumn". Do you know, how I can do that ?

Thanks

Good point fabiocanada :) Steve

2010-11-22T17:04:13.006Z

Good point fabiocanada :)

Steve

The code works! But it's better top use it onl...

2010-11-22T16:51:42.492Z

The code works! But it's better top use it only when the page is not a post back. I was able to delete and re-order.

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var displayColumn = table.Attributes.OfType().FirstOrDefault();
if (displayColumn != null && displayColumn.SortColumn != null)
{
GridView1.Sort(displayColumn.SortColumn,
displayColumn.SortDescending ? SortDirection.Descending : SortDirection.Ascending);
}
}
}

Thanks fabriciofuji :) Steve

2010-04-27T16:57:14.177+01:00

Thanks fabriciofuji :)

Steve

Worked perfectly! Thanks.

2010-04-27T16:24:40.251+01:00

Worked perfectly! Thanks.

Thanks again for this - solved my problem!

2010-02-10T11:18:28.296Z

Thanks again for this - solved my problem!

Hi Stuart, thanks for that, I'll do an update ...

2009-11-16T09:47:59.707Z

Hi Stuart, thanks for that, I'll do an update and cite you for that snippet, do you have a blog or website I can point to in the citation?

Steve :D

not much help for a newbie...

2009-11-16T08:21:32.945Z

not much help for a newbie...

Steve, Instead of sorting on the GridView, I set ...

2009-07-20T20:59:16.241+01:00

Steve,

Instead of sorting on the GridView, I set the OrderBy property of the underlying LinqDataSource in The Page_Load method and that seems to resolve the deleting and paging issues.

[code]
string orderBy = string.Format("{0} {1}", displayColumn.SortColumn, displayColumn.SortDescending ? "descending" : "ascending");
GridDataSource.OrderBy = orderBy;
[/code]

Yep, deletes don't work for me too. Also notic...

2009-07-20T20:04:43.879+01:00

Yep, deletes don't work for me too. Also noticed that I can only navigate up to page 2 with the GridViewPager.

I'll give that a test and get back to you on t...

2009-06-16T12:01:55.059+01:00

I'll give that a test and get back to you on this, I think only tested this with DD.

Steve :D

Using this method, deletes don't work anymore....

2009-06-16T10:48:44.190+01:00

Using this method, deletes don't work anymore...