readerguanli.aspx.cs

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

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

public partial class readerguanli : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DataBind();
        }
    }
    public void DataBind()
    {
        DataSet ds = new DataSet();
        using (SqlConnection sqlconn = DB.con())
        {
            SqlDataAdapter sqld = new SqlDataAdapter("select * from reader order by jieshu desc", sqlconn);
            sqld.Fill(ds);
        }

        string[] key = { "no" };
        gvreaderguanli.DataKeyNames = key;
        //GridView绑定数据源
        gvreaderguanli.DataSource = ds.Tables[0].DefaultView;//指定GridView的数据源
        gvreaderguanli.DataBind();
    }
    protected void gvreaderguanli_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvreaderguanli.PageIndex = e.NewPageIndex;
        DataBind();
    }
    protected void gvreaderguanli_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        SqlConnection sqlconn = DB.con();
        sqlconn.Open();
        string sql = "delete from reader where no='" + gvreaderguanli.DataKeys[e.RowIndex].Value.ToString() + "'";
        SqlCommand comm = new SqlCommand(sql, sqlconn);
        comm.ExecuteNonQuery();
        sqlconn.Close();
        sqlconn = null;
        comm = null;
        gvreaderguanli.EditIndex = -1;
        DataBind();
    }
}