当前文件路径：MyElectCourse/adminTeacherDetails.aspx.cs

		            
  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11using System.Data.SqlClient;
 12
 13public partial class adminTeacherDetails : System.Web.UI.Page
 14...{
 15    protected void Page_Load(object sender, EventArgs e)
 16    ...{
 17        if (!IsPostBack)
 18        ...{
 19            GridViewBind();
 20        }
 21    }
 22    //GridView绑定数据方法
 23    private void GridViewBind()
 24    ...{
 25        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
 26        string SqlStr = "SELECT Teacher.*,Depart.* FROM Teacher ,Depart where Teacher.teaDepart=Depart.departID order by Teacher.teaDepart";
 27        DataSet ds = new DataSet();
 28        SqlConnection conn = new SqlConnection(connStr);
 29        try
 30        ...{
 31            if (conn.State.ToString() == "Closed")
 32                conn.Open();
 33            SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);
 34            da.Fill(ds);
 35
 36            GridView1.DataSource = ds.Tables[0].DefaultView;
 37            GridView1.DataBind();
 38        }
 39        catch (Exception ex)
 40        ...{
 41            Response.Write("数据库错误，错误原因：" + ex.Message);
 42            Response.End();
 43        }
 44        finally
 45        ...{
 46            if (conn.State.ToString() == "Open")
 47                conn.Close();
 48        }
 49    }
 50
 51    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
 52    ...{
 53        if (((DropDownList)e.Row.FindControl("ddlDepart")) != null)
 54        ...{
 55            DropDownList ddldepart = (DropDownList)e.Row.FindControl("ddlDepart");
 56
 57            //  生成 DropDownList 的值，绑定数据
 58            string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
 59            string SqlStr = "SELECT * from Depart";
 60            DataSet ds = new DataSet();
 61
 62            SqlConnection conn = new SqlConnection(connStr);
 63            if (conn.State.ToString() == "Closed") conn.Open();
 64            SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);
 65            da.Fill(ds);
 66            if (conn.State.ToString() == "Open") conn.Close();
 67
 68            ddldepart.DataSource = ds.Tables[0].DefaultView;
 69            ddldepart.DataTextField = "departName";
 70            ddldepart.DataValueField = "departID";
 71            ddldepart.DataBind();
 72            //
 73
 74            //  选中 DropDownList
 75            ddldepart.SelectedValue = ((HiddenField)e.Row.FindControl("hdfDepart")).Value;
 76            ddldepart.SelectedItem.Text = ((HiddenField)e.Row.FindControl("hdfDepart")).Value;
 77            //
 78        }
 79
 80    }
 81    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
 82    ...{
 83        GridView1.EditIndex = e.NewEditIndex;  //GridView编辑项索引等于单击行的索引
 84        GridViewBind();
 85
 86    }
 87    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
 88    ...{
 89        GridView1.EditIndex = -1;
 90        GridViewBind();
 91
 92    }
 93    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
 94    ...{
 95        string teaid = GridView1.DataKeys[e.RowIndex].Values[0].ToString();   //取出编辑行的主键值
 96        string teaName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtName")).Text;   //取出修改后的值
 97        int teaDepart = int.Parse(((DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlDepart")).SelectedValue);
 98        
 99
100        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
101        string SqlStr = "update Teacher set teaName='" + teaName + "',teaDepart='" + teaDepart + "' where teaID=" + teaid;
102
103        try
104        ...{
105            SqlConnection conn = new SqlConnection(connStr);  //创建连接对象
106            if (conn.State.ToString() == "Closed")   //如果连接关闭,打开连接
107                conn.Open();
108            SqlCommand comm = new SqlCommand(SqlStr, conn);
109            comm.ExecuteNonQuery();     //执行修改
110            comm.Dispose();
111            if (conn.State.ToString() == "Open")  //如果连接打开,关闭连接
112                conn.Close();
113
114            GridView1.EditIndex = -1;
115            GridViewBind();
116        }
117        catch (Exception ex)  //异常处理
118        ...{
119            Response.Write("数据库错误，错误原因：" + ex.Message);
120            Response.End();
121        }
122
123    }
124    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
125    ...{
126        string id = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出要删除记录的主键值
127        string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; //取出连接字符串
128        string SqlStr = "delete from Teacher where teaID=" + id;
129
130        try
131        ...{
132            SqlConnection conn = new SqlConnection(connStr);  //创建连接对象
133            if (conn.State.ToString() == "Closed")
134                conn.Open();
135            SqlCommand comm = new SqlCommand(SqlStr, conn);
136            comm.ExecuteNonQuery();          //执行删除
137            comm.Dispose();
138            if (conn.State.ToString() == "Open")
139                conn.Close();
140
141            GridView1.EditIndex = -1;
142            GridViewBind();
143        }
144        catch (Exception ex)
145        ...{
146            Response.Write("数据库错误，错误原因：" + ex.Message);
147            Response.End();
148        }
149
150    }
151}
152