J
jlapenta
We are in the process of creating an Windows Forms application which
contains more than 100 tables. Many of these require “maintenance routines”
to update the information in the tables. I would think that many
applications require similar capability. I've worked my way through a
number of books and documents (my favorite is Microsoft ADO.NET by David
Sceppa) and have built a number of routines. We identified some basic
capability we'd like to provide:
· Basic navigation through the DataSet (First, Last, Next, Last, Find).
· Delete, Add.
· We want to do the field editing on a Form (as opposed to in a grid)
· The set of records from the Database to be edited needs to be controlled
by a Filter.
· Since some tables have many fields, multiple pages may be required.
· In many cases, fields in the primary table will have a relationship
defined with another table. Simple lookups of the values from related table
will be provided.
All pretty basic. We've got a number of these routines built. However,
I'm wondering if there are tools available anywhere to either help generate
the code or (even better) to help define some base classes which support
this type of routine.
The latest issue is what to do when ADDING a new record. For example, if
the primary table is EMPLOYEE, when Add is selected, we clear the fields.
We'd like focus to automatically go to the primary key. Currently, we
have the routine trapping the entry of an existing record when the record is
added to the DataSet. However, it would be better if this checked occur
immediately. Of course, for some Tables, the primary key may consist of
several fields, and so the logic for checking existence of record is a bit
more complicated.
An suggestions on where to find assistance w
contains more than 100 tables. Many of these require “maintenance routines”
to update the information in the tables. I would think that many
applications require similar capability. I've worked my way through a
number of books and documents (my favorite is Microsoft ADO.NET by David
Sceppa) and have built a number of routines. We identified some basic
capability we'd like to provide:
· Basic navigation through the DataSet (First, Last, Next, Last, Find).
· Delete, Add.
· We want to do the field editing on a Form (as opposed to in a grid)
· The set of records from the Database to be edited needs to be controlled
by a Filter.
· Since some tables have many fields, multiple pages may be required.
· In many cases, fields in the primary table will have a relationship
defined with another table. Simple lookups of the values from related table
will be provided.
All pretty basic. We've got a number of these routines built. However,
I'm wondering if there are tools available anywhere to either help generate
the code or (even better) to help define some base classes which support
this type of routine.
The latest issue is what to do when ADDING a new record. For example, if
the primary table is EMPLOYEE, when Add is selected, we clear the fields.
We'd like focus to automatically go to the primary key. Currently, we
have the routine trapping the entry of an existing record when the record is
added to the DataSet. However, it would be better if this checked occur
immediately. Of course, for some Tables, the primary key may consist of
several fields, and so the logic for checking existence of record is a bit
more complicated.
An suggestions on where to find assistance w