test for FormatTypes in DatasetTable.PopulateTable

```
We should analyse the second row to find the correct type and use that type
for the DataColumn.. Currently i only changed to add the DateTimeValue
instead of the Value.

for (int currentRowIndex = 1; currentRowIndex <= Cells.LastRowIndex;
currentRowIndex++)
{
DataRow dr = dt.NewRow();
object value = null;
for (int currentColumnIndex = 0; currentColumnIndex <=
Cells.LastColIndex; currentColumnIndex++) {
if (Cells[currentRowIndex, currentColumnIndex].IsEmpty)
dr[currentColumnIndex] = Cells[currentRowIndex,
currentColumnIndex];
else {
switch (Cells[currentRowIndex,
currentColumnIndex].Format.FormatType)
{
case CellFormatType.Date:
case CellFormatType.Time:
case CellFormatType.DateTime:
value = Cells[currentRowIndex,
currentColumnIndex].DateTimeValue;
break;
default:
value = Cells[currentRowIndex,
currentColumnIndex].Value;
break;
}
dr[currentColumnIndex] = value;
}
}
dt.Rows.Add(dr);
}
```

Original issue reported on code.google.com by `marco.di...@gmail.com` on 11 Feb 2009 at 10:01

Start at DatasetTable.PopulateTable and trace how DataColumns are created from row values and FormatTypes are handled. Add a regression test covering a second-row date, time, or datetime value, then run the existing test suite; done means the column type and stored value match the detected format.

Written by the indexing model from the issue text.