title: Adding New Row Data from C1FlexGrid to Access 97 .mdb Database C#
body: <p>As a quick background, I'm a beginner at database programming so forgive me if anything that I post here doesn't make sense or is outright dumb.</p>
  
  <p>I'm trying to make a WinForm application that will allow users to connect to a .mdb Access 97 database of their choosing, allow the user to make changes (e.g. add new data rows on WinForm which will then be applied to the original .mdb database), and sync those changes across different .mdb Access 97 databases if desired.</p>
  
  <p>To give you an idea of what I have so far. I have successfully connected to a .mdb Access 97 database using C# and I output the database table contents into a <code>DataSet</code> object from which I then dumped into a <code>C1FlexGrid</code> (code will follow momentarily). Now before anyone mentions anything, I cannot upgrade the database file to a newer version, so it has to stay as an Access 97 version file.</p>
  
  <p>Here is the code I used to connect:</p>
  
  <pre><code>dbConnection  = new OleDbConnection(@"Provider=Microsoft.JET.OLEDB.4.0;Data Source=" + path);
  dbCommand     = new OleDbCommand("SELECT * from MAIN", dbConnection);
  dbDataAdapter = new OleDbDataAdapter(dbCommand);
  
  dbDataSet = new DataSet("MasterLanguageDB");
  dbConnection.Open();
  dbConnectionIsOpen = true;
  
  // connection is successful, unlock connected mode features
  EnterDatabaseConnectedMode();
  
  dbDataAdapter.Fill(dbDataSet);
  flexGrid.DataSource = dbDataSet.Tables[0];
  </code></pre>
  
  <p>My question is this: is the C1FlexGrid that I now have populated with the .mdb database file contents "binded" to the .mdb file? Because 1, I didn't bind the datasource the way Microsoft suggests doing it by way of the Add Data Source wizard in Visual Studio 2008 (because the user can connect to any .mdb database they choose -- not just one) and 2, I want whatever changes I make to the C1FlexGrid to apply to the original database.</p>
  
  <p>If the answer is no, how do I create that "binding" or add the rows to the database?</p>