DATASET and grouping

[trimakassi]

is there a code line to "group by" or "sort by" a Dataset that has been imported from a access database. I don't want to group the data while importing. I just want to perform sorting and grouping within a dataset after having imported the raw data

My second question is can we use one adapter to control two tables, in other words one oleadapter with two datasets.

 

[stsuing]

Sorting is a peice of cake using the DataView
_ds As DataSet
_ds.Tables(0).DefaultView.Sort = "Column1 asc"

Grouping is a pain. Here are two other discussions. I eventually wrote a loop to do it.

http://www.tek-tips.com/viewthread.cfm?qid=686103

http://www.tek-tips.com/viewthread.cfm?qid=346471&page=1

I do not think an adaptor cares what dataset it is using as long as the commands match the tables.