I haven't downloaded this yet. But at minimum this class library should give you some ideas. The author's created both a 1.1 and 2.0 version:

http://www.codeproject.com/dotnet/AMS_ADO.asp



>Can someone explain me the difference between OldDBDataAdapter and SQLDataAdpater? In my framework, in the data object, I am using OldDBDataAdapter. The connection is from VFP local tables. Does this mean my approach won't work if I want to access SQL Server data? Which would mean I would have to create another method in my data object to use SQLDataAdapter when that would be the case?