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 09:11:41
Timothy Bryan
Sharpline Consultants
Conroe, Texas, États-Unis
 
 
À
19/11/2008 00:06:50
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
ASP.NET
OS:
Windows XP
Network:
Windows XP
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01362763
Message ID:
01362797
Vues:
8
John,

>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

You do not need to create different business objects. Just simply either use a specific stored procedure or specify the fields in your select statement. I often retrieve just a few fields into my list for display purposes.
Tim
Timothy Bryan
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform