GridView数据绑定自带分页及分页css样式，CheckBox多选，radio单选，自增列，[bubufx分享asp.net基础]

GridView常用控件，数据量太大后分页是必要的功能，GridView功能强大，自带了分页功能，只要将AllowPaging="True"，在OnPageIndexChanging方法里简单设置就实现分页了。而且GridView也提供了很多可以设置的样式，能让你的分页看上去很和你的系统搭配。当然也可以使用css样式，将能展示更多的外观。

GridView用在对数据的管理时，CheckBox就太必要了。不多说了，上代码。IDE是VS2010，数据库是access的。

完整代码下载：

图示：

gridviewTest.aspx：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="gridviewTest.aspx.cs" Inherits="gridviewTest" %>




    
    
    


    

    

        
            
                
                    
                        <%#  (Container.DataItemIndex+1).ToString()%>
                    
                
                
                    
                        ’ onclick=’SingleCheckJs();’ />
                    
                
                
                    
                        ’ />
                    
                
                
                    
                        ’ />
                    
                
                
                
                
                
            
            
            
        
    
    

        
        

        
        

        
        
    
    

gridviewTest.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;

public partial class gridviewTest : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            dataBind();
        }
    }
    private void dataBind()
    {
        DB _db = new DB();
        string _sql = "select * from gridviewTestTable";

        DataTable _DT = _db.GetDt(_sql);

        GridView1.DataSource = _DT;
        GridView1.DataBind();
    }

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

    protected void Button1_Click(object sender, EventArgs e)
    {
        Label1.Text = Request.Form.Get("cbBubufx");

    }

    protected void Button2_Click(object sender, EventArgs e)
    {
        Label2.Text=Request.Form.Get("RadioName");
    }

    protected void Button3_Click(object sender, EventArgs e)
    {
        string str = "";

        if (GridView1.Rows.Count > 0)
        {
            for (int i = 0; i < GridView1.Rows.Count; i++)
            {
                if (((CheckBox)GridView1.Rows[i].FindControl("CheckBox1")).Checked)
                    str = str + ((CheckBox)GridView1.Rows[i].FindControl("CheckBox1")).Text+",";
            }
        }
        Label3.Text = str;
    }

}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;

using System.Data;
using System.Data.OleDb;

/// 

///DB 的摘要说明
/// 
public class DB
{
    public string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath("bubufx.mdb");

    public DataTable GetDt(string sql)
    {
        DataSet ds = new DataSet();
        OleDbConnection conn = new OleDbConnection(connStr);

        if (conn.State == ConnectionState.Closed) conn.Open();
        OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);

        da.Fill(ds);
        conn.Close();
        return ds.Tables[0];
    }

    public int RunSql(string sql)
    {
        try
        {
            OleDbConnection conn = new OleDbConnection(connStr);

            if (conn.State == ConnectionState.Closed) conn.Open();
            OleDbCommand comm = new OleDbCommand(sql, conn);

            comm.ExecuteNonQuery(); conn.Close();
            return 1;
        }
        catch { return 0; }
    }

}

完整代码下载：