.net课程设计(18)

Response.End(); } }

protected void imgBtnAdd_Click(object sender, ImageClickEventArgs e) {

SqlConnection conn =

SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); SqlCommand

insertCmd

=

new

SqlCommand("insert

Cource(courceID,teaID,courceName,courceTime,courceAddress,courceInfo)

values(@courceID,@teaID,@courceName,@courceTime,@courceAddress,@courceInfo)", conn); insertCmd.Parameters.Add("@courceID", SqlDbType.VarChar, 20); insertCmd.Parameters.Add("@teaID", SqlDbType.VarChar, 20); insertCmd.Parameters.Add("@courceName", SqlDbType.VarChar, 100); insertCmd.Parameters.Add("@courceTime", SqlDbType.VarChar, 20); insertCmd.Parameters.Add("@courceAddress", SqlDbType.VarChar, 50); insertCmd.Parameters.Add("@courceInfo", SqlDbType.Text); insertCmd.Parameters["@courceID"].Value = txtCourceID.Text; insertCmd.Parameters["@teaID"].Value = ddlTeacherName.SelectedValue; insertCmd.Parameters["@courceName"].Value = txtCourceName.Text; insertCmd.Parameters["@courceTime"].Value = txtTime.Text; insertCmd.Parameters["@courceAddress"].Value = txtAddress.Text; insertCmd.Parameters["@courceInfo"].Value = txtCourceInformation.Text; try {

conn.Open();

int flag = insertCmd.ExecuteNonQuery(); if (flag > 0) {

lblMessage.Text = "成功添加课程信息！"; } else {

lblMessage.Text = "添加课程信息失败，查看输入是否正确！"; } }

catch (System.Exception ee) {

Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>"); } finally {

new into