I would really have to recommend you give datasets and datatables a try. Especially with the .net 2.0 stuff where you link your SQL statements into a tableadapter.

Datasets do have a large overhead, in terms of memory and speed. However a dataset is more logically similar to the data you have stored in a database.

Personally I nearly always use datasets. I would really recommend that you give them a go!