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];
  }
}
Was this article helpful?