deletedata.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 System.IO;
//该源码首发自www.51aspx.com(５1ａｓｐｘ．ｃｏｍ)

public partial class DeleteData : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
           
            if (Session["userID"] == null || Session["userID"].ToString() == "")
            {

                Page.Response.Redirect("default.aspx");
            }
            else
            {
                dataBind();
            }
            if (GridView1.Rows.Count == 0)
            {

                Page.ClientScript.RegisterStartupScript(Page.GetType(), "script", "alert('没有数据!');", true);
            }
        }
    }
   
    private void dataBind()
    {
        string ID = Session["userId"].ToString();

        string sql2 = "select * from addresslist where userId='" + ID + "' order by id desc";
        DataBase DB2 = new DataBase();
        DataSet ds2 = DB2.DataAll(sql2);
        GridView1.DataKeyNames = new string[] { "id" };
        GridView1.DataSource = ds2;
        GridView1.DataBind();
        return;


    }

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        int yid = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value);
        string imgname = DataBase.Getfield("select frdImageUrl from AddressList where id=" + yid, "frdImageUrl");
        if (imgname != "")
        {
            if (DataBase.DataTypes(yid, "@id", "Deletephoto"))
            {
                imgname = imgname.Substring(imgname.LastIndexOf("/") + 1);
                File.Delete(Server.MapPath("./Pictures") + "//" + imgname);
                Response.Write("<script language=javascirpt type='text/javascript'>");
                Response.Write("window.alert('图片及信息删除成功！')");
                Response.Write("</script>");

            }
            else
            {
                Response.Write("<script language=javascirpt type='text/javascript'>");
                Response.Write("window.alert('图片删除失败！')");
                Response.Write("</script>");

            }
           
        }
        else
        {
            imgname = "空的哦！";
            File.Delete(Server.MapPath("./Pictures") + "//" + imgname);
            Response.Write("<script language=javascirpt type='text/javascript'>");
            Response.Write("window.alert('图片及信息删除成功！')");
            Response.Write("</script>");
        
       }

            string sql = "delete from addresslist where id=" + yid;
            SqlCommand cmd = new SqlCommand(sql, conn);
            conn.Open();
            cmd.ExecuteNonQuery();
            dataBind();
            conn.Close();

        
    }

    protected void Btnretrusive_Click(object sender, EventArgs e)
    {
        if (GridView1.Rows.Count == 0)
        {

            Page.ClientScript.RegisterStartupScript(Page.GetType(), "script", "alert('没有数据!');", true);
        }
        else
        {
            GridView1.PageIndex = GridView1.PageCount - 1;
            dataBind();
            lblmsg.Text = "共计" + GridView1.PageCount + "页，现在已经是尾页了";
        }
    }
    protected void BtnfirstPage_Click(object sender, EventArgs e)
    {
        GridView1.PageIndex = 0;
        dataBind();
        lblmsg.Text = "共计" + GridView1.PageCount + "页，现在已经是首页了";
    }
    protected void Btngoup_Click(object sender, EventArgs e)
    {
        if (GridView1.PageIndex != 0)
        {
            GridView1.PageIndex--;
            lblmsg.Text = "共计" + GridView1.PageCount + "页";

            
        }
        else
        {
            GridView1.PageIndex = 0;
            lblmsg.Text = "共计" + GridView1.PageCount + "页，现在已经是首页了";
        
        }
        dataBind();
    }
    protected void Btndescend_Click(object sender, EventArgs e)
    {
        if (GridView1.PageIndex != GridView1.PageCount-1)
        {
            GridView1.PageIndex++;
            lblmsg.Text = "共计" + GridView1.PageCount + "页";


        }
        else
        {
            GridView1.PageIndex = GridView1.PageCount-1;
            lblmsg.Text = "共计" + GridView1.PageCount + "页，现在已经是尾页了";

        }
        dataBind();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        dataBind();
    }
}