Quickly Copy Data Rows from DataReader to a DataTable
In many situations, it's wiser to use DataReader instead of a DataSet. However, DataReader is limited due to its inability to transform data rows into a suitable holder, like DataTable.
The usual workaround for this limitation is to loop through the DataRows from the DataReader and assign them to the DataTable. This can be a pain.
It's quick, easy and you get access to all the articles on DevX.
This registration/login is to allow you to read articles on devx.com. Already a member?
To become a member of DevX.com create your Member Profile by completing the form below. Membership is free!
If you have a hot tip and we publish it, we'll pay you. However, due to accounting overhead we no longer pay $10 for a single tip submission. You must accumulate 10 acceptable tips to receive payment. Be sure to include a clear explanation of what the technique does and why it's useful. If it includes code, limit it to 20 lines if possible. Submit your tip here.
