Access OleDbParameter 参数问题

string sqlstr = "select UserName,Purview from [cms_Admin] where [UserName] = @UserName AND [Password]=@Password";
             OleDbParameter[] prams = {
                 Database.MakeInParam("@Password",  OleDbType.VarChar, psw),
                 Database.MakeInParam("@UserName",  OleDbType.VarChar, UserName)
            };

代码没错就是通过不了验证 原来OleDbParameter 的顺序要一致 !

修改成这样就通过了 

OleDbParameter[] prams = {
                 Database.MakeInParam("@UserName",  OleDbType.VarChar, UserName),
                 Database.MakeInParam("@Password",  OleDbType.VarChar, psw)
               
            };