当前文件路径：MyElectCourse/adminTeacherAdd.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 adminTeacherAdd : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17
18    }
19    protected void btnAdd_Click(object sender, EventArgs e)
20    ...{
21       
22    }
23    protected void btnReset_Click(object sender, EventArgs e)
24    ...{
25        
26    }
27    //添加按钮事件
28    protected void imgBtnAdd_Click(object sender, ImageClickEventArgs e)
29    ...{
30        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);//创建连接对象
31        SqlCommand insertCmd = new SqlCommand("insert into Teacher(teaID,teaPwd,teaName,teaDepart) values(@teaID,@teaPwd,@teaName,@teaDepart)", conn);
32        insertCmd.Parameters.Add("@teaID", SqlDbType.VarChar, 15);//设置参数
33        insertCmd.Parameters.Add("@teaPwd", SqlDbType.VarChar, 20);
34        insertCmd.Parameters.Add("@teaName", SqlDbType.VarChar, 10);
35        insertCmd.Parameters.Add("@teaDepart", SqlDbType.Int, 4);
36        insertCmd.Parameters["@teaID"].Value = txtID.Text; //为参数赋值
37        insertCmd.Parameters["@teaPwd"].Value = txtID.Text;
38        insertCmd.Parameters["@teaName"].Value = txtName.Text;
39        insertCmd.Parameters["@teaDepart"].Value = int.Parse(ddlDepart.SelectedValue);
40        try
41        ...{
42            conn.Open();
43            int flag = insertCmd.ExecuteNonQuery(); //执行添加
44            if (flag > 0) //如果添加成功
45            ...{
46                lblMessage.Text = "成功添加教师信息！";
47            }
48            else //如果添加失败
49            ...{
50                lblMessage.Text = "添加教师信息失败，查看输入是否正确！";
51            }
52        }
53        catch (System.Exception ee)
54        ...{
55            Response.Write("<script language=javascript>alert('" + ee.Message.ToString() + "')</script>");
56        }
57        finally
58        ...{
59            conn.Close();
60        }
61    }
62    protected void imgBtnReset_Click(object sender, ImageClickEventArgs e)
63    ...{
64        txtID.Text = "";
65        txtName.Text = "";
66    }
67}
68