Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0add new table to dnn DBadd new table to dnn DB
Previous
 
Next
New Post
7/20/2009 9:53 AM
 

Hi all,

For my specific modules, I'd like to add new tables to my dnn DB , but I don't know what  fields must be added to the new tables  (ModuleId , UserId, PortalId ...)
Example , I have table customer ( custid , name ,  company , website ...) and I'd like to associate it to Users ( user can be customer).
Please how can I proced?
PS: I'm dnn developping Newbie
Thanks

 
New Post
7/20/2009 10:16 AM
 

HI!

When creating a table that will interact with the UI of DNN, you need to include ModuleId (references Modules in the DNN db), which will then ensure your custom module is display on the appropriate page.  Outside of that, there really is no requirement.  If you are going to associate a user with a specific entry in your custom module, then I would encourage using the UserId, which is a reference to the User table.  One thing you might want to investigate is how to use the UserProfile set up in the Database to manage your customer information.  Developer documents are available fromt he downloads page.

Hope this helps!


-- Scott Allender
http://www.scottallender.com
 
New Post
7/20/2009 10:32 AM
 

When we place any module on any page New ModuleId is asigned to that module ( even if you place same module on two places both will have different ModuleId)

ModuleId : Now are per your requirement If you want save and show your data as module wise then add ModuleId (int type) in your table

PortalId : If you want to show/add data per Portal then save PortalId (int ) in your db table

UserId :  saving UserId is depends up on your requirement , as your  table customer ( custid , name ,  company , website ...) here custId will be UserId 


Leo TechnoSoft Pvt.Ltd - The Biggest DotNetNuke Development Team
 
New Post
7/22/2009 6:32 AM
 

Hi,

Thanks for your replies.

In fact , I 'd like to use Triggers.

I think the best way is to create Trigger that insert users from Users Table to Customer Table. What do you think?

Thanks.

 
New Post
7/22/2009 8:19 AM
 

Do you have any UI for inserting ( name ,  company , website ...) ? If Yes Who will insert these filed I mean self or admin ?


Leo TechnoSoft Pvt.Ltd - The Biggest DotNetNuke Development Team
 
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0add new table to dnn DBadd new table to dnn DB


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, 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 DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out