add_score.aspx.cs

程序学生信息管理系统(SQL2000+ASP.NET+c#+)

using System;
using System.Data;
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;
using System.Data.SqlClient;
using SMS;

public partial class Default2 : System.Web.UI.Page
{
    OPDataBase op = new OPDataBase();
    protected void Page_Load(object sender, EventArgs e)
    {
        
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string sql = "insert into Score2 (StudentID,Name, 计算机网络,计算机应用,[ASP.NET],[Ado.net],网页设计,Windows应用设计)values('" + TextBox1.Text.Trim() + "','" +
            TextBox2.Text.Trim() + "','" +
            TextBox3.Text.Trim() + "','" +
            TextBox4.Text.Trim() + "','" +
            TextBox5.Text.Trim() + "','" +
            TextBox6.Text.Trim() + "','" +
            TextBox7.Text.Trim() + "','" +
            TextBox8.Text.Trim() + "')";
        SqlConnection conn = new SqlConnection(op.getConnection ());
        SqlCommand cmd = new SqlCommand(sql,conn );
        conn.Open();
        try
        {
            cmd.ExecuteNonQuery();
          
            Response.Write("<script>alert('添加成功！')</script>");
        }
        catch(SqlException ex)
        {
            Label1.Text = ex.Message.ToString();
            Response.Write("<script>alert('"+ex.Message.ToString()+"')</script>");
        
        }
      
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        TextBox1.Text = "";
        TextBox2.Text = "";
        TextBox3.Text = "";
        TextBox4.Text = "";
        TextBox5.Text = "";
        TextBox6.Text = "";
        TextBox7.Text = "";
        TextBox8.Text = "";

    }
}