Manger/AddStudent.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Manger_AddStudent : System.Web.UI.Page
{
    SqlHelper data = new SqlHelper();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Getxueyuan();
            GetClass();
        }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        data.RunSql("insert into Student (Name,pwd,zhuanye,xueyuanId,xueyuanName,banjiId,banjieName,tizhong,dianhua,nianling,qq,xingbie,youjian,shengao,xuehao)values('" + this.Name.Text + "','" + this.pwd.Text + "','" + this.zhuanye.Text + "'," + this.xueyuanName.SelectedValue + ",'" + this.xueyuanName.SelectedItem.Text + "'," + this.banjieName.SelectedValue + ",'" + this.banjieName.SelectedItem.Text + "','" + this.tizhong.Text + "','" + this.dianhua.Text + "','" + this.nianling.Text + "','" + this.qq.Text + "','" + this.xingbie.Text + "','" + this.youjian.Text + "','" + this.shengao.Text + "','" + this.xuehao.Text + "')");
        Alert.AlertAndRedirect("添加学生档案成功！", "Student.aspx");
    }
    private void GetClass()
    {
        banjieName.DataSource = data.GetDataReader("select * from  Class where xuyuanId="+xueyuanName.SelectedValue);
        banjieName.DataTextField = "Name";
        banjieName.DataValueField = "id";
        banjieName.DataBind();
    }
    private void Getxueyuan()
    {

        xueyuanName.DataSource = data.GetDataReader("select * from  xueyuan");
        xueyuanName.DataTextField = "Name";
        xueyuanName.DataValueField = "id";
        xueyuanName.DataBind();

    }
    protected void sf_SelectedIndexChanged(object sender, EventArgs e)
    {
        GetClass();
    }
}