title: Inserting data, Update if "ID" exists already
body: <p>I'm using table adapters to insert data into my database:</p>
  
  <pre><code>JUTDMSTableAdapters.textBooksTableAdapter bookTableAdapter;
  bookTableAdapter = new JUTDMSTableAdapters.textBooksTableAdapter();
  JUTDMSTableAdapters.CourseTableAdapter courseTableAdapter;
  courseTableAdapter = new JUTDMSTableAdapters.CourseTableAdapter();
  courseTableAdapter.Insert( CourseID: txtCourseID.Text, CourseTitle: txtCourseTitle.Text);
  bookTableAdapter.Insert( thirteenISBN: txt13ISBN.Text, CourseID: txtCourseID.Text, BookTitle: txtBookTitle.Text, Ancillary: txtAncillary.Text,
  BookActive: txtBookActive.Text, ActiveDate: txtActiveDate.Text, InactiveDate: txtInactiveDate.Text, Author: txtAuthor.Text,
              Imprint: txtImprint.Text, Publisher: txtPublisher.Text, EditionAndDate: txtEditionDate.Text,
  VendorISBN: vendISBN, tenISBN: txt10ISBN.Text, ebookAvailable: txtEBookAvailable.Text, eISBN: txtEISBN.Text, Notes: txtNotes.Text);
  </code></pre>
  
  <p>When I insert a new text book I enter in the "CourseID" and it adds the record to the parent table "Course" My problem is that every time I add a new text book, if the courseID already exists it still adds a new record to the parent "Course" table. I need to UPDATE the current database if the CourseID exists and ADD if it doesnt, but I havent seen anything like this regarding table adapters. </p>