Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need Advice - Best Way for Subset of Fields
Message
From
19/11/2008 09:11:41
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
 
 
To
19/11/2008 00:06:50
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
ASP.NET
OS:
Windows XP
Network:
Windows XP
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01362763
Message ID:
01362797
Views:
9
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
Previous
Reply
Map
View

Click here to load this message in the networking platform