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