title: C# - Syntax error in INSERT INTO statement (An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll)
body: <pre><code>    System.Data.OleDb.OleDbCommandBuilder cb;   //command builder
      cb = new System.Data.OleDb.OleDbCommandBuilder(boosterbaseDa); //re-establish temporary connection 
  
      DataRow dRow = boosterbaseDs.Tables[drpCardSet.Text].NewRow();  //create new row in set
  
      dRow[0] = drpCardSet.Text + "-EN" + txtCardSetNo.Text; //grab the data
      dRow[1] = txtCardName.Text;
      dRow[2] = drpCardRarity.Text;
      dRow[3] = drpCardCatagory.Text;
      dRow[4] = updCardInStock.Value;
  
      MessageBox.Show(dRow[0] + ", " + dRow[1] + ", " + dRow[2] + ", " + dRow[3] + ", " + dRow[4]);
  
      boosterbaseDs.Tables[drpCardSet.Text].Rows.Add(dRow);   //add row
  
      boosterbaseMaxRows = boosterbaseMaxRows + 1;
  
      string cardTable = drpCardSet.Text;
  
      boosterbaseDa.Update(boosterbaseDs, drpCardSet.Text); 
  </code></pre>
  
  <p>I seem to be getting stuck on the last line, with an error of </p>
  
  <blockquote>
    <p>An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dll, Syntax error in INSERT INTO statement</p>
  </blockquote>
  
  <p>I realize there are similar questions but I am seriously stuck with this. </p>
  
  <p>The table does exist and I can make a connection to the database.</p>
  
  <p>Examples of the data going in (into the table "LOB") would be LOB-EN001, Bob, Common, Monster, 1.</p>
  
  <p>Thank you in advance - Sam</p>