create the database on server by coding using asp.net witdh c#

See more:

ASP.NET

I want to create the database on database live server using asp.net coding with c# please help me.

String str;      
        //String CONN = "Data Source=ERP3\\SQLEXPRESS;Integrated Security=True;";
        String CONN = "server=Admin;uid=sa;pwd=sa;";
        SqlConnection myConn = new SqlConnection(CONN);

        //str = "CREATE DATABASE test ON PRIMARY " +
        //    "(NAME = MyDatabase_Data, " +
        //    "FILENAME = 'C:\\MyDatabase_Data.mdf', " +
        //    "SIZE = 2MB,  FILEGROWTH = 10%) " +
        //    "LOG ON (NAME = MyDatabase_Log, " +
        //    "FILENAME = 'C:\\MyDatabase_Data.ldf', " +
        //    "SIZE = 1MB, " +
        //    "MAXSIZE = 5MB, " +
        //    "FILEGROWTH = 10%)";

        str = "CREATE DATABASE testHgtech ";

        SqlCommand myCommand = new SqlCommand(str, myConn);
        try
        {
            myConn.Open();
            myCommand.ExecuteNonQuery();
            //MessageBox.Show("DataBase is Created Successfully", "MyProgram", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
        catch (System.Exception ex)
        {
            //MessageBox.Show(ex.ToString(), "MyProgram", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
        finally
        {
            if (myConn.State == ConnectionState.Open)
            {
                myConn.Close();
            }
        }

    }

String CONN = "server=Admin;uid=sa;pwd=sa;";

the above code i am using for connentivity with local server it is working the same code for live server it is not working




I am using above code to create the database on live server but it is working on local server but not working on live server please help me.


plz help me