当前文件路径：MyElectCourse/adminCourseDetails.aspx.cs 
1
using 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 adminCourseDetails : 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 Cource.*,Teacher.* FROM Cource,Teacher where Cource.teaID=Teacher.teaID order by Teacher.teaID";
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("ddlTeacher")) != null)
54 ...{
55 DropDownList ddlteacher = (DropDownList)e.Row.FindControl("ddlTeacher");
56
57 // 生成 DropDownList 的值，绑定数据
58 string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
59 string SqlStr = "SELECT * from Teacher";
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 ddlteacher.DataSource = ds.Tables[0].DefaultView;
69 ddlteacher.DataTextField = "teaName";
70 ddlteacher.DataValueField = "teaID";
71 ddlteacher.DataBind();
72 //
73
74 // 选中 DropDownList
75 ddlteacher.SelectedValue = ((HiddenField)e.Row.FindControl("hdfTeacher")).Value;
76 ddlteacher.SelectedItem.Text = ((HiddenField)e.Row.FindControl("hdfTeacher")).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 courceID = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出编辑行的主键值
96 string oldTeaID = GridView1.DataKeys[e.RowIndex].Values[1].ToString();
97 string teaID = ((DropDownList)GridView1.Rows[e.RowIndex].FindControl("ddlTeacher")).SelectedValue; //取出修改后的值
98 string courceName = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtName")).Text;
99 string courceTime = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtTime")).Text;
100 string courceAddress = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtAddress")).Text;
101
102 string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
103 string SqlStr = "update Cource set CourceName='" + courceName + "',teaID='" + teaID + "',courceTime='" + courceTime + "',courceAddress='" + courceAddress + "' where courceID='" + courceID + "' and teaID='" + oldTeaID + "'";
104
105 try
106 ...{
107 SqlConnection conn = new SqlConnection(connStr); //创建连接对象
108 if (conn.State.ToString() == "Closed") //如果连接关闭,打开连接
109 conn.Open();
110 SqlCommand comm = new SqlCommand(SqlStr, conn);
111 comm.ExecuteNonQuery(); //执行修改
112 comm.Dispose();
113 if (conn.State.ToString() == "Open") //如果连接打开,关闭连接
114 conn.Close();
115
116 GridView1.EditIndex = -1;
117 GridViewBind();
118 }
119 catch (Exception ex) //异常处理
120 ...{
121 Response.Write("数据库错误，错误原因：" + ex.Message);
122 Response.End();
123 }
124
125 }
126 protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
127 ...{
128 string id = GridView1.DataKeys[e.RowIndex].Values[0].ToString(); //取出要删除记录的主键值
129 string teaID = GridView1.DataKeys[e.RowIndex].Values[1].ToString();
130 string connStr = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString; //取出连接字符串
131 string SqlStr = "delete from Cource where courceID=" + id+" and teaID="+teaID;
132
133 try
134 ...{
135 SqlConnection conn = new SqlConnection(connStr); //创建连接对象
136 if (conn.State.ToString() == "Closed")
137 conn.Open();
138 SqlCommand comm = new SqlCommand(SqlStr, conn);
139 comm.ExecuteNonQuery(); //执行删除
140 comm.Dispose();
141 if (conn.State.ToString() == "Open")
142 conn.Close();
143
144 GridView1.EditIndex = -1;
145 GridViewBind();
146 }
147 catch (Exception ex)
148 ...{
149 Response.Write("数据库错误，错误原因：" + ex.Message);
150 Response.End();
151 }
152
153 }
154
155 //添加课程事件
156 protected void imgBtnAdd_Click(object sender, ImageClickEventArgs e)
157 ...{
158 SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);//创建连接对象
159 SqlCommand insertCmd = new SqlCommand("insert into Cource(courceID,teaID,courceName,courceTime,courceAddress,courceInfo) values(@courceID,@teaID,@courceName,@courceTime,@courceAddress,@courceInfo)", conn);
160 insertCmd.Parameters.Add("@courceID", SqlDbType.VarChar, 20);//设置参数
161 insertCmd.Parameters.Add("@teaID", SqlDbType.VarChar, 20);
162 insertCmd.Parameters.Add("@courceName", SqlDbType.VarChar, 100);
163 insertCmd.Parameters.Add("@courceTime", SqlDbType.VarChar, 20);
164 insertCmd.Parameters.Add("@courceAddress", SqlDbType.VarChar, 50);
165 insertCmd.Parameters.Add("@courceInfo", SqlDbType.Text);
166 insertCmd.Parameters["@courceID"].Value = txtCourceID.Text; //为参数赋值
167 insertCmd.Parameters["@teaID"].Value = ddlTeacherName.SelectedValue;
168 insertCmd.Parameters["@courceName"].Value = txtCourceName.Text;
169 insertCmd.Parameters["@courceTime"].Value = txtTime.Text;
170 insertCmd.Parameters["@courceAddress"].Value = txtAddress.Text;
171 insertCmd.Parameters["@courceInfo"].Value = txtCourceInformation.Text;
172 try
173 ...{
174 conn.Open();
175 int flag = insertCmd.ExecuteNonQuery(); //执行添加
176 if (flag > 0) //如果添加成功
177 ...{
178 lblMessage.Text = "成功添加课程信息！";
179 }
180 else //如果添加失败
181 ...{
182 lblMessage.Text = "添加课程信息失败，查看输入是否正确！";
183 }
184 }
185 catch (System.Exception ee)
186 ...{
187 Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");
188 }
189 finally
190 ...{
191 conn.Close();
192 GridViewBind();
193 }
194 }
195 protected void imgBtnReset_Click(object sender, ImageClickEventArgs e)
196 ...{
197 txtCourceID.Text = "";
198 txtCourceName.Text = "";
199 txtTime.Text = "";
200 txtAddress.Text = "";
201 txtCourceInformation.Text = "";
202 }
203
}
204
打包下载该项目完整源码：Asp.net简单网络选课系统源码
