Many times in ASP or dot net we may need to connect to a mysql database.For making a connection to mysql database we need to install mysql connector for windows which you can download from:-..

There are manby things which are considered as basics in dot net nuke.When you are using host sql window from dnn then most definitely you will need to have ideas of basic sql statements to fetch info from db.Few of them are:-
Listing all tables from DataBase:-

SELECT * FROM information_schema.Tables

Get Stored procedure description and Structure:-

select * from information_schema.routines where routine_name = ‘Stored Procedure Name’

Querry to fetch all tables in a database:

select * from sysobjects where type=’u’

Creating your first dnn module in dnn is very simple and may be little tricky for many.Someone can spent a lot time he dosnt know how to get started with dnn module creations.So iam explaining here how i got my first dnn module working.The basic requirements for this are:-
# Set up your development environment
# Under DesktopModules create a folder called contactme
# Create three files under contactme folder