There are a few ways that you can do this.

You can pass a DataSet as XML pretty easily. Persist to an XML string and pass that as a parameter. Same the other way back if you're using VFP 8 you can use the XMLAdapter to create the appropirate XML - even updategram style XML required to do the update.

Passing arrays directly is not going to work because of the way .Net packages arrays is not compatible with VFP's array passing (actually I haven't tested this with the release of VFP 8 so maybe that does work, but I don't think so).

However you can create a 'parameter' object that contains an array and pass that back to VFP, which could then access it.

Much of this information can be found in a couple of articles I posted on COM interop on my Web site:

http://www.west-wind.com/articles.asp

There's a ton of information in there on how to pass data between VFP and .Net and back.

+++ Rick ---





>Does anyone have any examples or "know-how" about passing an array of parameters (or better yet a DataTable) from ADO.NEt to a VFP Stored Procedure or COM object?
>
>Thanks.