Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DataAdapter SQL Updation
Message
 
To
09/01/2008 23:02:58
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
01280766
Message ID:
01280779
Views:
16
>>>>LOL! I have a reputation for doing that. Well, my co-workers might think so anyway, I'm a little more polite online. <g>

Thank you! I won't yell at you if you ever ask what "lea eax,[edx+ecx+31]" means!

I will review the code you posted. What we did in VFP (I remember what VFP is now) was to functionalize the Form (by subclassing it) to loop through every field/control and commit the values of the controls to the DBFs. With tables on the Form I classed it to either APPEND FROM or SCAN...ENDSCAN with APPEND.

I notice in .NET, with Binding (which I thought you only get at Thanksgiving) that the Data is automatically flagged as needing to be updated, added or deleted in the source table (it's flagged in the DataSet), which is why I asked the original question - several books state it's the way to go but I've learned through harsh experience that what's written in books isn't always what works in real life.

Perhaps I will have to build a more robust/reliable strategy as I did in VFP.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform