Create a SQL Database Programmatically

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Diagnostics;
using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;


namespace CreateDB
{
    public partial class CreateDB : Form
    {
        public CreateDB()
        {
            InitializeComponent();
        }

        private string dbstring = string.Empty;

        private void CreateDB_Load(object sender, EventArgs e)
        {
            try
            {
                if (MessageBox.Show("Going to look for all SQL Server in the network this might take some time. Do you want to proceed", "SQL Servers", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
                {
                    DataTable dt = SmoApplication.EnumAvailableSqlServers();
                    foreach (DataRow dr in dt.Rows)
                    {
                        this.cbServers.Items.Add(dr[0]);
                    }
                }
                StreamReader sr = new StreamReader("BTErrorManagerDBSchema.sql");
                dbstring = sr.ReadToEnd();
                sr.Close();

            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.ToString());
                this.tbProgress.Text = ex.Message;
                this.tbProgress.ScrollToCaret();

            }
        }

        private void btnCreateDB_Click(object sender, EventArgs e)
        {
            StringBuilder sb = new StringBuilder();

            try
            {
                sb.AppendLine(string.Format("Starting to create {0} with login to {1}", this.tbDBName.Text, this.tbBTSAppUser.Text));
                sb.AppendLine("Connecting to DB Server");
                dbstring = dbstring.Replace(@"LIGHTWIDGETSVM\BizTalk Application Users", this.tbBTSAppUser.Text);
                this.tbProgress.Text = sb.ToString();
                this.tbProgress.ScrollToCaret();
                //Connect to the local, default instance of SQL Server.
                string srvname = this.cbServers.SelectedItem as string;
                Server srv;
                if (srvname == null)
                {
                    srv = new Server();
                    sb.AppendLine("Connected to local SQL server");
                }
                else
                {
                    srv = new Server(srvname);
                    sb.AppendLine(string.Format("Connected to {0}", srvname));
                }

                this.tbProgress.Text = sb.ToString();
                this.tbProgress.ScrollToCaret();
                //Define a Database object variable by supplying the server and the database name arguments in the constructor.
                Database db = srv.Databases[this.tbDBName.Text.Trim()];
                if (db != null)
                {
                    if (MessageBox.Show(string.Format("The '{0}' already exists do you want to drop it?", this.tbDBName.Text), "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                    {
                        db.Drop();
                    }
                    else
                    {
                        if (MessageBox.Show(string.Format("Create the Tables and Stored Procedures for BT Error Manager on  '{0}'?", this.tbDBName.Text), "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                        {
                            sb.AppendLine("Creating the Tables and Stored Procedures.");
                            this.tbProgress.Text = sb.ToString();
                            db.ExecuteNonQuery(dbstring);
                            sb.AppendLine(string.Format("Created the Tables and Stored Procedures for BT Error Manager on  '{0}'", this.tbDBName.Text));
                            this.tbProgress.Text = sb.ToString();
                            this.tbProgress.ScrollToCaret();

                        }
                        sb.AppendLine("Proceed or select another database");
                        this.tbProgress.Text = sb.ToString();
                        this.tbProgress.ScrollToCaret();
                        return;
                    }
                }
                sb.AppendLine("Creating the database.....");
                db = new Database(srv, this.tbDBName.Text);
                this.tbProgress.Text = sb.ToString();
                this.tbProgress.ScrollToCaret();
                //Create the database on the instance of SQL Server.
                db.Create();
                sb.AppendLine("Created the database.");
                sb.AppendLine("Creating the Tables and Stored Procedures.");
                this.tbProgress.Text = sb.ToString();
                this.tbProgress.ScrollToCaret();
                //'Reference the database and display the date when it was created.
                db.ExecuteNonQuery(dbstring);
                sb.AppendLine("Success!");
                this.tbProgress.Text = sb.ToString();
                this.tbProgress.ScrollToCaret();

            }
            catch (Exception ex)
            {
                Debug.WriteLine(ex.ToString());
                sb.AppendLine("Failuer:" + ex.Message);
                this.tbProgress.Text = sb.ToString();
                this.tbProgress.ScrollToCaret();

            }

            sb.AppendLine("Proceed or select another database");
            this.tbProgress.Text = sb.ToString();
            this.tbProgress.ScrollToCaret();

        }
    }
}