c# 创建SQL Server2005数据库及建表

最新推荐文章于 2025-01-01 15:30:00 发布

Build2018

最新推荐文章于 2025-01-01 15:30:00 发布

阅读量6.3k

点赞数 3

分类专栏： C# 文章标签： sql 数据库创建表 C#

本文链接：https://blog.youkuaiyun.com/jasonhds/article/details/50380387

版权

C# 专栏收录该内容

9 篇文章

订阅专栏

本文介绍如何使用C#和SQL语句检查并创建一个不存在的数据库及其表结构。通过示例代码展示了连接数据库、执行SQL命令创建数据库和表的过程，并处理了可能出现的异常。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

创建数据库代码，先判断有没有数据库，没有则创建，废话不多说，代码如下：

        private const string DB_NAME = @"safety_hidden";
        private const string DB_PATH = @"E:\";
        private string ConnectionString = @"Integrated Security=SSPI;Initial Catalog=" + DB_NAME + @";Data Source=.;";
        private SqlConnection conn = null;
        private SqlCommand cmd = null;
        private string sql = null;
        public SQLDeal()
        { }
        /// <summary>
        /// 创建数据库
        /// </summary>
        /// <param name="name">数据库名字</param>
        /// <param name="path">数据库路径</param>
        public void CreateDB()
        {
            string newConnectionString = @"Integrated Security=SSPI;Initial Catalog=;Data Source=.;";
            conn = new SqlConnection(newConnectionString);
            if (conn.State != ConnectionState.Open)
                conn.Open();
            sql = "if not exists(select * From master.dbo.sysdatabases where name='" + DB_NAME + "')" + "CREATE DATABASE " + DB_NAME + " ON PRIMARY" + "(name=" + DB_NAME + ",filename = '" + DB_PATH + DB_NAME + ".mdf', size=3," +
"maxsize=5,filegrowth=10%)log on" + "(name=" + DB_NAME + "_log,filename='" + DB_PATH + DB_NAME + "_log.ldf',size=3," + "maxsize=20,filegrowth=1)";
            cmd = new SqlCommand(sql,conn);
            try
            {
                cmd.ExecuteNonQuery();
            }
            catch (SqlException sqle)
            {
                Console.WriteLine(sqle.Message.ToString());
            }
             finally
            { 
                if(conn.State==ConnectionState.Open)
                       conn.Close();
                conn.Dispose();
            }
            
        }

        /// <summary>
        /// 创建数据库
        /// </summary>
        /// <param name="name">数据库名字</param>
        /// <param name="path">数据库路径</param>
        public bool CreateTable()
        {
            conn = new SqlConnection(ConnectionString);
            if (conn.State == ConnectionState.Open)
                conn.Close();
            sql = @"CREATE TABLE Big"+"(ID int identity primary key,"+"BigName varchar(30))";
            conn.Open();
            cmd = new SqlCommand(sql, conn);
            try
            {
                cmd.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                Console.WriteLine(ex.Message.ToString());
            }
            finally
            {
                if (conn.State == ConnectionState.Open)
                    conn.Close();
                conn.Dispose();
            }
            return true;
        }