turrican said:spivonious said:*snip*
Yes, I understand, ok I'll have to test with the collection and see how it goes.
On a sidenote, when doing "SELECT * FROM TABLE1 ; SELECT * FROM TABLE2" I can get two tables out. Is it possible to get those two in a DataSet somehow? ( bit offtopic question but I thought you might know it. )
I would do a join in the SQL then populate a single DataTable, it's more efficient.