Admin/ModifyTeachter.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

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;
using System.Data.SqlClient;
public partial class Admin_ModifyTeachter : System.Web.UI.Page
{
    Alert alert = new Alert();
    data data = new data();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            DropDownList2.DataSource = data.GetDataReader("select * from  Xueyuan");
            DropDownList2.DataTextField = "Name";
            DropDownList2.DataValueField = "id";
            DropDownList2.DataBind();
            DropDownList3.DataSource = data.GetDataReader("select * from  zhuanye ");
            DropDownList3.DataTextField = "name";
            DropDownList3.DataValueField = "id";
            DropDownList3.DataBind();
            GetInfo();
        }
    }
    private void GetInfo()
    {
        int id = int.Parse(Request.QueryString["id"].ToString());
        SqlDataReader dr;
        dr = data.GetDataReader("select * from  Teacher where id=" + id);
        dr.Read();
        txtname.Text = dr["UserName"].ToString();

        txtemal.Text = dr["emal"].ToString();
        txtds.Text = dr["Ds"].ToString();

        DropDownList1.Items.FindByText(dr["Sex"].ToString()).Selected = true;

        DropDownList3.Items.FindByValue(dr["zhuanyeId"].ToString()).Selected = true;
        DropDownList3.Items.FindByText(dr["ZhuanyeName"].ToString()).Selected = true;
        DropDownList2.Items.FindByValue(dr["xueyuanId"].ToString()).Selected = true;
        DropDownList2.Items.FindByText(dr["XueyuanName"].ToString()).Selected = true;
        txtxuehao.Text = dr["xuehao"].ToString();
        txttime1.Value = dr["chushengriqi"].ToString();
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        int id = int.Parse(Request.QueryString["id"].ToString());
        data.RunSql("update   Teacher set emal='" + txtemal.Text + "',UserName='" + txtname.Text + "',Ds='" + txtds.Text + "',Sex='" + DropDownList1.SelectedItem.Text + "',xuehao='" + txtxuehao.Text + "',chushengriqi='" + txttime1.Value + "',zhuanyeId='" + DropDownList3.SelectedValue + "', ZhuanyeName='" + DropDownList3.SelectedItem.Text + "',xueyuanId='" + DropDownList2.SelectedValue + "',XueyuanName='"+DropDownList2.SelectedItem.Text+"' where id=" + id);

        Alert.AlertAndRedirect("修改成功！", "Teacher.aspx");
    }
    protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
    {