Click here to Skip to main content
15,888,286 members
Articles / Web Development / ASP.NET

Create database in sql server using asp.net with C# (VS2005)

Rate me:
Please Sign up or sign in to vote.
3.00/5 (3 votes)
5 Oct 20062 min read 82.7K   1.5K   30  
Create database in sql server using asp.net with C# (VS2005)
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class _Default : System.Web.UI.Page 
{
    //private System.ComponentModel.Container components = null;

    protected void Page_Load(object sender, EventArgs e)
    {
        SQLDMO.Application oSQLServerDMOApp = new SQLDMO.Application();
        SQLDMO.NameList oNameList;
        oNameList = oSQLServerDMOApp.ListAvailableSQLServers();
        for (int intIndex = 0; intIndex <= oNameList.Count - 1; intIndex++)
        {
            if (oNameList.Item(intIndex as object) != null)
            {
                cboServers.Items.Add(oNameList.Item(intIndex).ToString());
            }
            else
            {
                cboServers.Items.Add("(Local)");

            }
        }
         cboServers.SelectedIndex = 0;

    }
    protected void btnCreateDB_Click(object sender, EventArgs e)
    {
        string strDatabaseName = "";
        SQLDMO.SQLServer gSQLServerDMO = new SQLDMO.SQLServer();
        SQLDMO.Database nDatabase = new SQLDMO.Database();
        SQLDMO.DBFile nDBFileData = new SQLDMO.DBFile();
        SQLDMO.LogFile nLogFile = new SQLDMO.LogFile();

        strDatabaseName = txt_Database.Text.ToString();


        try
        {
            gSQLServerDMO.Connect(this.cboServers.SelectedItem.ToString(), this.txtUser.Text, this.txtPassword.Text);

            nDatabase.Name = strDatabaseName;
            nDBFileData.Name = strDatabaseName;
            nDBFileData.PhysicalName = gSQLServerDMO.Registry.SQLDataRoot + "\\DATA\\" + strDatabaseName + "_Data.mdf";
            nDBFileData.PrimaryFile = true;
            nDBFileData.Size = 2;

            nDBFileData.FileGrowthType = SQLDMO.SQLDMO_GROWTH_TYPE.SQLDMOGrowth_MB;
            nDBFileData.FileGrowth = 1;

            //Add the DBFile object
            nDatabase.FileGroups.Item("PRIMARY").DBFiles.Add(nDBFileData);

            //
            nLogFile.Name = strDatabaseName + "Log";
            nLogFile.PhysicalName = gSQLServerDMO.Registry.SQLDataRoot + "\\DATA\\" + strDatabaseName + "_Log.ldf";
            nLogFile.Size = 2;
            nDatabase.TransactionLog.LogFiles.Add(nLogFile);

            gSQLServerDMO.Databases.Add(nDatabase);
            Page.ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type=\"text/javascript\">alert('Database Sucessfully Created');</script>");
            gSQLServerDMO.DisConnect();
           

        }
        catch (Exception SQLDBException)
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "Error", "<script type=\"text/javascript\">alert('" + SQLDBException.Message + "');</script>");

            return;
        }
        finally
        {
        }
    }
}

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


Written By
Web Developer
India India
I'm Joshy George.I finished my Post Graduation in Computer Application,i'm from the great 'Gods Own Country', Kerala, India. Now I'm working in Infopark Kochin, as a Sr.software Engineer.my specialised areas are C# ,Asp.Net ,Vb6,smart card application,Tapii,Comm ctrls.

Comments and Discussions