Data type mismatch

OleDbCommand cmd = new OleDbCommand(

          String.Format( "insert into fismas (cfisno,dfistar) values ('{0}',{1})",

             FisNo,

             DateTime.Now.ToString("{^yyyy/MM/dd}")),

      con);

using System;

using System.Data;

using System.Data.OleDb;

using System.Windows.Forms;

 

class test

{

  static void Main()

  {

   string strConn = @"Provider=VFPOLEDB;Data source=

C:\Program Files\Microsoft Visual FoxPro 9\Samples\Data\testdata.dbc;";

 

  OleDbConnection cn = new OleDbConnection(strConn);

 

   // Prepare command and parameters

   string strInsert = "insert into employee (emp_id,first_name,last_name,birth_date) values (?,?,?,?)";

 

   OleDbCommand cmdStartUp = new OleDbCommand("set null off",cn);

 

   OleDbCommand cmdInsert = new OleDbCommand(strInsert,cn);

   cmdInsert.Parameters.AddRange( 

    new OleDbParameter[] {

        new OleDbParameter("emp_id",OleDbType.Char),

    new OleDbParameter("first",OleDbType.Char),

        new OleDbParameter("last",OleDbType.Char),

        } 

    );

    cmdInsert.Parameters.AddWithValue("bdate",DateTime.Now);

 

    cn.Open();

    cmdStartUp.ExecuteNonQuery();

    cmdInsert.Parameters["emp_id"].Value = "XXX1";

    cmdInsert.Parameters["first"].Value = "James";

    cmdInsert.Parameters["last"].Value = "Green";

    cmdInsert.ExecuteNonQuery();

    cmdInsert.Parameters["emp_id"].Value = "XXX2";

    cmdInsert.Parameters["first"].Value = "Cetin";

    cmdInsert.Parameters["last"].Value = "Basoz";

    cmdInsert.Parameters["bdate"].Value = new DateTime(1961,1,19);

    cmdInsert.ExecuteNonQuery();

 

 

    DataTable t = new DataTable();

 

    OleDbCommand cmdSelect = new OleDbCommand("select * from employee",cn);

    OleDbDataReader rdr = cmdSelect.ExecuteReader();

    t.Load(rdr);

    rdr.Close();

    cn.Close();

 

    Form f = new ShowDataForm(t,"Employee Table");

    f.ShowDialog();

  }

}

 

public class ShowDataForm : Form

{

  public ShowDataForm(DataTable tbl, string caption)

  {

     this.Text = caption;

     this.ClientSize = new System.Drawing.Size(1024, 768);

     this.dgv = new System.Windows.Forms.DataGridView();

     this.dgv.Dock = DockStyle.Fill;

     this.dgv.DataSource = tbl;

     this.Controls.Add(this.dgv);

  }

  private System.Windows.Forms.DataGridView dgv;

}