Admin/StudentManage.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

public partial class Admin_StudentManage : System.Web.UI.Page
{
    SqlHelper data = new SqlHelper();
    Alert alert = new Alert();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            getinfo();
        }
    }
    protected void dlinfo_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string ID = dlinfo.DataKeys[e.RowIndex].Values[0].ToString();
        try
        {
            data.RunSql("delete  from xuesheng  where  id='" + ID + "'");
            alert.Alertjs("删除成功");
            dlinfo.EditIndex = -1;
            getinfo();
        }
        catch
        {
            alert.Alertjs("删除失败");
        }
    }
    private void getinfo()
    {
        try
        {
            string strsql = "select a.*,b.zhuanyeName from xuesheng a left join zhuanye b on a.zhuanyeID=b.ID where 1>0";
            if (this.TextBox1.Text != "") 
            {
                strsql += " and xuehao='" + this.TextBox1.Text + "'";
            }
            if (this.TextBox2.Text != "")
            {
                strsql += " and xingming='" + this.TextBox2.Text + "'";
            }
            strsql += "  order by xuehao,xingming";
            DataSet ds = data.GetDs(strsql, "ds");
            dlinfo.DataSource = ds.Tables[0];
            dlinfo.DataBind();
        }
        catch
        {
        }
    }
    protected void dlinfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        dlinfo.PageIndex = e.NewPageIndex;
        getinfo();