studentadd.aspx.cs

学生选课管理系统 谁想要的找我qq564633432

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class studentadd : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["userName"] == null)//如果没有登录，转向登录界面
        {
            Response.Redirect("Login.aspx");
        }
    }
    protected void imgBtnAdd_Click(object sender, ImageClickEventArgs e)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["web"]);
        SqlCommand insertsql = new SqlCommand("insert into Student(Sno,Name,Pwd,Grade,Class,Depart) values(@Sno,@Sname,@Pwd,@Grade,@Class,@Depart)", conn);
       //添加参数
        insertsql.Parameters.Add("@Sno", SqlDbType.VarChar, 20);
        insertsql.Parameters.Add("@Sname", SqlDbType.VarChar, 20);
        insertsql.Parameters.Add("@Pwd", SqlDbType.Char, 50);
        insertsql.Parameters.Add("@Grade", SqlDbType.Int, 10);
        insertsql.Parameters.Add("@Class", SqlDbType.Int, 10);
        insertsql.Parameters.Add("@Depart", SqlDbType.VarChar, 20);
        //给添加的参数赋值
        insertsql.Parameters["@Sno"].Value = txtID.Text.ToString();
        insertsql.Parameters["@Sname"].Value = txtName.Text;
        insertsql.Parameters["@Pwd"].Value = txtPwd.Text.ToString();
        insertsql.Parameters["@Grade"].Value = txtGrade.Text;
        insertsql.Parameters["@Class"].Value = txtClass.Text;
        insertsql.Parameters["@Depart"].Value = txtDepart.Text;
        try
        {
            txtID.Text = "";
            txtName.Text = "";
            conn.Open();
            int flat = insertsql.ExecuteNonQuery();
            if (flat > 0)
            {
                lblMessage.Text = "添加学生成功";
            }
            else
            {
                lblMessage.Text = "添加学生信息失败，查看输入是否正确！";
            }
        }
        catch(System.Exception ee)
        {
            lblMessage.Text = ee.Message.ToString();
            Response.Write("<script language=javascript>alert(' "+ ee.Message.ToString() +" ')</script>");
        }
        finally
        {
            conn.Close();
        }
    }
    protected void imgBtnReset_Click(object sender, ImageClickEventArgs e)
    {
        txtID.Text = "";
        txtName.Text = "";
    }
}