Admin/ModifyCourse.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;
using System.Data.SqlClient;
public partial class Admin_ModifyCourse : System.Web.UI.Page
{
    data mydata = new data();
    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {

            
            this.DropDownList3.DataSource = mydata.GetDv("select * from Teacher");
            this.DropDownList3.DataTextField = "UserName";
            this.DropDownList3.DataValueField = "xuehao";
            this.DropDownList3.DataBind();

            GetInfo();
        }
    }
    private void GetInfo()
    {
        int id = int.Parse(Request.QueryString["id"].ToString());
        SqlDataReader dr;
        dr = mydata.GetDataReader("select * from  Course where id=" + id);
        dr.Read();
        txtName.Text = dr["courseName"].ToString();
        txtNum.Text = dr["courseID"].ToString();
        txtTerm.Text = dr["term"].ToString();
      txtCredit.Value= dr["credithour"].ToString();


   

        DropDownList3.Items.FindByValue(dr["TeacherId"].ToString()).Selected = true;
        DropDownList3.Items.FindByText(dr["teacher"].ToString()).Selected = true;


        TextBox3.Text = dr["classname"].ToString();
        TextBox1.Text = dr["Address"].ToString();
        TextBox2.Text = dr["BeginTime"].ToString();
    }
    protected void btnadd_Click(object sender, EventArgs e)
    {
        int id = int.Parse(Request.QueryString["id"].ToString());
        mydata.RunSql("update   Course set term='" + txtTerm.Text + "',courseName='" + txtName.Text + "',credithour='" + txtCredit.Value + "',classname='" + TextBox3.Text + "',Address='" + TextBox1.Text + "',BeginTime='" + TextBox2.Text + "'   where id=" + id);

        Alert.AlertAndRedirect("修改成功！", "CourseList.aspx");
    }
}