Al, You can use any type of data "table/source" you need with ADO. And once you have actioned the "SQL Select" you can then use the OLEDBReader class to access the data. A simple example is at:
http://www.devarticles.com/c/a/ADO.NET/Data-Access-in-.NET-using-C-sharp-Par t-1/ Wrap everything up in a c# class and you can work as seamlessly as with VFP free tables. Dave Crozier -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Allen Sent: 15 December 2008 16:13 To: [email protected] Subject: RE: [NF] c# .net and databases I had guessed that's the sql way. What I was actually looking for was if data could be used in c# without it being server driven. In other words data like vfp uses it. The disconnect is fine but I was looking for I suppose the equivalent of free tables in VFP. Al -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions General Account In that case, you'll need to understand that data access from the others is (iirc) done via ADO recordsets. You establish a connection (similar to the handle in VFP), then issue commands and get back recordsets. There's several things online for ADO. Not too hard. Just try and relax and realize that you just work with disconnected data (instead of constant connection like classic Fox). You get what you need in its local dataset, do your data manipulations (add/edit/delete), then send back the changes. Or you could use the recordsets as a read-only cursor and then do the add/update/delete using SQL on the backend data, then just requery your local datasets....like cursors, but slightly different. Good luck, Al! [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/419fefc7c35840699acc371a399ff...@develop ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
