Here is a link to download samples that show how to use ASP.NET with VFP 7 using ADO.NET. Go to about the middle of the page and you will find a reference to "Using ASP.NET in Visual Studio .NET with Visual FoxPro 7.0":

http://www.gotdotnet.com/team/vfp/

The UpdateCommand works fine for me. In the samples above it is used.

The XMLtoCursor is unsupported for the Ole Db provider. It states it in the help file. CursorToXML and XMLtoCursor use COM which isn't supported by the provider. The updated provider won't provide support for this either.


>I have been patiently developing an ASP web to ASP.net using VFP database as the back end. I noticed the Dataset has some nice features for writing and reading xml. I have been trying to eliminate as much VFP COM overhead as possible so I have move some of the data related procedures into the dbc store procedure.
>
>Questions:
>1. Has any been able to make the updatecommand work properly with vfp.
>2. Using ADO.net I received a feature not available when I try using XMLTOCursor in the dbc stored procedure file. Is this a limitation of 7.0? If yes, will VFP 8.0 fix this.
>3. What have you (the general population) used for updating VFP data from ASP.net and more specifically ADO.net? Can you provide some code examples?
>
>Thank You,
>
>David