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(); } }