how to sort a dataset

[auxcom]

I'm having a problem on sorting a dataset after I insert a new row and call the

 

AcceptChanges of the dataset.

 

I sort a dataset like this:

 

ds.Tables(0).DefaultView.Sort = SortField

 

But this will not work. The new record is still located at the end of the dataset. I see this when I populate a listview with the dataset.

 

I hope someone can help me. Thanks!

[Robby]

Do you bind the grid after you sort?

[auxcom]

Well, I dont use a datagrid. I just a listview and I think there is databinding w/ a listview.

[georgepatotk]

U could do it when u are performing query?

 

eg:

"SELECT fields FROM table ORDER BY chosenfield"

[Arch4ngel]

Maybe you could get the DefaultView and set the SortExpression.

 

It work for me all the time.

[Robby]

George, that's not an option, he is already using the Sort method of the defaultview.

 

Arch4ngel, he's already doing that.

 

Auxcom, it doesn't matter if it's a grid or listview, did you bind after you sorted?

[Arch4ngel]

Bang! 3 in 1 for Robby.

 

Last solution...

Did you bind ? :p

[auxcom]

I like to edit my reply at post #3:

I dont use a datagrid. I use a listview and I think there is no databinding w/ a listview.

 

Here is my code for filling my listview.

 

Private Function FillView() As Integer

Dim dr As DataRow

Dim lvi As ListViewItem

 

ds.Tables(0).DefaultView.Sort = "Username ASC"

 

lvw.Items.Clear()

For Each dr In ds.Tables(0).Rows

lvwUser.Items.Add(dr("Username"))

Next

End Function

[Nerseus]

Try something like this instead:

 

Dim dr As DataRowView
lvw.Items.Clear()

For Each dr In ds.Tables(0).DefaultView
   lvwUser.Items.Add(dr("Username"))
Next

[auxcom]

Thanks Nerseus!

 

It already work the way I want :-)

 

I just add this line of code before the looping

 

ds.Tables(0).DefaultView.Sort = "Username ASC"