.net课程设计(15)

}

private void GridViewBind() {

string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

string SqlStr = "SELECT Cource.*,Teacher.* FROM Cource,Teacher where Cource.teaID=Teacher.teaID order by Teacher.teaID";

DataSet ds = new DataSet();

SqlConnection conn = new SqlConnection(connStr); try {

if (conn.State.ToString() == "Closed") conn.Open();

SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn); da.Fill(ds);

GridView1.DataSource = ds.Tables[0].DefaultView; GridView1.DataBind(); }

catch (Exception ex) {

Response.Write("数据库错误，错误原因：" + ex.Message); Response.End(); } finally {

if (conn.State.ToString() == "Open") conn.Close(); } }

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {

if (((DropDownList)e.Row.FindControl("ddlTeacher")) != null) {

DropDownList ddlteacher = (DropDownList)e.Row.FindControl("ddlTeacher");

string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; string SqlStr = "SELECT * from Teacher"; DataSet ds = new DataSet();

SqlConnection conn = new SqlConnection(connStr);