SortCompare of DataGridView - how to?

Chris Botha

VS2005 and I have a DataTable displayed in a DataGridView that needs custom
sorting, with the DataSource of the grid set to the DataTable and the
SortCompare event just won't fire.

Then I found this in the docs "This event occurs only when the DataSource
property is not set and the VirtualMode property value is false"
This seems really odd but may be true. I can't see what the purpose of this
event is then, how else will one use the DataGridView other than setting the
DataSource to something?

How else to do the custom sorting when the user clicks a column header is
also welcome.

Thanks.

May 22 '06 #1

Subscribe Post Reply

4587

Ken Tucker [MVP]

Chris,

It fires when the datagridview is not bound to a datasource and
virtual mode is set to false.

Ken
-----------------------

"Chris Botha" wrote:

VS2005 and I have a DataTable displayed in a DataGridView that needs custom
sorting, with the DataSource of the grid set to the DataTable and the
SortCompare event just won't fire.

Then I found this in the docs "This event occurs only when the DataSource
property is not set and the VirtualMode property value is false"
This seems really odd but may be true. I can't see what the purpose of this
event is then, how else will one use the DataGridView other than setting the
DataSource to something?

How else to do the custom sorting when the user clicks a column header is
also welcome.

Thanks.

May 22 '06 #2

Chris Botha

Hi Ken, thanks for the quick response. If you have it working, then I need
more assistance please. I've seen it in the docs, but what the heck does "is
not bound to a datasource" mean?
In my case I have a typed DataSet dataset obtained with a Web service call,
and sets the DataSource of the grid to be the DataTable in the dataset. Does
this cause the event not to fire? As mentioned, this seems really odd. Is
there another way of displaying the table in the grid other than setting the
datasource to the table so the event will fire?
I've tried the VirtualMode property in both its flavors and read all 3 pages
of links coming back with Google searching for DataGridView SortCompare.
"Ken Tucker [MVP]" <Ke**********@discussions.microsoft.com> wrote in message
news:E3**********************************@microsof t.com...

Chris,

It fires when the datagridview is not bound to a datasource and
virtual mode is set to false.

Ken
-----------------------

"Chris Botha" wrote:
VS2005 and I have a DataTable displayed in a DataGridView that needs
custom
sorting, with the DataSource of the grid set to the DataTable and the
SortCompare event just won't fire.

Then I found this in the docs "This event occurs only when the
DataSource
property is not set and the VirtualMode property value is false"
This seems really odd but may be true. I can't see what the purpose of
this
event is then, how else will one use the DataGridView other than setting
the
DataSource to something?

How else to do the custom sorting when the user clicks a column header is
also welcome.

Thanks.

May 22 '06 #3

Ken Tucker [MVP]

Hi,

Not bound to a datasource means that you add the columns and
cell values manually.

Here is a link to an example.
http://www.onteorasoftware.com/blog.aspx?BlogID=2

Ken
------------------------------
"Chris Botha" wrote:

Hi Ken, thanks for the quick response. If you have it working, then I need
more assistance please. I've seen it in the docs, but what the heck does "is
not bound to a datasource" mean?
In my case I have a typed DataSet dataset obtained with a Web service call,
and sets the DataSource of the grid to be the DataTable in the dataset. Does
this cause the event not to fire? As mentioned, this seems really odd. Is
there another way of displaying the table in the grid other than setting the
datasource to the table so the event will fire?
I've tried the VirtualMode property in both its flavors and read all 3 pages
of links coming back with Google searching for DataGridView SortCompare.
"Ken Tucker [MVP]" <Ke**********@discussions.microsoft.com> wrote in message
news:E3**********************************@microsof t.com...
Chris,

It fires when the datagridview is not bound to a datasource and
virtual mode is set to false.

Ken
-----------------------

"Chris Botha" wrote:
VS2005 and I have a DataTable displayed in a DataGridView that needs
custom
sorting, with the DataSource of the grid set to the DataTable and the
SortCompare event just won't fire.

Then I found this in the docs "This event occurs only when the
DataSource
property is not set and the VirtualMode property value is false"
This seems really odd but may be true. I can't see what the purpose of
this
event is then, how else will one use the DataGridView other than setting
the
DataSource to something?

How else to do the custom sorting when the user clicks a column header is
also welcome.

Thanks.

May 22 '06 #4

Chris Botha

Ken, thanks again, seems like the link does not work though?

"Ken Tucker [MVP]" <Ke**********@discussions.microsoft.com> wrote in message
news:F4**********************************@microsof t.com...

Hi,

Not bound to a datasource means that you add the columns and
cell values manually.

Here is a link to an example.
http://www.onteorasoftware.com/blog.aspx?BlogID=2

Ken
------------------------------
"Chris Botha" wrote:
Hi Ken, thanks for the quick response. If you have it working, then I
need
more assistance please. I've seen it in the docs, but what the heck does
"is
not bound to a datasource" mean?
In my case I have a typed DataSet dataset obtained with a Web service
call,
and sets the DataSource of the grid to be the DataTable in the dataset.
Does
this cause the event not to fire? As mentioned, this seems really odd. Is
there another way of displaying the table in the grid other than setting
the
datasource to the table so the event will fire?
I've tried the VirtualMode property in both its flavors and read all 3
pages
of links coming back with Google searching for DataGridView SortCompare.
"Ken Tucker [MVP]" <Ke**********@discussions.microsoft.com> wrote in
message
news:E3**********************************@microsof t.com...
> Chris,
>
> It fires when the datagridview is not bound to a datasource and
> virtual mode is set to false.
>
> Ken
> -----------------------
>
> "Chris Botha" wrote:
>
>> VS2005 and I have a DataTable displayed in a DataGridView that needs
>> custom
>> sorting, with the DataSource of the grid set to the DataTable and the
>> SortCompare event just won't fire.
>>
>> Then I found this in the docs "This event occurs only when the
>> DataSource
>> property is not set and the VirtualMode property value is false"
>> This seems really odd but may be true. I can't see what the purpose of
>> this
>> event is then, how else will one use the DataGridView other than
>> setting
>> the
>> DataSource to something?
>>
>> How else to do the custom sorting when the user clicks a column header
>> is
>> also welcome.
>>
>> Thanks.
>>
>>
>>

May 22 '06 #5

by: DraguVaso | last post by:

Hi, I'm using the DataGridView in VB.NET 2.0. The DataSource is a Generic List of a custom class0: lstMyPersonnes = New List(Of clsPersonne). When I add a new clsPersonne to lstMyPersonnes,...

.NET Framework

save DataGridView to Xml

by: Henok Girma | last post by:

Hello Gurus, I want to save the state of an unbound DataGridView on my Windows Form application to an XML file so i can later load it back.. Basically, on my form I have a DataGridView, it's got...

C# / C Sharp

retrieve rows from datagridview into a separate datatable?

by: Rich | last post by:

Hello, I am populating a datagridview from a datatable and filtering the number of rows with a dataview object. Is there a way to retrieve the rows displayed by the datagridview into a separate...