datalist.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.Sql;
using System.Data.SqlClient;

using System.Xml;
using System.Text;
using System.Drawing;
using System.IO;
using System.Web.SessionState;   

public partial class backup_datalist : System.Web.UI.Page
{
    SqlConnection conn = new SqlConnection("server=ck;uid=sa;pwd=sa;database=91");
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
           
            binddatalist();
            
           } 
       }


    protected void binddatalist()
    {
        

        SqlDataAdapter a = new SqlDataAdapter("select * from ZhouQinfo", conn);
        conn.Open();
        DataSet ds = new DataSet();
        a.Fill(ds, "ZhouQinfo");
      
        System.Web.UI.WebControls.PagedDataSource pa = new PagedDataSource();
        pa.AllowPaging = true;//允许分页
        pa.PageSize = 2;//每页显示5条记录
        pa.CurrentPageIndex = Convert.ToInt32(this.currPage.Text) - 1;//当前页为
        pa.DataSource = ds.Tables["ZhouQinfo"].DefaultView;
        DataList1.DataSource = pa;
        currPage.Text = (pa.CurrentPageIndex + 1).ToString(); //当前页的提示信息            

        if (pa.CurrentPageIndex < 1)
        {
           btnPre.Enabled = false;//前一页
            btnNext.Enabled = true;//后一页
        }
        else if (pa.CurrentPageIndex == pa.PageCount - 1)
        {
            btnNext.Enabled = false;
            btnPre.Enabled = true;
        }
        else
        {
            btnNext.Enabled = true;
            btnPre.Enabled = true;
        }

        countPage.Text = pa.PageCount.ToString();//一共几页
        if (pa.PageCount == 1)
        {
           btnNext.Enabled = false;
            btnPre.Enabled = false;
        }
        DataList1.DataBind();
        conn.Close();
  }
  protected void btnPre_Click(object sender, EventArgs e)//前一页
  {
      currPage.Text = Convert.ToString(Convert.ToInt32(this.currPage.Text) - 1);

      binddatalist();
  }
  protected void btnNext_Click(object sender, EventArgs e)//下一页
  {
     currPage.Text = Convert.ToString(Convert.ToInt32(this.currPage.Text) + 1);

      binddatalist();

  }
    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName == "lx")
        {
            LinkButton Label3 = (LinkButton)e.Item.FindControl("btxx");

            Label1.Text = Label3.CommandArgument;
        }

        else if (e.CommandName == "bh")
        {
            Button label4 = (Button)e.Item.FindControl("DELTE");

            string cmdString = "delete from ZhouQinfo where ZhouQH=" + label4.CommandArgument;
            SqlCommand myCommand = new SqlCommand(cmdString, conn);
            conn.Open();
             try
        {
            myCommand.ExecuteNonQuery();

           

        }
        catch (Exception err)
        {
            Response.Write("<script>alert('删除失败')</script>");
        }

        finally
        {
           conn.Close();
        }

 binddatalist();

        }
    }

    protected void Button1_Click1(object sender, EventArgs e)
    {
        string num = "";


        foreach (Control c in DataList1.Controls)
        {
            CheckBox chk = (CheckBox)c.FindControl("CheckBox1");
            if (chk.Checked)
                num += chk.Text + "<br>";
        }
        Label2.Text =num; 
    }
    protected void edit(object Sender, DataListCommandEventArgs e)
    {
        DataList1.EditItemIndex = e.Item.ItemIndex;

        DataList1.DataBind();
    }
}