Web/Admin/AdminTables.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.IO;
public partial class Web_Admin_AdminTables : System.Web.UI.Page
{
    Dbhelp dh = new Dbhelp();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["UserPower"] == null)
        {
            Response.Redirect("Admin.aspx");
            return;
        }
        DataBinit();
    }
    #region 数据绑定
    protected void DataBinit()
    {
        string sql = "select * from DownLoad where DType='Excel表格'";
        GVExcels.DataSource = dh.GetData(sql);
        GVExcels.DataBind();
    }
    #endregion
    protected void GVExcels_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
       
        string id = GVExcels.DataKeys[e.RowIndex].Value.ToString();
        string sql = "select DName from DownLoad where Id='"+id+"'";
        DataSet ds = dh.GetData(sql);
        string filename = ds.Tables[0].Rows[0][0].ToString();
        string filepath = Server.MapPath("~") + "\\DownLoad_xls\\"+filename+ ".xls";
        if (File.Exists(filepath))
        {
            File.Delete(filepath);
            sql = "delete DownLoad where Id='" + id + "'";
            if (dh.Exucte(sql) > 0)
            {
                DataBinit();
            }
        }
        else
        {
            dh.MessageShowBox("删除失败！");
        }
    }
}