Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Browse on DotNet
Message
From
02/06/2011 12:22:03
 
General information
Forum:
ASP.NET
Category:
Forms
Miscellaneous
Thread ID:
01512326
Message ID:
01512580
Views:
53
There's no equivalent to what you're doing in the browse, Gerard (sigh)

If youre backend is SQL Server, I suggest that you query a vew instead of a table, where the view pre-populates all the fields you need from the related tables.





>>Say my main table is a Customer Table, but there could be losts of related tables with 'Lots' of data (e.g. Sales By Week By Customer could have 52 fields for each customer, Busdget by week by customer could have another 52, Units by week by cusotmer could have another 52 etc). On any one site, I might ever only need say week 1 sales for the sake of argument, and I dont want to have to pull 150 fields across.
I know the 'Disconnected' methodology in Dot Net probably makes this near impossible, but I live in hope !!
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Reply
Map
View

Click here to load this message in the networking platform