Link Details

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.