Devart Forums

Code: Select all

/// 
/// Tables must be created before you call this function
/// 
/// if you have InnoDB table, set this parameter = false
void CopyDataSet(DataSet dataset, string connectionString, bool delayed) {

  MySqlConnection connection = new MySqlConnection(connectionString);
  connection.Open();

  MySqlLoader loader = new MySqlLoader();
  loader.Connection = connection;
  loader.Delayed = delayed;

  foreach (DataTable table in dataSet.Tables) {
    loader.TableName = table.TableName;
    loader.CreateColumns();
    loader.Open();

    foreach (DataRow row in table.Rows) {
      for (int i = 0; i < table.Columns.Count; ++i)
        loader.SetValue( i, row[i]);
      loader.NextRow();
    }
    loader.Close(); // flush table to database
  }
}