DataGrid - Sorting Columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dennis - 22 Oct 2004 01:59 GMT

How do I sort a DataGrid Column in code without clicking on the column header?

Signature

Dennis in Houston

Reply to this Message

W.G. Ryan eMVP - 22 Oct 2004 02:16 GMT

Bind to a dataview and set it's Sort property to whatever field you want.

Signature

W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com

> How do I sort a DataGrid Column in code without clicking on the column header?

Reply to this Message

scorpion53061 - 22 Oct 2004 04:50 GMT

Sorry Bill I had not seen you post your answer yet.

> Bind to a dataview and set it's Sort property to whatever field you
> want.

Reply to this Message

Dennis - 22 Oct 2004 23:49 GMT

Thanks.

> Bind to a dataview and set it's Sort property to whatever field you want.
>
> > How do I sort a DataGrid Column in code without clicking on the column
> header?

Reply to this Message

scorpion53061 - 22 Oct 2004 02:22 GMT

You can use one line of code to create a dataview from the datatable.

Dim dv as DataView = WhateverDataTable.DefaultView

Now, bind the grid to the view instead of the table. All of your
current
functionality will still be in tact.

You can call Sort on any field in the dataview and sort it which will
cause
the grid to sort.You could offer this via a context menu for instance,
if
for some reason you didn't want to allow sorting based on the grid
headers.

http://www.knowdotnet.com/articles/dataviewsort.html

> How do I sort a DataGrid Column in code without clicking on the column
> header?

Reply to this Message

Dennis - 23 Oct 2004 01:03 GMT

Is there someother way such as sending a message to the DAtaGrid via WinProc
to sort a column? I don't see where the DataView works with DataSets.

> You can use one line of code to create a dataview from the datatable.
>
[quoted text clipped - 15 lines]
> > How do I sort a DataGrid Column in code without clicking on the column
> > header?

Reply to this Message

William LaMartin - 24 Oct 2004 17:57 GMT

Not tested, but how about something like this:

dim dv As New DataView
dv = ds.Tables(0).DefaultView 'where ds is the dataset in question
dv.Sort = "Order" 'where Order is the column name by which you want to sort
Me.DataGrid1.DataSource = dv
Me.DataGrid1.Refresh()

> Is there someother way such as sending a message to the DAtaGrid via
> WinProc
[quoted text clipped - 19 lines]
>> > How do I sort a DataGrid Column in code without clicking on the column
>> > header?

Reply to this Message

Martin - 26 Oct 2004 05:02 GMT

Talkin about dataview object. Recently I tried to edit some row like this
... dr(indexcolumn) (indexrow) = "... " .. it was applied to the dataset,
But it didn't update to the datasource when i call
DataAdapter.update(Dataset,"TableName") { this with assumtion that
commandbuilder had been generated }. And also a mistake when i tried to
delete row using dataview object. But it didn't show any error message when
i put the -update method- in try ... catch ... endtry ....
Felling frustated with dataview object .. i used datatable object to edit
and delete row. ... Did u guys have this kind of problems before ?

Martin

> Not tested, but how about something like this:
>
[quoted text clipped - 27 lines]
> >> > How do I sort a DataGrid Column in code without clicking on the column
> >> > header?

Reply to this Message

Frank - 26 Oct 2004 07:31 GMT

Yes I did. I added beginedit and endedit and the problems were gone. I
thought begin/endedit was optional but it looks like it is obliged.
Frank

> Talkin about dataview object. Recently I tried to edit some row like this
> ... dr(indexcolumn) (indexrow) = "... " .. it was applied to the dataset,
[quoted text clipped - 41 lines]
> column
> > >> > header?

Reply to this Message

DataGrid - Sorting Columns

Free Magazines