title: Inserting just a new record using DataSet (.net c# ado.net )
body: <p>I've a form containing more than 200 text boxes in .NET desktop application. I want to insert them into their respective 4 tables of Database. Now how should I go about it using Dataset &amp; DataAdapter to do this?</p>
  
  <p>I mean usually this will be the flow:</p>
  
  <ol>
  <li>Populate the DataSet using <code>DataAdapter.Fill(Dataset,"DataTable");</code></li>
  <li>manipuate the data of DataSet</li>
  <li><code>DataAdapter.Update(Dataset,"DataTable")</code> updates the content back to Database.</li>
  </ol>
  
  <p>Code:<a href="http://dev.mysql.com/doc/refman/5.1/en/connector-net-tutorials-intro.html#connector-net-tutorials-data-adapter" rel="nofollow noreferrer">http://dev.mysql.com/doc/refman/5.1/en/connector-net-tutorials-intro.html#connector-net-tutorials-data-adapter</a></p>
  
  <p>But here I just want to insert a new record in 3 different tables.</p>
  
  <p>I think the way is to</p>
  
  <ol>
  <li>Programmatically Create A dataset with 3 Datatables.</li>
  <li>Bind 200 Textboxes to respective columns of these Datatabes</li>
  <li><code>dataAdapter.Update(dataSet, dataTable.TableName);</code></li>
  </ol>
  
  <p>Am I right?</p>
  
  <p>How does <code>dataAdapter.Update(dataSet, dataTable.TableName);</code> work? Because, my each dataTable will have only one record. (the new record that is to be inserted. binded with those 200 TextBoxes of the form) where as the Table of the Database will have thousands of records.  If I do <code>dataAdapter.Update(dataSet, dataTable.TableName);</code> will it delete all the rest of the records and insert this one alone? </p>
  
  <p>I just want to insert a new record (without fetching other 1000s of records into my Dataset) into Database.Table using Dataset.</p>