For current versions
Reading data from a DataTable is supported by ReoGrid core. You can set a DataTable at any position on the spreadsheet:
var adapter = new DataSet1TableAdapters.MyTableAdapter();
var dt = adapter.GetData();
worksheet["A1"] = dt;
For earlier versions
In earlier versions, ReoGrid could not read data from a DataTable directly. It was necessary to copy data into cells one by one:
// get a DataTable from database
var adapter = new DataSet1TableAdapters.MyTableAdapter();
var dt = adapter.GetData();
// iterate to copy all cells
for (int row = 0; row < dt.Rows.Count; row++)
{
for (int col = 0; col < dt.Columns.Count; col++)
{
grid[row, col] = dt.Rows[row][col];
}
}