adminfiles.aspx.cs

来自「本程序基于 asp.net 2.0 +sql server 2」· CS 代码 · 共 55 行

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 System.IO;
using lalablog;
public partial class admin_adminFiles : System.Web.UI.Page
{
    int id;
    string fullname;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["admin"] == null)
            Response.Redirect("adminLogin.aspx");
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
          id=Convert .ToInt32( e.Keys["id"].ToString());
          getPath();
          File.Delete(this.fullname);
    }
    private void getPath()
    { 
        String path=MapPath ("~/uploadfiles/");
        string strconn = ConfigurationManager.ConnectionStrings["dsn"].ToString();
        SqlConnection cn = new SqlConnection(strconn);
        cn.Open();
        string sql = "select upfilename from pic where id="+this.id  ;
        SqlCommand cm = new SqlCommand(sql, cn);

        try 
        {
            SqlDataReader dr = cm.ExecuteReader();
            if (dr.Read())
                this.fullname =path + dr["upfilename"].ToString(); 
        }
        catch (SqlException ex)
        { 
             myfunc my = new myfunc(ex.Message );
             Response .Write (  my.JavaMsg());
        }
        finally
        {
            cn.Close();
        }
    }
}