xiugai.aspx.cs

学籍管理系统能够完成对学生信息的填加,删除,修改等功能.

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;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
  
    }



    protected void Button2_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data source=.;Database=xueji;Integrated Security=SSPI";
        conn.Open();
        string sql = "update student set id='" + TextBox1.Text + "',name='" + TextBox2.Text + "',sex='" + RadioButtonList1.SelectedValue + "',adress='" + TextBox3.Text + "',birth='" + DropDownList1.SelectedValue + DropDownList2.SelectedValue + DropDownList3.SelectedValue + "',sfid='" + TextBox4.Text + "',adept='" + TextBox5.Text + "',subject='" + TextBox6.Text + "',class1='" + TextBox7.Text + "',email='" + TextBox8.Text + "',tel='" + TextBox9.Text + "',beizhu='" + TextBox10.Text + "' where id='" + TextBox10.Text + "'";
        SqlCommand comm = new SqlCommand(sql, conn);
        comm.ExecuteNonQuery();
        conn.Close();
        Response.Write ("<script>alert('修改成功!')</script>");

    }
}