新手请教一个SqlParameter问题
用户表:
CREATE TABLE [dbo].[sys_user](
[ID] [int] IDENTITY(1,1) NOT NULL,
[userName] [nvarchar](50) NULL,
[userPass] [nvarchar](50) NULL,
CONSTRAINT [PK_sys_user] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
cs文件:
private void btnLogin_Click(object sender, EventArgs e)
{
var userName = txtuser.Text.Trim();
var userPass = txtPass.Text.Trim();
string sql = "SELECT count(*) FROM sys_user WHERE username=@userName AND userpass=@userPass";
SqlParameter[] pmt = new SqlParameter[] {
new SqlParameter("@userName",SqlDbType.NVarChar,50){Value=userName},
new SqlParameter("@userPass",SqlDbType.NVarChar,50){Value=userPass}
};
int r =Convert.ToInt32(SqlHelper.ExecuteNonQuery(sql, pmt));
if (r > 0)
{
MessageBox.Show("登陆成功");
}
else
{
MessageBox.Show("登陆失败");
}
}
SqlHelper文件:
public static int ExecuteNonQuery(string sql,params SqlParameter[] pms)
{
using (SqlConnection conn=new SqlConnection(conStr))
{
using (SqlCommand cmd=new SqlCommand(sql,conn))
{
if (pms !=null)
{
cmd.Parameters.AddRange(pms);
}
conn.Open();
return cmd.ExecuteNonQuery();
}
}
}
问题:
不管输入什么样的用户名称密码,总是弹出登陆失败。
快郁闷了。
请高手指点一下哪里错了?