Alternative to Dataset??

[angela]

Hello everyone

I have two select statements, one pulling out the articles and another
select pulling out the articleIDs and companyIDs.

I use these two select statements to populate two datatables in a
dataset and use the RowFilter to populate a datagrid.

What I would prefer to use is a datareader and populate two arraylists,
but doesn't that mean when I come to populate the datagrid I have to
loop round the second arraylist and compare articleIDs and chose the
relevant companyIDs?

Hope this makes sense

Thanks

Angela

 

[Joe Fallon]

1. The simplest thing to do is to make 1 SQL command to return all the
results as a single table.

2. Barring that, I use custom Business Object classes (which are filled by
datareaders) instead of datasets.
I use Rocky Lhotka's CSLA framework. Very nice.

http://www.lhotka.net/ArticleIndex.aspx?area=CSLA .NET