shanchu.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 ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=.;Database=xueji; Integrated Security=SSPI";
        conn.Open();
        String n = "select count(*) from student where id = '" + TextBox1.Text + "'";
        SqlCommand nn = new SqlCommand(n, conn);
        int n1 = (int)nn.ExecuteScalar();
        if (n1 >= 0)
        {
            String m = "delete from student where id='" + TextBox1.Text + "'";
            SqlCommand comm = new SqlCommand(m, conn);
            comm.ExecuteNonQuery();
            Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除成功！')</script>");
        }
        else
            Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('没有此人！')</script>");
        conn.Close();

    }
}