public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
bool enable = true; // 默认情况注册用户是可用的
private void txtUid_Leave(object sender, EventArgs e)
{
int count = 0;
// 鼠标离开验证用户名是否可用
string uid = txtUid.Text.Trim();
if (uid.Length == 0) return;
// 开始判断用户是否存在
// select count(*) from 表名 where uid=xxx
// 1连接字符串
string connStr = @"server=.\sqlexpress;database=HeiMa8;uid=sa;pwd=123;";
// 2sql语句
string sql = "select count(*) from Exe2.LoginTbl where uid='" + uid + "'";
// 3连接对象
using (SqlConnection conn = new SqlConnection(connStr))
{
// 4执行对象
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
// 5打开数据库
conn.Open();
// 6执行SQL语句
count = (int)cmd.ExecuteScalar();
}
}
if (count > 0)
{
// 用户已存在,不能使用这个名字
lbNote.ForeColor = Color.Red;
lbNote.Text = "X 用户已存在";
enable = false;
}
else
{
// 用户不存在,可以用
lbNote.ForeColor = Color.Green;
lbNote.Text = "√";
enable = true;
}
}
private void btnReg_Click(object sender, EventArgs e)
{
int count = 0;
// 验证数据,将数据插入到数据库中
string uid = txtUid.Text.Trim();
string pwd1 = txtPwd1.Text;
string pwd2 = txtPwd2.Text;
// 非空验证
if (uid.Length == 0 || pwd1.Length == 0 || pwd2.Length == 0) return;
// 密码相同验证
if (pwd2 != pwd1) return;
// 用户名是否可用
if (!enable) return;
// 插入数据
string connStr = @"server=.\sqlexpress;database=HeiMa8;uid=sa;pwd=123;";
string sql = "insert into Exe2.LoginTbl(uid, pwd) values('" + uid + "', '" + pwd1 + "');";
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
count = cmd.ExecuteNonQuery();
}
}
if (count > 0)
{
MessageBox.Show("恭喜你,注册成功!");
}
}
}
{
public Form1()
{
InitializeComponent();
}
bool enable = true; // 默认情况注册用户是可用的
private void txtUid_Leave(object sender, EventArgs e)
{
int count = 0;
// 鼠标离开验证用户名是否可用
string uid = txtUid.Text.Trim();
if (uid.Length == 0) return;
// 开始判断用户是否存在
// select count(*) from 表名 where uid=xxx
// 1连接字符串
string connStr = @"server=.\sqlexpress;database=HeiMa8;uid=sa;pwd=123;";
// 2sql语句
string sql = "select count(*) from Exe2.LoginTbl where uid='" + uid + "'";
// 3连接对象
using (SqlConnection conn = new SqlConnection(connStr))
{
// 4执行对象
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
// 5打开数据库
conn.Open();
// 6执行SQL语句
count = (int)cmd.ExecuteScalar();
}
}
if (count > 0)
{
// 用户已存在,不能使用这个名字
lbNote.ForeColor = Color.Red;
lbNote.Text = "X 用户已存在";
enable = false;
}
else
{
// 用户不存在,可以用
lbNote.ForeColor = Color.Green;
lbNote.Text = "√";
enable = true;
}
}
private void btnReg_Click(object sender, EventArgs e)
{
int count = 0;
// 验证数据,将数据插入到数据库中
string uid = txtUid.Text.Trim();
string pwd1 = txtPwd1.Text;
string pwd2 = txtPwd2.Text;
// 非空验证
if (uid.Length == 0 || pwd1.Length == 0 || pwd2.Length == 0) return;
// 密码相同验证
if (pwd2 != pwd1) return;
// 用户名是否可用
if (!enable) return;
// 插入数据
string connStr = @"server=.\sqlexpress;database=HeiMa8;uid=sa;pwd=123;";
string sql = "insert into Exe2.LoginTbl(uid, pwd) values('" + uid + "', '" + pwd1 + "');";
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
conn.Open();
count = cmd.ExecuteNonQuery();
}
}
if (count > 0)
{
MessageBox.Show("恭喜你,注册成功!");
}
}
}