deletedata.aspx.cs

开发工具：Visual Studio 2005 开发平台：Windows XP sp2 数据库：Sql server 2000 从学校走入社会

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;

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)
    {
        
        int yid=(int)GridView1.DataKeys[e.RowIndex].Value;
        string sql = "delete from addresslist where id=" + yid;
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);
        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();
    }
}