Create Database and tables, Store Procedures Using C#

using System.Data.Sql;
using System.Data.SqlClient;


using (SqlConnection objCon = new SqlConnection("Initial Catalog=DBName; Data Source=SERVERNAME; Integrated security=SSPI; pooling=false"))
            {
                objCon.Open();

                SqlCommand cmd = new SqlCommand("CREATE TABLE TEST(ID INT, NAME VARCHAR(50))", objCon);
                cmd.ExecuteNonQuery();

                cmd = new SqlCommand("CREATE PROCEDURE SPTEST @PARAM INT AS BEGIN SELECT * FROM TEST END", objCon);
                cmd.ExecuteNonQuery();
            }

 public bool CreateCompanyDatabase(string CN)
        {
            String str;
            SqlConnection myConn = new SqlConnection("Server=ESTSYS4-PC;database=master;uid=sa;pwd=est$123;");
            str = "USE MASTER CREATE DATABASE " + CN;
            SqlCommand myCommand = new SqlCommand(str, myConn);
            try
            {
                myConn.Open();
                myCommand.ExecuteNonQuery();
                MessageBox.Show("DataBase is Created Successfully", "ISELLit", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return true;
            }
            catch (System.Exception ex)
            {
                MessageBox.Show(ex.ToString(), "ISELLit", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return false;
            }
            finally
            {
                if (myConn.State == ConnectionState.Open)
                {
                    myConn.Close();
                }
            }
        }

Script Method


public void CreateScript(string CN)
        {
            string SQLscript = null;
            //ISELLit_temp C:\Users\ESTSYS4\Desktop\Design\ISELLIT\UIDESIGN\ISELLIT\ISELLIT\bin\Debug\Script
            //FileInfo file = new FileInfo(@"\\ares\c$\Inetpub\wwwroot\TestArea\SQL\testsql.sql");
            FileInfo file = new FileInfo(@"C:\Users\ESTSYS4\Desktop\Design\ISELLIT\UIDESIGN\ISELLIT\ISELLIT\bin\Debug\Script\ISELLit_temp.sql");
            string script = file.OpenText().ReadToEnd();
            SQLscript = script.Replace("GO", "");
            SqlConnection conn = new SqlConnection("Server=ESTSYS4-PC;database=" + CN + ";uid=sa;pwd=est$123;");
            SqlCommand Cmd = new SqlCommand(SQLscript, conn);
            try
            {
                conn.Open();
                Cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString(), "ISELLit", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            finally
            {
                if (conn.State == ConnectionState.Open)
                {
                    conn.Close();
                }
            }
        }