Jerry,

I would not use the CommandBuilder with VFP7. The OLE DB provider was updated in VFP8 and is more compatible with .NET. There are two links that can help with the how to update data.

1. A white paper that explains how to work with ASP.NET and VFP7 and is called "Using ASP.NET in Visual Studio .NET". The samples are in VB (for the sake of the general audience), however the article shows the code for 3 of the 4 samples in C#.

http://prenia.com/Downloads.htm

2. A white paper that explains how to use ADO.NET with Visual FoxPro. It is called "Introduction to ADO.NET". There is also a presentation on ADO.NET at the same location with a sample project. This presentation was done in VB (easier for the audience to follow) but the concepts are the same for both languages.

http://prenia.com/Downloads.htm


>Is there an example of updating a VFP7 table with C#?
>
>I'm am able to query VFP7 tables in C# using a DataSet but I have not been able to perform an update. I have looked at using the
>
>OleDbCommandBuilder CommandBuilder = new OleDbCommandBuilder(DataAdapter);
>
>but I always get any error on:
>DataAdapter.DeleteCommand = CommandBuilder.GetDeleteCommand();
>
>Is there a way to update VFP data from C#?
>
>Thanks,
>
>Jerry