We're in the processing of creating a set of applications which have over
100 tables for which we need to provide some very similar update capability.
We've identified some basic requirements for this "Type" of routine:
- All typically require navigation through the tables
(First,Last,Next,Previous,Find), Addition, Modification and Deletion.
- We've decided that we want the primary field update to occur on a FORM
(instead of in a grid)
- Multiple screens are required for Tables with many fields.
- Filtering of the records from primary table to be included in the
maintenance.
I've worked my way through quite a bit of material on Windows Forms and ADO
Net (my favorite ia Microsoft ADO.NET by David Sceppa). I've been
building my own routines for maintenance and have a number working ok.
My question is, are there existing tools which can either generate the code
for these types of routines, or that provide base classes for such a
maintenance routine. I've been building my own, but I'm sure many other
developers have gone through something similar.
Let me give an example of a simple issue that we're just started to address.
In an EMPLOYEE maintenance, when ADDing a new record, we currently clear
the fields and allow the user to enter new info. What's the best way to
trap the entry of an existing Employee. Its pretty simple to trap when the
DataRow is added to the data set, but I think it would be better if it could
be detected immediately upon entry of the field. Of course, for another
maintenance routine, the primary key might consist of several fields, so the
timing would be different.
Are there any tools that provide support for development of this type of
capability.
Thanks all.
