Hi,

I am adding a row to the datatable, and then I want to sort it, so I
put this into a dataview, and use the following code to sort it, but
it stays in the same order after I've done it.

datatable.rows.add(newrow)

dim dv as dataview

dv = datatable.DefaultView
dv.Sort = ("process_desc")

where process_desc is the name of the column to order, but it stays in
the same order. Any ideas why this is???

Hi Pewak,

DataView does not sort DataTable, it only represents the data in sorted
order.

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Pewak" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> I am adding a row to the datatable, and then I want to sort it, so I
> put this into a dataview, and use the following code to sort it, but
> it stays in the same order after I've done it.
>
> datatable.rows.add(newrow)
>
> dim dv as dataview
>
> dv = datatable.DefaultView
> dv.Sort = ("process_desc")
>
> where process_desc is the name of the column to order, but it stays in
> the same order. Any ideas why this is???

hi Miha ,

I have looked at the dataview after the sort on the column and it
appears in the same order. I intend to append this dataview into a new
dataset after the sort. Have you any suggestions how to do this ?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Pete,

I see no function for it, but what you can do is clone a dataset and than
while itterating thru your dataview add new rows for that new dataset and
than copy the items using the dataview to that new dataset also itterating
thru that.

It is not a real big job to do, I think about 10 rows of code in vb and 20
in C# (including {})

Cor

Hi Pete,

One solution was provided by Cor.
However, why would you want to copy sorted rows?

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

"Pete Walker" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hi Miha ,
>
> I have looked at the dataview after the sort on the column and it
> appears in the same order. I intend to append this dataview into a new
> dataset after the sort. Have you any suggestions how to do this ?
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Sorry, I didn't explain myself clearly, I have 3 seperate datasets that
have to be bound into one datagrid, because as far as I know you can't
bind multiple datasets to one datagrid, so I thought the best way was to
merge these 3 datasets into one like follows and then bind the merged
dataset into the datagrid. (hope this makes sense !!!)

1st Dataset
Overall Figure xxx yyy zzz

2nd Dataset (the bit I want in order)
A xxx yyy zzz
B xxx yyy zzz
C xxx yyy zzz
D xxx yyy zzz

3rd Dataset
Total Figure

This is where I wanted the 2nd dataset sorted


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

good news - you can get at the sorted dataview if you use the correct
syntax (credit goes to somebody else, i can't find the link right
now)

this syntax works, it returns the rows in sorted order:

dataview.sort "some column name"
for i = 0 to dataview.count - 1
dataview(i).item()

this syntax fails to return it in sorted order:

dataview.sort "some column name"
for i = 0 to dataview.table.rows.count - 1
dataview.table.row(i).item()

if you think this is silly, why not provide a dataset.sort method in
the first place, right?


Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com