AngryHacker
AngryHacker

Reputation: 61616

How to sort a DataView in a case-insensitive manner?

I have a DataTable. I'd like to sort its default view by a column name 'city'. I'd like the sort to be case-insensitive.

Here is the code I have:

DataTable dt = GetDataFromSource();
dt.DefaultView.Sort = "city asc";

MyReport.DataSource = dt.DefaultView;

Thanks.

Upvotes: 2

Views: 3507

Answers (1)

AngryHacker
AngryHacker

Reputation: 61616

Never mind. It's in the documentation.

DataTable dt = GetDataFromSource();
dt.CaseSensitive = false;
dt.DefaultView.Sort = "city asc";

Upvotes: 4

Related Questions