I have stored procedures in my VFP database (I don't use SQL server). And you can call from ASP.NET any stored procedure residing in the VFP database. The VFP stored procedure adds record(s) to various VFP tables.
HTH.
>Hi Dmitry.
>Do you mean you have a stored procedure in a VFP table or a SQL SErver stored procedure ?
>
>Regards,
>Gerard
>
>
>
>>>Hi.
>>>I have an ASP.net app with a few Web forms, and source is VFP Tables.
>>>I have the app working fine by reading the data from the VFP tables into Datasets.
>>>
>>>I now want to Update some VFP Tables.
>>>Whats the best way of doing this ? I will need to Append Some records to VFP tables from datasets.
>>>
>>>Thanks in advance.
>>>Regards,
>>>Gerard
>>
>>What I do is call VFP Stored Procedure from .NET application. I don't know if this is the best approach but it works for me.
>>
>>HTH.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham