c#创建数据库

最新推荐文章于 2024-04-29 22:49:38 发布

CatchMe_439

最新推荐文章于 2024-04-29 22:49:38 发布

阅读量2.4k

点赞数 3

分类专栏： c# 文章标签： c#

本文链接：https://blog.csdn.net/CatchMe_439/article/details/54948700

版权

c# 专栏收录该内容

43 篇文章 0 订阅

订阅专栏

        private void button1_Click(object sender, EventArgs e)
        {
            //打开数据库连接
            SqlConnection conn = new SqlConnection("server=localhost; uid=sa; pwd=sa123456");
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            string sql = "CREATE DATABASE MyDataBase on primary" + "(name=MyDataBase,filename='F:\\MyDataBase.mdf',size=5,filegrowth=1)";
            sql += "log on" + "(name=MyDataBase_log,filename='F:\\MyDataBase_log.ldf',size=3,filegrowth=10%)";
            SqlCommand cmd = new SqlCommand(sql, conn);
            try
            {
                cmd.ExecuteNonQuery();
                MessageBox.Show("数据库创建成功。");
            }
            catch (SqlException ae)
            {
                MessageBox.Show("数据库创建失败。" + ae.Message.ToString());
            }
        }