Wrox Programmer Forums
|
BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0
This is the forum to discuss the Wrox book ASP.NET 2.0 Website Programming: Problem - Design - Solution by Marco Bellinaso; ISBN: 9780764584640
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 22nd, 2007, 06:39 PM
plb plb is offline
Authorized User
 
Join Date: Jan 2007
Posts: 94
Thanks: 0
Thanked 0 Times in 0 Posts
Default Why Countries in Helpers?

When I added a new page that needed the user to select a country from a Drop Down List I populated that list from a database table of countries that I have used in several other projects.

I fill the DDL with a little simple code behind. That's the way I've done it for years. It seems "natural" to me.

Why then does the BeerHouse have a long string in Helpers class called _countries? Is this just an arbitry style issue? Or is there some other advantage? I couldn't find a discussion of this development choice in the book.

http://weboperahouse.com
__________________
http://weboperahouse.com
http://www.boyleed.com
 
Old February 22nd, 2007, 07:14 PM
plb plb is offline
Authorized User
 
Join Date: Jan 2007
Posts: 94
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have another design issue. The BeerHouse has a BLL function for _addedDate. I have always used a trigger in the table to record when an update occurs. Like so:

ALTER TRIGGER [trgUpdateOperaCompany] ON [dbo].[oh_OperaCompany]
FOR INSERT, UPDATE
AS
BEGIN
    SET NOCOUNT ON;
    UPDATE oh_OperaCompany
    SET UPDATE_DATE = getdate()
        WHERE PK_OPERACOMPANY_ID =
            (SELECT PK_OPERACOMPANY_ID FROM inserted)
END

I copied this style from Siebel. Again this seems more "natural" to me. In these two cases as well as others I suspect I have taken a databse centric approach. Am I just out of date?

http://weboperahouse.com





Similar Threads
Thread Thread Starter Forum Replies Last Post
manipulating data in mysql using php - countries phpnukes BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 0 January 24th, 2005 01:35 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.