Alternative to DataSet

[RP]

I have three columns in a Grid (Third-Party), which is populated
through code without using DB DataSource. The columns are: Date,
Amount and Type. At present I created a DataSet to fill the entire
records of the Grid to DataSet DataTable. I need to sort the records
on the basis of Date in the DataTable. To do that I used, DataView and
sorted it and than stored the sorted result in a new DataTable.

I want an alternative of this. Can three columns be stored and sorted
on a particular column if an ArrayList, Dictionary or something is
used?

Which is faster, a DataSet, ArrayList, HashTable or Dictionary?

[sloan]

A good alternative is Custom (Business) Objects and a CustomCollection.

http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!140.entry

Check there.

There is a .Sort method..and a customer comparer as well I think.


"RP" <rp*********@gmail.comwrote in message
news:75**********************************@e6g2000p rf.googlegroups.com...

>I have three columns in a Grid (Third-Party), which is populated
through code without using DB DataSource. The columns are: Date,
Amount and Type. At present I created a DataSet to fill the entire
records of the Grid to DataSet DataTable. I need to sort the records
on the basis of Date in the DataTable. To do that I used, DataView and
sorted it and than stored the sorted result in a new DataTable.

I want an alternative of this. Can three columns be stored and sorted
on a particular column if an ArrayList, Dictionary or something is
used?

Which is faster, a DataSet, ArrayList, HashTable or Dictionary?

[RobinS]

It's so easy to sort a dataset. If you use a bindingsource between your
control and the dataset, it will handle the sorting for you.

If you use customer business objects, you have to write your own sort
routines. THis is explained very well in Brian Noyes' Data Binding book.

Why do you not want to use a dataset? Any particular reason?

RobinS.
------------------------------
"RP" <rp*********@gmail.comwrote in message
news:75**********************************@e6g2000p rf.googlegroups.com...

>I have three columns in a Grid (Third-Party), which is populated
through code without using DB DataSource. The columns are: Date,
Amount and Type. At present I created a DataSet to fill the entire
records of the Grid to DataSet DataTable. I need to sort the records
on the basis of Date in the DataTable. To do that I used, DataView and
sorted it and than stored the sorted result in a new DataTable.

I want an alternative of this. Can three columns be stored and sorted
on a particular column if an ArrayList, Dictionary or something is
used?

Which is faster, a DataSet, ArrayList, HashTable or Dictionary?