title: How To Insert Into DBF File (foxpro)
body: <p>I have the following code in asp.net:</p>
  
  <pre><code>using (OleDbCommand command = dbConnW.CreateCommand())
  {
      string CreateTableK = null;
      CreateTableK += "Create Table DSKKAR00 (DSK_ID c(10),DSK_KIND N(1),MON_PYM C(3))";
      OleDbCommand cmdCreateTable = new OleDbCommand(CreateTableK, dbConnW);
      cmdCreateTable.ExecuteNonQuery();
      System.Text.StringBuilder sb = new  System.Text.StringBuilder();
      sb.Append(WorkRoomNo + ","); 
      sb.Append("1,");
      sb.Append(",");
      OleDbCommand cmd3 = new OleDbCommand("Insert into DSKKAR00 (DSK_ID,DSK_KIND,MON_PYM) Values (" + sb.ToString() + ")", dbConnW);
      cmd3.ExecuteNonQuery();
  </code></pre>
  
  <p>But I have the following error:</p>
  
  <blockquote>
    <p>Syntax error</p>
  </blockquote>