using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select * from T-Users where UserName=@UserName";
cmd.Parameters.Add(new SqlParameter("UserName", txtUserName.Text));
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
int errorTimes = reader.GetInt32(reader.GetOrdinal("ErrorTimes"));
if (errorTimes > 3)
{
MessageBox.Show("错误次数大于3次,登录失败!");
return;
}
string dbpassword = reader.GetString(reader.GetOrdinal("PassWord"));
if (dbpassword == txtPassWord.Text)
{
MessageBox.Show("登录成功!");
}
运行时提示红色附近有语法错误......
{
cmd.CommandText = "select * from T-Users where UserName=@UserName";
cmd.Parameters.Add(new SqlParameter("UserName", txtUserName.Text));
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.Read())
{
int errorTimes = reader.GetInt32(reader.GetOrdinal("ErrorTimes"));
if (errorTimes > 3)
{
MessageBox.Show("错误次数大于3次,登录失败!");
return;
}
string dbpassword = reader.GetString(reader.GetOrdinal("PassWord"));
if (dbpassword == txtPassWord.Text)
{
MessageBox.Show("登录成功!");
}
运行时提示红色附近有语法错误......
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货