C#中如果实现和数据库的密码比对?

我是用Access,我想让用户输入的口令和数据库里数据进行比对,如果正确则可以进入,否则不能.并且还要能修改密码!请帮帮我,告诉我要怎么实现?

for循环一下就ok

这个是SQL的写法，希望对你有用~

if (String.IsNullOrEmpty(txtuser.Text) || String.IsNullOrEmpty(txtpwd.Text))
            { MessageBox.Show("输入帐号/密码再登录", "错误提示"); return; }
            int i, flag = 0;
            string ConnectStr="server=localhost;database=mydata;uid=sa;pwd=;";
            string str1 = txtuser.Text; string str2 = txtpwd.Text;
            string StrSel = "select * from [db_user]";
            string strRow1 = null; string strRow2 = null;
            SqlConnection MyCon=new SqlConnection(ConnectStr);
            MyCon.open();
            SqlCommand MyCom=new SqlCommand(StrSel,MyCon)
            SqlDataAdapter MyDataAdapter=new SqlDataAdapter(MyCom);
            DataSet MyDs=new DataSet;
            MyDataAdapter.Fill(MyDs,"db_user");
            for (i = 0; i < MyDs.Tables["db_user"].Rows.Count; i++)
            {
                strRow1 = MyDs.Tables["db_user"].Rows[i]["user"].ToString();
                strRow2 = MyDs.Tables["db_user"].Rows[i]["pwd"].ToString();
                if (str1 == strRow1 && str2 == strRow2)
                {
                    flag = 1;
                    break;
                }
            }
            if (flag == 1)
            {
                     MessageBox.Show("登录成功！","提示");
                     MyCon.Closed();
                     this.Closed();      
            }
            else
            {
                MessageBox.Show("帐号/密码错误");
                txtuser.Focus();
            }

private void button1_Click(object sender, EventArgs e)
        {
            string UserCode = textBox1.Text.Trim();
            string UserPswd = textBox2.Text.Trim();
            if (UserCode=="")
            {
                MessageBox.Show("请输入帐号");
            }
            else {
                SqlDataReader usdr = FPara.SqlReader("select top 1 * from lampUserName where UserName='" + UserCode + "'", FPara.connStr);
                if (usdr != null)
                {
                    if (usdr.Read())
                    {
                        if (usdr["Pswd"].ToString() != UserPswd)
                        {
                            MessageBox.Show("密码错误");
                        }
                        else
                        {
                            FPara.ShopCode = usdr["UserName"].ToString();
                            MessageBox.Show("登录成功");
                            this.Hide();
                            Form4 f = new Form4();
                            f.Show();

                        }
                    }
                    else
                    {
                        MessageBox.Show("帐号密码错误");
                    }
                    usdr.Close();



namespace UserData
{
    public class FPara
    {
        public static string ShopCode="";
        public static bool CheckLogin()
        {
            if(ShopCode=="")
            {
                return false;
            }
            else
            {
                return true;
            }
        }
        public static SqlConnection connStr=new SqlConnection("Server=XTZJ-674B0F596D\\SQLEXPRESS;uid=sa;pwd=123456;database=master");
        public static SqlDataReader SqlReader(string sql,SqlConnection connstr)
        {
            SqlDataReader sqldr=null;
            SqlCommand cmd=new SqlCommand(sql,connstr);
            if (cmd.Connection.State.ToString()=="Closed") cmd.Connection.Open();
            try
            {
                sqldr=cmd.ExecuteReader();
            }
            catch(Exception e)
            {
                if (e!=null) sqldr=null;
            }
            return sqldr;
        }
        //数据库操作连接
        public static string SqlCmd(string sql,SqlConnection connstr)
        {
            string errorstr=null;
            SqlCommand sqlcmd= new SqlCommand(sql,connstr);
            if (sqlcmd.Connection.State.ToString()=="Open") sqlcmd.Connection.Close();
            sqlcmd.Connection.Open();
            try
            {
                sqlcmd.ExecuteNonQuery();
            }
            catch(Exception e)
            {
                if (e!=null) errorstr=e.ToString();
            }
            sqlcmd.Connection.Close();
            return errorstr;
        }
    }
}

吸收了一点，剩下的打包慢慢研究!