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  |  

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


  Ads  
Biz Modules provides professional business modules and solutions for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

SourceGear - Tools for Developers
.: CounterSoft :.
telerik
ExactTarget email software solutions
Merak Mail Server
WebSecureStores -- ASP.NET & DotNetNuke Hosting 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
Online now... Rodney Joyce
1495 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
1303 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.

 


DM Analytics, LLC
DM Analytics, LLC provides software solutions that facilitate rapid development of independent or dependent datamarts and their associated web-based reporting.
www.dmanalytics.com
Integral Hosting | DNN only $14.95/month
Experienced .NET hosting on Windows 2003, ASP.NET 1.1 & 2.0, MSSQL with real technical support.
www.integralhosting.com
Aricie
Aricie is one of the French pioneers and experts in DotNetNuke technology.
www.aricie.com

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