Hello,

I was wondering how you access live databases on DNN with sql?

normally you would need to connect to the database with a password, etc and then you could have your SQL code execute underneath, but I can't seem to figure out if that's what I need to do or if it's automatically connected because of it being on a live server etc...

Here's what I need to do, I need to write SQL into an ascx file (if that's possible) so that when a user loads the page it will pull up certain information from the database

such as...

SELECT * FROM Values WHERE UserId = this.UserId;

this.UserId might not be the right thing to use, but either way, I want to be able to use SQL functions to retrieve and display information from the database.

If anyone has any insight on how SQL works with DNN I would appreaciate your help. Thanks in advance!

Matt

Before you go too far with writing ad-hoc SQL queries from your own ASCX file, take a look at DNN's included REPORT module which lets you run SQL queries and display the results in a DNN page.

Beyond that, there are some free third-party modules available to do the same.  Here are a couple of "how-to" postings along with sample SQL code for doing just the type of thing you describe (also note the free Advanced Datagrid comes complete with module source code):

   Free module:  Advanced DataGrid (Part 1) -- Make a "Most Rcent User Signups" List
   http://www.eguanasolutions.com/DNN_Blog/EntryID/2.aspx

   Free module:  Advanced DataGrid (Part 2) -- Make an "Events Status" Table for the EVENTS Module
   http://www.eguanasolutions.com/DNN_Blog/EntryID/5.aspx

   Free module:  Advanced DataGrid (Part 3) -- Create a Clickable "Most-Commented" Blogs Module
   http://www.eguanasolutions.com/DNN_Blog/EntryID/13.aspx

   Free module:  SQLView -- Make an EVENTS List Sortable by City / County / State
   http://www.eguanasolutions.com/DNN_Blog/EntryID/15.aspx

 
-mamlin