private void btnLogin_Click(object sender, EventArgs e)
{
int count = 0;
// 验证
string uid = txtUid.Text.Trim();
string pwd = txtPwd.Text;
if (uid.Length == 0 || pwd.Length == 0) { return; }
// 开始查询
// 1连接字符串
string connStr = @"server=.\sqlexpress;database=HeiMa8;uid=sa;pwd=123;";
// 2拼接SQL语句
string sql = "select count(*) from Exe2.loginTbl where uid='" + uid + "' and pwd='" + pwd + "';";
// string.Format("select ... where uid='{0}' and pwd='{1}';" , ...)
// 3连接对象
using (SqlConnection conn = new SqlConnection(connStr))
{
// 4执行对象
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
// 5打开数据库
conn.Open();
// 6执行
count = (int)cmd.ExecuteScalar();
}
}
// 7判断
if (count > 0)
{
MessageBox.Show("登录成功");
}
else
{
MessageBox.Show("登录失败");
}
}
{
int count = 0;
// 验证
string uid = txtUid.Text.Trim();
string pwd = txtPwd.Text;
if (uid.Length == 0 || pwd.Length == 0) { return; }
// 开始查询
// 1连接字符串
string connStr = @"server=.\sqlexpress;database=HeiMa8;uid=sa;pwd=123;";
// 2拼接SQL语句
string sql = "select count(*) from Exe2.loginTbl where uid='" + uid + "' and pwd='" + pwd + "';";
// string.Format("select ... where uid='{0}' and pwd='{1}';" , ...)
// 3连接对象
using (SqlConnection conn = new SqlConnection(connStr))
{
// 4执行对象
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
// 5打开数据库
conn.Open();
// 6执行
count = (int)cmd.ExecuteScalar();
}
}
// 7判断
if (count > 0)
{
MessageBox.Show("登录成功");
}
else
{
MessageBox.Show("登录失败");
}
}