private void button2_Click(object sender, EventArgs e)
{
Rno.Clear();
Lno.Clear();
Date.Clear();
Redate.Clear();
}
private void button2_Click(object sender, EventArgs e)
{
Lno.Clear();
Lname.Clear();
Wr.Clear();
// Lpress.Clear();
Lbz.Clear();
Ldate.Clear();
}
public void button1_Click(object sender, EventArgs e)
{
if (Lno.Text != "" && Lpwd.Text != "")
{
string strCon = "Data Source=.\\sqlexpress;Initial Catalog=JXGL;Integrated Security=True";
SqlConnection mycon = new SqlConnection(strCon);
mycon.Open();
//创建查询命令
using (SqlCommand mycmd = mycon.CreateCommand())
{
Uno = Lno.Text;
mycmd.Parameters.Add("@uno", SqlDbType.VarChar).Value = Uno;
//查询学号
mycmd.CommandText = "select * from T_Student where Sno=@uno";
//保存查询到的数据在reader这个变量
using (SqlDataReader reader = mycmd.ExecuteReader())
{
if (reader.Read())
{
//获取该用户对应的密码
string ckPwd = reader.GetString(reader.GetOrdinal("Spwd"));
//判断密码
if (Lpwd.Text == ckPwd)
{
Form1 formMain = new Form1(this);
this.Hide();
formMain.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("密码错误！");
Lpwd.Focus();
}
}
else
{
MessageBox.Show("该用户不存在！");
Lno.Focus();
}
}
}
}
else
{
MessageBox.Show("请填写用户名与密码！");
Lno.Focus();
}
}
