Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

AspDotNetStoreFront
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
Webhost4Life - $4.95 Windows Hosting
 


  Sponsors  

Meet Our Sponsors

Salaro -- Skins and more
OnyakTech
The best choice for your web site host, email hosting, and domain registration.
CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! ( Pr...  Is both ItemID and ModuleID mandatory on the table design
Previous Previous
 
Next Next
New Post 5/11/2006 3:35 PM
User is offline Andries Roux
8 posts
www.rouxbox.net
10th Ranked


Is both ItemID and ModuleID mandatory on the table design 

Hi there. I am sorry if this has been asked before but i could not find it on any forumn

I created a module and just to be on the safe side, I added ItemID, ModuleID, CreateByUser and CreatedDate as Columns to my table and then went ahead and generated the Info, Controller, SQLDataprovider and Dataprovider with the modified SeaburyDesign CodeSmith templates as shown on the videos.

Fair enough, i had to make some Namespace adjustments, but then i ran into a problem on the ViewXXX.ascx.vb class. The PageLoad method is asking for

colImageLinkBannerss = objImageLinkBannerss.GetImageLinkBanners(ModuleId)

However, the autogenerated GetImageLinkBanners method that signature is.

Public MustOverride Function GetImageLinkBanners(ByVal itemID As Integer, ByVal moduleId As Integer) As IDataReader

The problem now is that the ItemID is unavailable at the PageLoad method. Commenting this out will only solve the problem in the short run.

 
New Post 5/12/2006 1:30 AM
User is offline Rodney Joyce
1446 posts
www.smart-thinker.com
6th Ranked




Re: Is both ItemID and ModuleID mandatory on the table design 
Hello

PortalID, ModuleID and ItemID columns all depend on your module design. You will naturally have an itemID - this is the unique ID per record, but whether you want your data displayed at module level or portal level is up to you.

For example - when you add an HTML/Textbox, each version of the module has unique text, hence this is stored at module level and would need a moduleID. In my Events module though, each module you add looks at the central repsoitory of information, so I hinge it off PortalID, if you see what I mean.

I always add CreatedByUserID, ChangedByUserID, CreatedDate and ChangedDate to ALL my tables for auditing purposes.


Thanks,
Rodney
Smart-Thinker - Social Networking modules for DotNetNuke
The DotNetNuke Directory - Are you listed?
PokerDIY - Example Implementation of DNN Social Network
Do use DNN a lot? Try the DotNetNuke Toolbar to save you time!
 
New Post 5/12/2006 5:27 AM
User is offline Joe Brinkman
1244 posts
www.dotnetnukecorp.com
6th Ranked






Re: Is both ItemID and ModuleID mandatory on the table design 

An important element in delevoping module is understanding the scope of the data.  In all but a few instances your data should be keyed off of the PortalID.  What this means, is that if you look at the relationships for your table, can you ultimately resolve the PortalID associated with your data.  This is important because DotNetNuke uses a virtual portal model which allows multiple independent portals to run from a single installation.  Does this mean you need to store PortalID in your table?  No.  It means you need to have a relation to some data that ultimately has a relation with PortalID.  So if you store ModuleID or TabID with your data then you can use those pieces to get to the PortalID since a module or tab is related to a single portal.


Joe Brinkman
DotNetNuke Corp.

The Accidental Geek - Joe Brinkman

 
Previous Previous
 
Next Next
  Forum  General DotNetN...  Extend It! ( Pr...  Is both ItemID and ModuleID mandatory on the table design
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Active Modules, Inc.
Creators of Active Forums, the best forum module for DotNetNuke
www.activemodules.com
DotNetNuke Marketplace - Modules & Skins
The DotNetNuke Marketplace is the official e-commerce gateway for the DNN ecosystem. It's the place to buy and sell DotNetNuke modules, DotNetNuke skins, and other DNN offerings.
DotNetNuke Marketplace
ExactTarget Email Marketing Software and Solutions
ExactTarget delivers on-demand email software solutions for permission-based email marketing. ExactTarget offers solutions that meet the needs of all industry verticals and all size organizations, including SMB, corporate divisions, not-for-profits, large retail/direct marketers, agencies and enterprises.
ExactTarget.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP