users_del.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;
using jianke;

public partial class Users_del : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        
            //string m = this.TextBox1.Text;
            //System.Text.StringBuilder scriptString = new System.Text.StringBuilder();
            //scriptString.Append("<script language=JavaScript>");
            //scriptString.Append("function Del_user(){");
            //scriptString.Append("return confirm('确定要删除用户: " + m + "吗?');}");
            //scriptString.Append("</script>");
            //string js = scriptString.ToString();


            //if (!IsClientScriptBlockRegistered("Del_user"))
            //{
            //    RegisterClientScriptBlock("Del_user", js);
            //}
            //Button1.Attributes.Add("onclick", "return Del_user()");
        
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        this.TextBox1.Text = "";
    }
    protected void Button1_Click(object sender, EventArgs e)
    {


        SqlConnection Conn = DB.creatconnection();
        Conn.Open();

        
            string mysql = "select Users_id from Users where Users_id='" + TextBox1.Text + "'";
            SqlCommand cm = new SqlCommand(mysql, Conn);
            SqlDataReader dr = cm.ExecuteReader();
            if (dr.Read())
            {
                dr.Close();


                String h = "DELETE FROM Users where  Users_id='" + this.TextBox1.Text + "'";
                SqlCommand activecm = new SqlCommand(h, Conn);
                activecm.ExecuteNonQuery();
                Conn.Close();

                Response.Write("<script>alert('删除成功！');</script>");
                this.TextBox1.Text = "";
            }
            else
            {
                dr.Close();
                Response.Write("<script>alert('该用户不存在！');</script>");
            }

    }
}