您现在的位置: 破洛洛 >> 建站学院 >> 网站开发 >> ASP.NET >> 正文

ASP.NET实现学生管理系统

作者:佚名 来源:我爱学习网 更新时间:2015-12-29
分享到

学生管理系统所需要的具体控件和主要属性:

1、登录窗体

基本控件:

label(标签控件)

主要属性:Image(在标签上显示的图像)

Text(在标签上显示的文本)

TextBox(文本框控件)

主要属性:PasswordChar(指示在作为密码框时,文本框中显示的字符,而不是实际输入的文本)

Button(按钮控件)

ComboBox(下拉框)属性:SelectedItem:获取当前选定的项

事件:Click(单击控件时发生)

private void butStyle_Click(object sender, EventArgs e)
    {
      string str = "Data source=.;Initial catalog=Myschool;uid=sa";
      SqlConnection con = new SqlConnection(str);
      string sql = "select count(1) from student where studentName='" + txtUserName.Text + "' and LoginPwd='" + txtPwd.Text + "'";
      SqlCommand cmd = new SqlCommand(sql, con);
      try
      {
        con.Open();
        int count = Convert.ToInt32(cmd.ExecuteScalar());
        if (count > 0)
        {
         MessageBox.Show("登陆成功");
          this.Hide();
          FormMain frm = new FormMain();
          frm.Show();
        }
      }
      catch (Exception)
      {

        MessageBox.Show("退出");
      }
      finally
      {
        con.Close();
      }

Sender是事件源,表示发生了这个事件的对象,事件发生中,事件源就是按钮。

e是事件参数(EventArgs)对象,不同的事件会有不同的参数。

Close()方法是窗体类Form的一个方法,作用是关闭窗体。

2.Myschool管理员

01.给菜单栏中的“新增学生”菜单项添加事件处理程序,代码如下

private void 新增学生ToolStripMenuItem_Click(object sender, EventArgs e)
    {
      FormStudent formStudent = new FormStudent();
      formStudent.Show();
    }

02.添加学生信息

 public void Save()
    {
      //添加学生
      string pwd = txtpwd.Text;
      string stuname = textname.Text;
      //性别
      string stugender = string.Empty;
      if (radioman.Checked)
      {
        stugender = "1";
      }
      else
      {
        stugender = "0";
      }
      //下拉框绑定数据
      int gid = GeadIdName();
      //联系电话
      string StuPhone = textphone.Text;
      //地址
      string StuAddress = textAddress.Text;
      //日期
      DateTime dt = dateBirthday.Value;
      //邮箱
      string StuEmail = textEmail.Text;
      //LoginPwd, StudentName, Gender, GradeId, Phone, Address, Birthday, Email
      string sql = "insert into Student values('" + pwd + "','" + stuname + "','" + stugender + "'," + gid + ",'" + StuPhone + "','" + StuAddress + "','" + dt + "','" + StuEmail + "')";
      string str = "Data source=.;Initial catalog=Myschool;uid=sa;";
      SqlConnection con = new SqlConnection(str);
      SqlCommand cmd = new SqlCommand(sql, con);
      con.Open();
      int count = cmd.ExecuteNonQuery();
      if (count > 0)
      {
        MessageBox.Show("添加成功");         
      }
      con.Close();
    }

3.查询学生信息

//查询学生信息

    public void LodaDataListView(string sql)
    {
      string str = "data source=.;initial catalog=Myschool;uid=sa;";
      SqlConnection con = new SqlConnection(str);
      SqlCommand cmd = new SqlCommand(sql, con);
      try
      {
        con.Open();
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr != null)
        {
          if (dr.HasRows)
          {
            while (dr.Read())
            {
              int stuNo = Convert.ToInt32(dr["studentNo"]);
              //姓名
              string stuname = Convert.ToString(dr["studentName"]);
              //性别
              string stuGender = Convert.ToString(dr["Gender"]);
              //年级名次
              string stuGname = Convert.ToString(dr["Gradename"]);
              ListViewItem LvItem = new ListViewItem(stuNo.ToString());
              LvItem.SubItems.Add(stuname);
              LvItem.SubItems.Add(stuGender);
              LvItem.SubItems.Add(stuGname);
              //让lvItem和ListView关联
              lvlist.Items.Add(LvItem);
            }
            dr.Close();
          }
        }
      }
      catch (Exception)
      {

        throw;
      }
      finally
      {
        con.Close();
      }
//窗体Load的事件中调用

private void Formselect_Load(object sender, EventArgs e)
    {
      string sql = "select StudentNO,StudentName,Gender,GradeName from Student,Grade where Student.GradeId=Grade.GradeId";
      LodaDataListView(sql);
    }

修改学生信息

public void upatae()
    {
      //添加学生
      string pwd = txtpwd.Text;
      string stuname = textname.Text;
      //性别
      string stugender = string.Empty;
      if (radioman.Checked)
      {
        stugender = "1";
      }
      else
      {
        stugender = "0";
      }
      //下拉框绑定数据
      int gid = GeadIdName();
      //联系电话
      string StuPhone = textphone.Text;
      //地址
      string StuAddress = textAddress.Text;
      //日期
      DateTime dt = dateBirthday.Value;
      //邮箱
      string StuEmail = textEmail.Text;
      //LoginPwd, StudentName, Gender, GradeId, Phone, Address, Birthday, Email
      string sql = @"update Student set StudentName='" + stuname + "',Gender=" + stugender + ",GradeId='" + gid + "',phone='" + StuPhone + "',Address='" + StuAddress + "',Birthday='" + dt + "',Email='" + StuEmail
        + "' where studentNo='" + textNo.Text + "'";
      string str = "Data source=.;Initial catalog=Myschool;uid=sa;";
      SqlConnection con = new SqlConnection(str);
      SqlCommand cmd = new SqlCommand(sql, con);
      con.Open();
      int count = cmd.ExecuteNonQuery();
      if (count > 0)
      {
        frmselect.selectData();
        MessageBox.Show("修改成功");
      }
      con.Close();
    }

以上就是关于学生管理系统的实现的关键代码,希望对大家的学习有所帮助,大家可以动手制作学生管理系统,对学生管理系统功能进行扩充。

转载请注明:破洛洛(谢谢合作)
网友评论: