c# 连接sqlServer2000

class ConnectDB

    {

        private SqlConnection myConn;

        /// <summary>

        /// 服务器连接字任串

        /// </summary>

        private string ServerStr;

        /// <summary>

        /// 服务器地址

        /// </summary>

        static string server;

        /// <summary>

        /// 数据库登陆用户名

        /// </summary>

        static string uid;

        /// <summary>

        /// 登陆密码

        /// </summary>

        static string pwd;

        /// <summary>

        /// 数据库名

        /// </summary>

        static string database;

        /// <summary>

        /// 构造函数

        /// </summary>

        public ConnectDB()

        {

            ServerStr = "server=" + server + ";uid=" + uid + ";password=" + pwd + ";database=" + database;

            myConn = new SqlConnection(ServerStr);

        }

        /// <summary>

        /// 打开连接

        /// </summary>

        public void Open()

        {

            myConn.Open();

        }

        /// <summary>

        /// 测试数据库

        /// </summary>

        public int tOpen()

        {

            try

            {

                myConn.Open();

                return 1;

            }

            catch

            {

                return 0;

            }

        }

        /// <summary>

        /// 关闭连接

        /// </summary>

        public void Close()

        {

            myConn.Close();

        }

        /// <summary>

        /// 把自义类转化为SqlConnection类

        /// </summary>

        /// <returns>SqlConnection</returns>

        public SqlConnection ChangeType() 

        {

             return myConn;

        }

        /// <summary>

        /// 设置服务器地址

        /// </summary>

        /// <param name="Server">服务器地址</param>

        public static void setServer(string Server)

        {

            server=Server;

        }

        /// <summary>

        ///设置登陆用户名

        /// </summary>

        /// <param name="Uid">用户名</param>

        public static void setUid(string Uid)

        {

             uid=Uid;

        }

        /// <summary>

        /// 设置登陆密码

        /// </summary>

        /// <param name="Pwd">密码</param>

        public static void setPwd(string Pwd)

        {

            pwd=Pwd;

        }

        /// <summary>

        /// 设置数据库

        /// </summary>

        /// <param name="Database">数据库名</param>

        public static void setDatabase(string Database)

        {

            database=Database;

        }

   }