Maintenance Rouitne

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

jlapenta_at_entelsys.com
Date: 07/21/04 

Date: Wed, 21 Jul 2004 01:29:13 GMT

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

Relevant Pages

  • Re: Maintenance Rouitne
    ... I would think that many> applications require similar capability. ... I've worked my way through a> number of books and documents and have built a number of routines. ... We've got a number of these routines built. ... 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. ...
    (microsoft.public.dotnet.framework.adonet)
  • Maintenance routines
    ... applications require similar capability. ... Sceppa) and have built a number of routines. ... We've got a number of these routines built. ... We'd like focus to automatically go to the primary key. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Whats the point of C# and C++
    ... I have found the graphics classes and routines built into the framework ... often is due to the programmer putting too much code in a single routine. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Some of Rons Code?
    ... applications do. ... The capability to hold that much software, ... number of routines to fit in there, and there may well simply not have ...
    (comp.lang.lisp)