removed old projects no longer used. Updated SQL dataset retrieval, logging, console output

DotNetNuke make a lot of use of Javascript: 

Generally now DotNetNuke loads: 

the ClientAPI,
the jQuery framework
and the AJAX framework.  

This is all JavaScript loaded to the page. 

From DotNetNuke Wiki: 

jQuery is a fast and concise JavaScript Library that simplifies HTML document traversing, event handling, animating, and Ajax interactions for rapid web development. jQuery can be used in all versions of DotNetNuke, but native support was added for it in5.0 

With jQuery we have tried to provide a mechanism that only loads the jQuery library when absolutely necessary. If none of the modules or skin-objects on a page require jQuery, then it won’t be included in the page. If your module wants to use jQuery then you must include a long, complicated block of code that looks like this:

DotNetNuke.Framework.jQuery.RequestRegistration()

DotNetNuke 6.0 now includes jQuery and jQuery UI  as part of the standard build. 

Query UI»

As of DotNetNuke 6, jQuery-UI is also shipped (and integrated) with the core. When registering jQuery-UI, there is no need to register jQuery as the jQuery-UI registration method will handle this for you. You can register jQuery-UI for use in your own work by using the following code (in Page Load or Init): 

DotNetNuke 6.0 uses jQuery UI as part of the standard libraries of the installation,so a module or other object developer may end up with duplicate references to the libraries on a page if it references

So if you see JavaScript errors on a DotNetNuke 6.0 page, check for multiple references to jQuery or jQuery UI libraries.  
Errors you get may not point to jQuery references as the source of the problem. 

http://www.dotnetnuke.com/Resources/Wiki/Page/Reusable-DotNetNuke-jQuery-Plugins.aspx 

DotNetNuke 6 uses several jQuery plugins to provide an updated, modern, and consistent user interface. These plugins are also available for use by third party developers. These plugins are best used in conjunction with the DNN HTML form patterns. 

DotNetNuke jQuery Plugins»

The following plugins are available for use in DotNetNuke 6:

• dnnAlert - displays a notice in a modal dialog (uses jQuery UI)
• dnnConfirm - displays an "are you sure?" confirmation in a modal dialog (uses jQuery UI)
• dnnPanels - displays content areas in regions that are expandable and collapsible
• dnnExpandAll - works with panels to expand or collapse all regions
• dnnTabs - Displays content areas in a tabbed format (uses jQuery UI)
• dnnTooltip - Provides help/info tooltip functionality
• dnnPreview - Helps preview skins and containers in a new window

From the Accidental Geek:  

1.  Inject the jQuery library reference in the head section.

If you just want to include a jQuery script on a page then you can edit the Page Settings/Advanced Settings to add the script reference to the Page Header Tags.