Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need Advice - Best Way for Subset of Fields
Message
De
19/11/2008 00:06:50
 
 
À
Tous
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Titre:
Need Advice - Best Way for Subset of Fields
Versions des environnements
Environment:
ASP.NET
OS:
Windows XP
Network:
Windows XP
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01362763
Message ID:
01362763
Vues:
60
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
Fil
Voir

Click here to load this message in the networking platform