代码 public bool ValidateUser(string txtUser,string txtPwd,ref string message )
{
string sql = string.Format("SELECT COUNT(*) FROM User WHERE ID='{0}'AND Pwd='{1}'",txtUser , txtPwd );
try
{
// 创建command命令
SqlCommand command = new SqlCommand(sql, DBHekper.connetion);
DBHekper.connetion.Open();
int count = (int)command.ExecuteNonQuery();//统计返回值
if (count ==1)
{
return true;
}
else
{
message = "用户名或密码不存在!";
return false;;
} }
catch (Exception ex)
{
message = "操作数据库出错";
Console.WriteLine(ex.Message);
}
finally
{
DBHekper.connetion.Close();
}
return false;
}
每次在都在这里抛出异常 说是User附近语法错误。我都快崩溃了
下面是数据库的表。
{
string sql = string.Format("SELECT COUNT(*) FROM User WHERE ID='{0}'AND Pwd='{1}'",txtUser , txtPwd );
try
{
// 创建command命令
SqlCommand command = new SqlCommand(sql, DBHekper.connetion);
DBHekper.connetion.Open();
int count = (int)command.ExecuteNonQuery();//统计返回值
if (count ==1)
{
return true;
}
else
{
message = "用户名或密码不存在!";
return false;;
} }
catch (Exception ex)
{
message = "操作数据库出错";
Console.WriteLine(ex.Message);
}
finally
{
DBHekper.connetion.Close();
}
return false;
}
每次在都在这里抛出异常 说是User附近语法错误。我都快崩溃了
下面是数据库的表。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货