title: How do I insert Rows from my DATASET to my DATABASE without using command builder?
body: <p>I have a database with multiple tables each linked to the other.(Relational Database) 
  I want to Insert Records from my Dataset to Database.
  First I tried using OledbCommandBuilder but that didn't work, I found out it couldn't work with relational databases.
  I haven't linked tables within my dataset, they are linked only in the database.
  What I have is a button named "Commit". When I press that button I want all the modifications in my dataset.datatable to be reflected in the respective database table. 
  I only know how to INSERT, UPDATE, DELETE a single record at a time but that also is a lengthy task as first I have to do this.</p>
  
  <p>CODE IN THE SAVE BUTTON</p>
  
  <pre><code>             DataRow dRow = bookDS.Tables["Book"].NewRow();
  
                 dRow[0] = Convert.ToInt64(textBookID.Text);
                 dRow[1] = textBookName.Text;
                 dRow[2] = textISBN.Text;
  </code></pre>
  
  <p>and so on (there are 30 columns)</p>
  
  <pre><code>              bookDS.Tables["Book"].Rows.Add(dRow);
  </code></pre>
  
  <p>Then</p>
  
  <p>CODE IN THE COMMIT BUTTON</p>
  
  <p>con.Open();</p>
  
  <pre><code>                    string sql = "Insert INTO Book Values (@BookId, @BookName, @ISBNNo, @PublicationId, @CategoryId, @Pages,@Price,@Author1,@Author2,@TotalCopies,@IssuedCopies,@AvailableCopies,@SupplierName,@Note)";
  
                      OleDbCommand save = new OleDbCommand(sql);
  
                      save.Parameters.Add("@BookId", OleDbType.BigInt).Value = Convert.ToInt64(dRow[0]);
                      save.Parameters.Add("@BookName", OleDbType.BSTR).Value = dRow[1];
                      save.Parameters.Add("@ISBNNo", OleDbType.BSTR).Value = dRow[2];
  </code></pre>
  
  <p>and so on...</p>
  
  <p>save.Connection = con;
                          save.ExecuteNonQuery();</p>
  
  <pre><code>                    con.Close();
  </code></pre>
  
  <p>That is all i can think of but that only works for a single Row and so I its like I have to press the COMMIT button every time I press the SAVE button. </p>
  
  <p>Can anyone please help me with this ???</p>
  
  <p>P.S : I am using MSAccess and also don't want to use TABLEADAPTER ( I want to do everything  with my code )</p>