【Asp】Asp.net GridView使用大全(分页实现)-net-GridView

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【Asp.net GridView使用大全(分页实现)】，下面是详细的讲解！

Asp.net GridView使用大全(分页实现)

using System;
using System.Data;
using System.Configuration;
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 Default5 : System.Web.UI.Page
{
    SqlConnection sqlcon;
    string strCon="Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bind();
        }
    }
    protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
    {
        for (int i=0; i <=GridView1.Rows.Count - 1; i++)
        {
            CheckBox cbox=(CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
            if (CheckBox2.Checked==true)
            {
                cbox.Checked=true;
            }
            else
            {
                cbox.Checked=false;
            }
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        sqlcon=new SqlConnection(strCon);
        SqlCommand sqlcom;
        for (int i=0; i <=GridView1.Rows.Count - 1; i++)
        {
            CheckBox cbox=(CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
            if (cbox.Checked==true)
            {

                string sqlstr="delete from 飞狐工作室 where 身份证号码='" + GridView1.DataKeys[i].Value + "'";
                sqlcom=new SqlCommand(sqlstr, sqlcon);
                sqlcon.Open();
                sqlcom.ExecuteNonQuery();
                sqlcon.Close();
            }
        }
        bind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        CheckBox2.Checked=false;
        for (int i=0; i <=GridView1.Rows.Count - 1; i++)
        {
            CheckBox cbox=(CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
            cbox.Checked=false;
        }
    }
    public void bind()
    {
        string sqlstr="select top 5 * from 飞狐工作室";
        sqlcon=new SqlConnection(strCon);
        SqlDataAdapter myda=new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds=new DataSet();
        sqlcon.Open();
        myda.Fill(myds, "tb_Member");
        GridView1.DataSource=myds;
        GridView1.DataKeyNames=new string[] { "身份证号码" };
        GridView1.DataBind();
        sqlcon.Close();
    }
}

关于Asp.net GridView使用大全(分页实现)的用户互动如下：

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细