Sorting Dataset

[parshupooja]

Hey All,

I have DataSet. I want to sort it. Can anyone help.

I tried Smthing looking for Sort method but Don't see it.
Thanks

[nateraaaa]

Hey All,

I have DataSet. I want to sort it. Can anyone help.

I tried Smthing looking for Sort method but Don't see it.
Thanks

You can't sort a dataset but you can sort using a dataview. Just create a new DataView with the dataset table and then used the Sort method to sort the dataview. See the link below on how to use the dataview.
http://www.knowdotnet.com/articles/dataviewsort.html

Nathan

[kunal pawar]

u can not sort dataset but u can sort dataview using sort command of dataview

[saran23]

Hey All,

I have DataSet. I want to sort it. Can anyone help.

I tried Smthing looking for Sort method but Don't see it.
Thanks

Hi pooja,

I think this might help u...

put the dataset into a datatable and then to a dataview.
In dataview u hav the sort property.

Dataset ds
Datatable dt=ds.Tables[0]
 DataView dv = new DataView(dt);
        dv.RowFilter = "ColumnName='" +Ur sort Value + "'";
        return dv;

Thanks
Saran

[parshupooja]

Hey,

Can I do something like this?

Dim dt As DataTable = MyDataSet.Tables(0)
Dim dv As DataView = New DataView(dt)
dv.RowFilter = ("start_dt")

I want to sort by date. I have coulmn start_dt. I tried this but it throws error.
I am using vb.net
Thanks,

Hi pooja,

I think this might help u...

put the dataset into a datatable and then to a dataview.
In dataview u hav the sort property.

Dataset ds
Datatable dt=ds.Tables[0]
 DataView dv = new DataView(dt);
        dv.RowFilter = "ColumnName='" +Ur sort Value + "'";
        return dv;

Thanks
Saran

[balabaster]

Hey,

Can I do something like this?

Dim dt As DataTable = MyDataSet.Tables(0)
Dim dv As DataView = New DataView(dt)
dv.RowFilter = ("start_dt")

I want to sort by date. I have coulmn start_dt. I tried this but it throws error.
I am using vb.net
Thanks,

That would be because RowFilter is exactly that - a filter consequently you would need to use dv.RowFilter = "start_dt = 'whatever is in start_dt'"

What you're looking for is dv.Sort

Dim dt As DataTable = MyDataSet.Tables(0)
Dim dv As DataView = New DataView(dt)
dv.Sort = "start_dt DESC"

You can substitute DESC for ASC if you wish to change the sort order, you can also use a comma to delimit - thus if you want to sort on multiple columns you can do that also:

dv.Sort = "<Column Name> [ASC|DESC]...[, Column n [ASC|DESC]"

Which basically translated =

dv.Sort = "Column1 ASC, Column2 DESC, Column3 DESC, Column4 ASC" etc etc.

Hope that helps