Hi All,

I have run into an interestign quirk when assigning an ADO Recordset Object to a DataGrid or DataList in .NET.

The ADO Recordset is created out of VFP and returned via a COM interface to .NET. The problem is that .NET seems to be keeping a local data source somewhere and I cannot figure out for the life of me where it is. Every call to the object increases the record count for the object and .NET seems to be maintaing the data somewhere. I know this is fact because I ran into this last week and when I came back in today it started adding records where it left off.

Another point of interest is that when the ADO recordset object is created in VFP, you can actually watch the record count increase in the debugger every time you click on the object. It seems to me that the AddNew method is being fired everytime you access the object in any way. However, this is not the cause of the .NET problem because the record counter always starts at zero in VFP.

Any help in figuring this one out would be greatly appreciated.

Thanks