数据库连接,帮我看看有什么错

2008-06-28 01:19:56 68 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

lim62008 墨衍会员 · AI 创作全网分发关注 + 加入社区

Azure数据库服务比较：SQL Database vs Cosmos DB 结构化数据场景：如订单管理、用户认证等需要强事务支持的业务非结构化/半结构化场景：如物联网设备日志、社交网络数据、实时推荐系统：基于传统关系型数据库（SQL Server）的云原生服务，支持ACID事务和复杂SQL查询Cosmos DB：全球分布式NoSQL数据库，支持多模型（文档、键值、图、宽列）和弹性扩展两者的架构设计哲学有何本质区别？数据建模和查询语言的差异如何影响开发体验？一致性、可用性、吞吐量的权衡模型如何选择？典型业务场景下的选型决策依据是什么？技术原理对比。阅读详情



using System;

using System.Collections;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

using System.Diagnostics;

using System.ComponentModel;

using System.Collections;





namespace WebSite1.DataAcessLayer

{

    public class Database : IDisposable

    {

        protected SqlConnection Connection;



        protected String ConnectionString;



        public Database()

        {

           ConnectionString = ConfigurationSettings.AppSettings["DBConnectionString"];

        }



        ~Database()

        {

            try

            {

                if (Connection != null)

                {

                    Connection.Close();

                }

            }catch { }

            try

            {

               Dispose();



            }

            catch{ }

        }

        protected void open() 

        { 

            if(Connection == null)

            {

                Connection = new SqlConnection(ConnectionString);

            }

            if(Connection.State.Equals(ConnectionState.Closed))

            {

                Connection.Open();

            }

        }

        public void Close() 

        {

            if (Connection != null)

            {

                Connection.Close();

            }

        }

        public void Dispose()  //释放连接数据库所占用的资源

        { 

            if(Connection !=null)

            {

                Connection.Dispose();

                Connection = null;

            }

        }

        public int ExecuteSQL(String SqlString)

        {

            int count = -1;

            open();

            try

            {

                SqlCommand cmd = new SqlCommand(SqlString, Connection);

                count = cmd.ExecuteNonQuery();



            }

            catch

            {

                count = -1;



            }

            finally

            {

                Close();

            }

            return count;

        }

        public DataSet GetDataSet(String SqlString) 

        {

            open();

            SqlDataAdapter adapter = new SqlDataAdapter(SqlString, Connection);

            DataSet dataset = new DataSet();

            adapter.Fill(dataset);

            Close();

            return dataset;

            

        }

        public DataRow GetDAtaRow(String SqlString) 

        {

            DataSet dataset = GetDataSet(SqlString);

            dataset.CaseSensitive = false;

            if(dataset.Tables[0].Rows.Count>0)

            {

                return dataset.Tables[0].Rows[0];

            }

            else

            {

                return null;

            }

        }



    }

}