On Tue, 17 Jul 2007 16:42:46 -0600, Paul <invalid@example.com> wrote:

>Jack Jackson wrote:
>> I have a DataGridView bound to a DataTable via a BindingSource object.
>>
>> Is there a way I can control how the sort comparisons are done when
>> columns in the DataGridView are clicked?
>>
>> I can't see where the sorting is done. My guess is in the default
>> DataView of the DataTable, but DataView doesn't seem to provide any
>> way to modify the sort comparisons.
>>
>> I have two reasons for wanting to change the default sorting. First
>> is the way punctuation is handled (characters like ' and - appear to
>> be ignored in the sorting, which I do not want), and second is to do
>> multi-column sorting.
> From help:
>
>private void dataGridView1_SortCompare(object sender,
> DataGridViewSortCompareEventArgs e)
>{
> // Try to sort based on the cells in the current column.
> e.SortResult = System.String.Compare(
> e.CellValue1.ToString(), e.CellValue2.ToString());
>
> // If the cells are equal, sort based on the ID column.
> if (e.SortResult == 0 && e.Column.Name != "ID")
> {
> e.SortResult = System.String.Compare(
> dataGridView1.Rows[e.RowIndex1].Cells["ID"].Value.ToString(),
> dataGridView1.Rows[e.RowIndex2].Cells["ID"].Value.ToString());
> }
> e.Handled = true;
>}

Jack Jackson wrote:
> I have a DataGridView bound to a DataTable via a BindingSource object.
>
> Is there a way I can control how the sort comparisons are done when
> columns in the DataGridView are clicked?
>
> I can't see where the sorting is done. My guess is in the default
> DataView of the DataTable, but DataView doesn't seem to provide any
> way to modify the sort comparisons.
>
> I have two reasons for wanting to change the default sorting. First
> is the way punctuation is handled (characters like ' and - appear to
> be ignored in the sorting, which I do not want), and second is to do
> multi-column sorting.

<marc.gravell@gmail.com> wrote:

>In addition to Paul's comment, for automatic support it all depends on
>the backing data-source.
>
>Note that DataGridView can perform single-column sorting using the
>IBindingList.ApplySort() method; so *if* you control the list, you
>could educate it how to sort correctly? By default, it doesn't support
>multi-column sorting, but I have a subclass of DataGridView that does
>this by using the IBindingListView.ApplySort() method on the backing
>data-source (if supported).
>I also have a subclass of BindingList<T> that implements this code
>simply by using the default compare on the data (via the
>PropertyDescriptors). I can post some limited code if needed...
>
>Marc
>

<jacknospam@pebbleridge.com> wrote:

>I have a DataGridView bound to a DataTable via a BindingSource object.
>
>Is there a way I can control how the sort comparisons are done when
>columns in the DataGridView are clicked?
>
>I can't see where the sorting is done. My guess is in the default
>DataView of the DataTable, but DataView doesn't seem to provide any
>way to modify the sort comparisons.
>
>I have two reasons for wanting to change the default sorting. First
>is the way punctuation is handled (characters like ' and - appear to
>be ignored in the sorting, which I do not want), and second is to do
>multi-column sorting.

<marc.gravell@gmail.com> wrote:

>I would *imagine* that it is using the default .NET string sort...

>which bits of code do you mean? I don't want to start ripping it all
>apart if you don't need it...
>
>the grid? the list?