GridView属性、方法和事件

GridView属性、方法和事件

1．GridView属性

GridView控件常用属性及说明如表1所示。

下面对比较重要的属性进行详细介绍。

（1）AllowPaging属性。用于获取或设置一个值，该值指示是否启用分页功能。

语法：

public virtual bool AllowPaging { get; set; }

属性值：如果启用分页功能，则为True；否则为False。默认值为False。

示例

AllowPaging属性的使用

本示例实现的是分页显示商品信息。示例运行结果如图1所示。



图1 AllowPaging属性的使用

程序代码如下。

Default.aspx页面在初始化时，将数据表中数据绑定到GridView控件中并显示出来。Default.aspx页Page_Load事件代码如下：

protected void Page_Load(object sender, EventArgs e)

{

string sqlStr = "select GoodsID as 商品ID,GoodsName as 商品名称,GoodsIntroduce as 商品介绍," + "Goods Price as 商品价格,GoodsIsNew as 是否推荐 from tb_GoodsInfo";

SqlConnection myConn = GetConnection();

SqlDataAdapter myAdapter = new SqlDataAdapter(sqlStr, myConn);

DataSet myds = new DataSet();

myConn.Open();

myAdapter.Fill(myds, "tb_GoodsInfo");

GridView1.AllowPaging = True;

GridView1.AutoGenerateColumns = True;

GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { "商品ID" };

GridView1.DataBind();

}

完整程序代码如下：

★ ★★★★Default.aspx设计文件完整程序代码★★★★★

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























分页显示商品信息



































★ ★★★★Default.aspx代码文件完整程序代码★★★★★

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 _Default : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

string sqlStr = "select GoodsID as 商品ID,GoodsName as 商品名称,GoodsIntroduce as 商品介绍,"

+ "GoodsPrice as 商品价格,GoodsIsNew as 是否推荐 from tb_GoodsInfo";

SqlConnection myConn = GetConnection();

SqlDataAdapter myAdapter = new SqlDataAdapter(sqlStr, myConn);

DataSet myds = new DataSet();

myConn.Open();

myAdapter.Fill(myds, "tb_GoodsInfo");

GridView1.AllowPaging = true;

GridView1.AutoGenerateColumns = true;

GridView1.DataSource = myds;

GridView1.DataKeyNames = new string[] { "商品ID" };

GridView1.DataBind();

}

public SqlConnection GetConnection()

{

string myStr = ConfigurationManager.AppSettings["ConnectionString"].ToString();