Пример #1
0
    /// <summary>
    /// 创建数据库连接和SqlCommand实例
    /// </summary>
    public DataLogic()
    {
        ServerPath sp      = new ServerPath();
        string     iniName = "DataBase";
        //获取登录的服务器
        string strServer = sp.sqlPath(iniName, "Server");
        //获取登录的数据库名
        string strDatabase = sp.sqlPath(iniName, "Data");
        //获取登录用户
        string strUserID = sp.sqlPath(iniName, "UserID");
        //获取登录密码
        string strPwd = sp.sqlPath(iniName, "Pwd");
        //数据库连接字符串
        string strConn = "Server = " + strServer + ";Database=" + strDatabase + ";User id=" + strUserID + ";PWD=" + strPwd;

        try
        {
            m_Conn           = new SqlConnection(strConn);
            m_Cmd            = new SqlCommand();
            m_Cmd.Connection = m_Conn;
        }
        catch (Exception e)
        {
            throw e;
        }
    }