The ADO way thru .NET seems confusing at first because VFP was just SO simple and easy. But eventually it makes sense. It was my hardest learning curve - getting used to the fact that data access was 1000 times harder than in fox.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MB Software Solutions General Account Sent: Tuesday, 16 December 2008 2:08 AM To: ProFox Email List Subject: RE: [NF] c# .net and databases On Mon, December 15, 2008 2:22 am, Allen wrote: > For this project I'm coming away from VFP and using c#. Not because I > want to but because the opposition is telling people I'm writing in a dead > language. They have being saying that before M$ crushed it but as its > now true I have to do something. Al 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/[email protected] ** 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.
