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:-..

First of all you should know how you can add users in mysql databases:-

* Using CREATE USER and/or GRANT commands
* Inserting a new record into the mysql.user table

First let’s see how to use the CREATE USER command:-

CREATE USER user [IDENTIFIED BY [PASSWORD] ‘password’]

e.g

mysql>CREATE USER ‘myuser’@'localhost’ IDENTIFIED BY ‘mypassword’;

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

A SqlCommand object allows you to query and send commands to a data base. It has methods that are specialized for different commands. The ExecuteReader method returns a SqlDataReader object for viewing the results of a select query. For insert, update, and delete SQL commands, you use the ExecuteNonQuery method. If you only need a single aggregate value from a query, the ExecuteScalar is the best choice.

The major problems with this Postback pattern, is that hitting the Refresh button of your browser in steps 3 or 5 will re-post your submitted data. Step 5 is more of a problem as it could possibly re-submit that created information. Granted, there are steps that you can take to approach this problem, but this is how default ASP.NET Web Forms are treated.

Requirements before getting started with development or web programming
Any one who want to develop a web application must have the following systems:
1. A web server.
2. An editor to develop the web pages.
3. A browser to view the web page you develop.
4. A database program like MS Access, SQL Server etc, if your web site need [...]

Few Definitions for browser:-

Browser is an application, which helps us to view the Web sites and the web content.
Web sites are located in some remote systems, which needs a special kind of program or an application to access them, such an application is called browser.
A browser is an application which you can use to retrieve [...]