C#_连接数据库，获取密码并比对

using System.Data;
using System.Data.OleDb;

namespace CheckTheEnvironmentTest_3_30
{
    class DatabaseLinkage
    {
        OleDbConnection conn;
        OleDbCommand cmd;
        OleDbDataReader dr;
        public void DatabaseInit() 
        {
           conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DataBase.mdb");
          if(conn.State==ConnectionState.Closed)
                conn.Open();    
        }
        public bool DatebaseCheck(string name,string password)
        {
            string sqlText = "select UserName,UserPassword from [User] where UserName='" + name + "'";//一定要注意引号，不然会报错
            DataSet dsMsg = new DataSet();
            OleDbDataAdapter da = new OleDbDataAdapter(sqlText, conn);
            da.Fill(dsMsg);
            if (password==dsMsg.Tables[0].Rows[0]["UserPassword"].ToString())//获取到密码
                return true;
            else
                return false;
        }
        public void DatabaseClose() 
        {
            conn.Close();
        }
    }
}