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.

Many times in our asp dot net application we need to manipulate page titles and keywords.E.g. You may like to change page title Or to get page title.Sometimes you will need to display as content header in content area of page.In a typical .Net web application you can change the title of a page on the fly by accessing the Page object’s Title property.

Page.Title = “My Custom Page Title”;

But from within your DotNetNuke module code you do it in a slightly different way. You first type-cast the Page object into a DotNetNuke.Framework.CDefault variable. Then you read and write the Title member on the CDefault object:….

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