62,046
社区成员
发帖
与我相关
我的任务
分享
public bool Exsists(string UserID, string UserPwd)
{
string strSql = "select count(1) from [User] where [User]=" + UserID + " and Pwd=" + UserPwd + "";
object obj = DBHelper.ExecuteScalar(strSql.ToString(), null);
int cmdresult = Convert.ToInt32(obj);
if (cmdresult > 0)
{
return true;
}
else
{
return false;
}
}
public static Object ExecuteScalar(string cmdText, SqlParameter[] param)
{
using (SqlConnection conn = CreateConnection())
{
SqlCommand cmd = new SqlCommand(cmdText, conn);
if (param != null)
{
cmd.Parameters.AddRange(param);
}
return cmd.ExecuteScalar();
}
}