Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Design advice re: generic BizObj.Search()
Message
De
26/12/2003 13:16:58
Ron Hodge
Sebrex Systems, Inc.
Dacula, Georgie, États-Unis
 
Information générale
Forum:
ASP.NET
Catégorie:
Programmation orienté objet
Divers
Thread ID:
00861705
Message ID:
00862167
Vues:
24
Kelly,
You can limit the records retrieved with the syntax:
DbDataAdapter.Fill Method (DataSet, StartRecord, MaxRecords, srcTableName)

By changing the StartRecord parameter, the user can work their way thru the data. I've got a generic screen that gives the users two data fields (name, street, etc.) and criteria (less than, before,etc.) The results come up in a grid on the lower half of the screen, and when they dblclick on a row, it's moved to the editing screen. On the grid they dblclick on, the primary key is always in the leftmost column, so it's easy to retrieve the right row.

So basically, decide what fields you're searching on, what the criteria are, and then generate your sql stmt from that after they click on find, fill the grid, and then move it to the data entry screen after they dblclick on it.

Hope this helps.
Ron Hodge
Sebrex Systems, Inc.
Atlanta, GA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform