日期:2014-05-17  浏览次数:20428 次

请教C#创建SQL SERVER数据库的问题
网上拷的一份代码

        public static string DB_NAME = "mydb"; 
        //public static string DB_PATH = "C:\\data\\";
        public static string DB_PATH = "C:\\";
        public static bool CreateDatabase()
        {
            bool stat = true;
            string sqlCreateDBQuery;
            SqlConnection myConn = 
                new SqlConnection("Server=localhost\\SQLEXPRESS;Integrated security=SSPI;database=master;");

            sqlCreateDBQuery = " CREATE DATABASE "
                                + DB_NAME
                                + " ON PRIMARY "
                                + " (NAME = " + DB_NAME + "_Data, "
                                + " FILENAME = '" + DB_PATH + DB_NAME + ".mdf', "
                                + " SIZE = 3MB,"
                                + " FILEGROWTH = 10%) "
                                + " LOG ON (NAME =" + DB_NAME + "_Log, "
                                + " FILENAME = '" + DB_PATH + DB_NAME + "Log.ldf', "
                                + " SIZE = 1MB, "
                                + " FILEGROWTH = 10%) ";

            SqlCommand myCommand