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