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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...HOW and WHERE do we insert vb/asp.net scripts to connect/query a database?HOW and WHERE do we insert vb/asp.net scripts to connect/query a database?
Previous
 
Next
New Post
3/21/2007 9:21 AM
 

good day sirs and madams,

I am new to dotnetnuke and I see how powerful this CMS is. I hope you could help me with my problem:

I need to configure the website (dotnetnuke) we have created such that it can connect/query/update an existing user database. for example, when I click on a link on my tab that says "quizzes" It will display quiz questions that are stored in an existing database.

I have tried to dig deeper into the aspx/aspx.vb core codes of dnn (like default.aspx) and I happen to find no trace of potential areas where I can insert vb/ asp.net code. Please try to help a newbie. It would be greatly appreciated.

additional:

where do you find the pages created? because as I have observed, they are all in default.aspx when you try to look at the URL. sorry, because I am so used to HTML, where as you link pages together and you navigate to that page when you click the link and you can see the code itself. In dotnetnuke, I don't see any. I was expecting that when I see the default.aspx code, I would see the links (like hrefs or some sort) to other pages/tabs whatever you call it, that I created.

Thanks for your time on helping a newbie. rest assured you'll be repaid by your kindness by a higher entity in this life!

 

 

 
New Post
3/21/2007 1:57 PM
 

DNN is a framework to create Web sites dynamically.  There is no single place where you can see the HTML code as such.  The pages are generated on the fly with data that is stored in the DNN database.  Default.aspx is the skeleton page where other modules are integrated and loaded to generate the actual page content that is sent to the browser according to the Page ID and the Module ID that were defined for the page.  These pages only exist for a brief moment and are not stored anywhere permanently where you can see them.  (Well, DNN may keep some content in cache memory for performance reasons but you cannot see or touch that either).

You may want to view a nice introductory video from the link that reads "What is DotNetNuke" in the upper left hand side of the front page of this site.  The video was created with version 3 of DNN but the concepts are the same.

Regarding the access to the database you mention, that can get complicated.  Watch the video, play with DNN for a while and then come back with more questions.

Carlos

 

 

 
New Post
3/21/2007 8:46 PM
 

thank you sir, I will watch it now. but im still wondering why it could be complicated. i have an idea, can i insert my existing database (or the tables of this database) into the database of dotnetnuke (where the content is located) and connect/query/update from there? if it is a good thing, any ideas how to do it? thanks for the support.

 
New Post
3/21/2007 10:28 PM
 

Sorry, I didn't mean to discourage you from doing the database work.  I just thought that since you are new to DNN that you could get familiar with it first so that you see what is possible and maybe how.

You can certainly copy the tables from your database to the DNN database and manipulate the data with the User Defined Table module, which is one of the DNN basic modules.  But you have to keep in mind that if you wish to apply complex business rules or validation to the data it may be difficult or impossible.  You can also research other commercial modules you can add from www.snowcovered.com or even free modules by the DNN community.

Carlos

 

 

 
New Post
3/21/2007 11:13 PM
 

haha no sir, I'm pretty much hyped by the database problem because I badly need it.

Yes sir I'll be needing validation. this is the flow of my task:

a user logs in an existing portal, clicks the link to go to our portal, existing portal throws an encrypted string of the employee information, I should validate the input if it is a valid encrypted string (still dont know how to do that), validate its contents (employee info) and check it against a user database (the database I'm talking about. that I'm planning to put inside the dnn database because I can't find a way to access this database by hardcoding/inserting vb or asp.net scripts in the core code of dnn since as you've said, pages are dynamically loaded during runtime) and if the employee exists in the database, then I let him/her in, if not, I create a new record of the employee first, who visited the site probably his or her first time, and then let him or her in...

So you see sir, I am really dependent on this user database. I'll be getting quiz questions and quiz scores from here as well...

 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...HOW and WHERE do we insert vb/asp.net scripts to connect/query a database?HOW and WHERE do we insert vb/asp.net scripts to connect/query a database?


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