Hmmm ... ok, that makes sense ... but lemme ask you ... what's the *point* of doing this? What's wrong with just using the DataAdapter.Fill() method?
>Create a datareader. As you read through the reader, create a record and populate each field. If you keep the names consistient, it is as easy as iterating through a collection.
>
>I suspect in the background, this is exactly what the fill method does.
>
>
>>John,
>>
>>We still use the DataAdapter to Fill DataSets ... I don't know any other way to do it. Do you have a better way?
>>
>>~~Bonnie
>>
>>
>>>I just finished a piece for Code Magazine on this. The thesis of the article deals with building a vb .net class that can best be described as a data-tier class that manages the creating of datasets and the retreval, updates, inserts, and deletes of data.
>>>
>>>IMO, the data adapter requires a lot of setup (table mappings, etc) that add alot of overhead. At this stage of the game, I have made the conclusion that they take away efficiency as opposed to enhancing efficiency. I may be wrong and if I am, I hope that somebody will correct me on this...
>>>
>>>>
>>>I dunno - all I've got is the "alpha" copy and I'm not sure it was even dealing with it. BTW - I heard that you were advocating "not using data adapters and/or command builder" recently? Is this accurate and if so, what is best approach you've found?
>>>>