In Dotnetnuke many time you can get a blank page on Import module definition.For one of my dnn(dot net nuke) site i did Host=>Module definition=>Import module definition and got a blank page.I did a google and found solution applied that and now making that code available here.For making this thing to work you ned to get few SQL commands run from host sql window.

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