Resorting a dataset

[Guest]

How can I re-sort a dataset.?
The code below doesn't do anything
Dim drs() As DataRow
Dim ds1 As DataSet, tab As DataTable
Dim dr As DataRow, dr1 As DataRow
Dim i As Integer, l As Integer
ds.Tables(0).DefaultView.Sort = "District, storeid desc"
drs = ds.Tables(0).Select("District=District")
ds1 = ds.Clone
tab = ds1.Tables(0)
l = tab.Columns.Count - 1
For Each dr In drs
dr1 = tab.NewRow
For i = 0 To l
dr1.Item(i) = dr.ItemArray(i)
Next
tab.Rows.Add(dr1)
Next
Return ds1.Tables(0).Rows

 

[Guest]

Sorting the dataview (which is only a view of the data) does not physically
sort the table rows. To see the outcome of using sort on the dataview try to
databind your dataview to a datagrid, e.g.

ds.Tables(0).DefaultView.Sort = "District desc"
datagrid1.datasource=ds.Tables(0).DefaultView
datagrid1.databind ()

then try

ds.Tables(0).DefaultView.Sort = "storeid desc"
datagrid1.datasource=ds.Tables(0).DefaultView
datagrid1.databind ()

 

[Guest]

Also if you wanted to create another table whose rows are sorted according to
the sort in the DataView then you need to use the datarowviews of the
dataview (instead of the rows of the table), e.g.

Dim drv As DataRowView
For Each drv In ds.Tables(0).DefaultView
dr1 = tab.NewRow
For i = 0 To l
dr1.Item(i) = drv(i)
Next

tab.Rows.Add(dr1)
Next