title: set column default value of data table when filed with mysqldataadapter
body: <p>this is my code right now:</p>
  
  <pre><code>private static MySqlConnection conn = null;
  private static MySqlDataAdapter AccountsDa = null;
  private static MySqlCommandBuilder AccountsCb = null;
  AccountsDa = new MySqlDataAdapter("SELECT * FROM accounts", conn);
  AccountsCb = new MySqlCommandBuilder(AccountsDa);
  Accounts = new DataTable();
  AccountsDa.Fill(Accounts);
  </code></pre>
  
  <p>I'm trying to figure out how to define the column default values without having to do it by hand
  if I do like this:</p>
  
  <pre><code>DataColumn col = new DataColumn();
  col.ColumnName = "id";
  col.AllowDBNull = false;
  col.DataType = System.Type.GetType("System.Int32");
  col.DefaultValue = 0;
  Accounts.Columns.Add(col);
  </code></pre>
  
  <p>for every colum it works fine but how do I have it automatically set the default values from the database when the table is filled. I'm hoping I don't have to define 30 columns by hand.</p>
  
  <p>I tried the Accountsda.FillSchema(Accounts, SchemaType.Source);
  which sets up the allow nulls and auto increments but not default values</p>
  
  <p>the problem arrises when adding a row to the data table later sometimes I only need to set the value for one column and let the rest of the columns resort to their default value.</p>
  
  <p>I could put 180 lines of code to manually define the default values for inserting rows but there has to be a way to grab that from the database when creating/filling the data table</p>
  
  <p>I'm using in memory data tables because there are times where data will only exist for example 2 minutes and then be deleted again as this is for a dedicated server for an online rts game. so to save hits on the database I'm using data tables and manipulating them and flushing them every 10 minutes so that I only have 1,000 hits to the database every 10 mins instead of possibly 40,000 hits</p>