Information générale
Catégorie:
The Mere Mortals .NET Framework
Titre:
Need Advice - Best Way for Subset of Fields
Versions des environnements
There are times when I do not want to use all of the fields (columns) when displaying and updating data. For example the Customer table has two dozen fields, such as CustomerID, Name, phone, address, etc. But I want to only use three fields such as CustomerID, CustomerName, AccessCode to display in a grid and have the user be able to only update the AccessCode while all other fields to remain unchanged. What recommendations are there for how to setup the Business Object or do I need multiple BO's one with all of the fields and one with just the three fields? Should I setup multiple stored procedures or views to retrive only the fields I want?
Also all of my tables in MS SQL have the time stamp field that I never want to display or manipulate. Should I just uncheck it during the BO generation and it will be ignored?
Thanks for any advice as I am new to MM.net and just leaning about BO's.
John
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement