Here's my updated code to insert a record.

string lc_emkey = "TEST1";
string lc_ConnectionString = "Provider=VFPOLEDB.1;Data Source=C:\\apps\\;Mode=ReadWrite|Share Deny None";
string lc_sql = "SELECT * FROM employee where em_key = '" + lc_emkey + "'";

//Connection string.
OleDbConnection conn = new OleDbConnection(lc_ConnectionString);

//Create DataAdapter.
OleDbDataAdapter da = new OleDbDataAdapter();

// Create the DeleteCommand.
OleDbCommand cmd = new OleDbCommand(lc_sql, conn);

da.SelectCommand = cmd;

lc_sql = "INSERT INTO employee (em_key) VALUES ('" + lc_emkey + "')";
cmd = new OleDbCommand(lc_sql, conn);
da.InsertCommand = cmd;

DataSet ds = new DataSet();
//da.Fill(ds, "employee");
da.Update(ds, "employee");

>Jerry,
>
>Post your new code.
>
>~~Bonnie
>
>
>
>>Bonnie,
>>
>>Yes, the DeleteCommand and UpdateCommand do work as shown. Just the InsertCommand example does not work.
>>
>>I have not tried the Update() method before however, I just gave it a try on all three methods. I changed all the da.Fill(ds, "employee") to da.Update(ds, "employee") and ran the three methods.
>>
>>Now none of the methods work. I get an error on the da.Update() method that says 'Update unable to find TableMapping['employee'] or DataTable employee'.
>>
>>Am I missing something when I issue the da.Update()?
>>
>>Thanks,
>>
>>Jerry
>>
>>
>>>Jerry,
>>>
>>>Maybe I'm missing something, but I don't see where your Delete and Update would be working correctly either. Shouldn't you be doing a da.Update(ExistingDS) instead of a da.Fill(NewDS) ?
>>>
>>>~~Bonnie
>>>
>>>>I am having trouble creating an InsertCommand to insert a record into a VFP table. However, my DeleteCommand and UpdateCommand work just fine.
>>>>
>>>>Here is my insert method:
>>>>

>>>>string lc_emkey = "TEST1";
>>>>string lc_ConnectionString = "Provider=VFPOLEDB.1;Data Source=C:\\apps\\;Mode=ReadWrite|Share Deny None";
>>>>string lc_sql = "INSERT INTO employee (em_key) VALUES ('" + lc_emkey + "') ";
>>>>OleDbConnection conn = new OleDbConnection(lc_ConnectionString);
>>>>OleDbDataAdapter da = new OleDbDataAdapter();
>>>>OleDbCommand cmd = new OleDbCommand(lc_sql, conn);
>>>>da.SelectCommand = cmd;
>>>>da.InsertCommand = cmd;
>>>>DataSet ds = new DataSet();
>>>>da.Fill(ds, "employee");
>>>>

>>>>
>>>>The following is my DeleteCommand and UpdateCommand. These 2 command work just fine. However, my InsertCommand above does not work.
>>>>

>>>>///UpdateCommand
>>>>string lc_emkey = "JERRY";
>>>>string lc_depart = "IS";
>>>>string lc_ConnectionString = "Provider=VFPOLEDB.1;Data Source=C:\\apps\\;Mode=ReadWrite|Share Deny None";
>>>>string lc_sql = "UPDATE employee SET em_depart = '" + lc_depart + "' " +
>>>>				"WHERE em_key = '" + lc_emkey + "'";
>>>>OleDbConnection conn = new OleDbConnection(lc_ConnectionString);
>>>>OleDbDataAdapter da = new OleDbDataAdapter();
>>>>OleDbCommand cmd = new OleDbCommand(lc_sql, conn);
>>>>da.SelectCommand = cmd;
>>>>da.UpdateCommand = cmd;
>>>>DataSet ds = new DataSet();
>>>>da.Fill(ds, "employee");
>>>>
>>>>//DeleteCommand
>>>>string lc_emkey = "JERRYT";
>>>>string lc_ConnectionString = "Provider=VFPOLEDB.1;Data Source=C:\\apps\\;Mode=ReadWrite|Share Deny None";
>>>>OleDbConnection conn = new OleDbConnection(lc_ConnectionString);
>>>>OleDbDataAdapter da = new OleDbDataAdapter();
>>>>OleDbCommand cmd = new OleDbCommand("DELETE FROM employee WHERE em_key = '" + lc_emkey + "'", conn);
>>>>da.SelectCommand = cmd;
>>>>da.DeleteCommand = cmd;
>>>>DataSet ds = new DataSet();
>>>>da.Fill(ds, "employee");
>>>>

>>>>
>>>>What am I doing wrong?
>>>>
>>>>Thanks,
>>>>
>>>>Jerry