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