C#打开SqlServer的demo

最新推荐文章于 2023-04-27 17:37:10 发布

灬Change

最新推荐文章于 2023-04-27 17:37:10 发布

阅读量553

点赞数

分类专栏： C# 文章标签： C# SqlServer

C# 专栏收录该内容

23 篇文章

订阅专栏

        /// <summary>
        /// 判断连接对象的状态并打开连接对象
        /// </summary>
        /// <param name="con"></param>
        /// <returns></returns>
        public SqlConnection ConOpen(SqlConnection con)
        {
            switch (con.State)
            {
                case ConnectionState.Broken:
                    con.Close(); //先正常关闭，释放资源
                    con.Open();
                    break;
                case ConnectionState.Closed:
                    con.Open();
                    break;
                case ConnectionState.Connecting:
                    break;
                case ConnectionState.Executing:
                    break;
                case ConnectionState.Fetching:
                    break;
                case ConnectionState.Open:
                    break;
                default:
                    break;
            }
            return con;
        }