GridView的自定义分页，单选、多选、排序、自增列的简单应用

Posted on 2008-11-17 10:30 sunfei 阅读(284) 评论(0) 编辑收藏举报

1.前台代码

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

// 判断多选是否与选中项（没有选中的返回false）

function slcNo_click()

{

if (document.form1.checkboxname.length)

{

for (var i=0;i<document.form1.checkboxname.length;i++)

{

if(document.form1.checkboxname[i].checked)

{

return true;

}

else

{

if(document.form1.checkboxname.checked)

{

return true;

}

alert("请选择后再操作！");

return false;

}

// 鼠标经过改变行的颜色

if (!objbeforeItem)

{

var objbeforeItem=null;

var objbeforeItembackgroundColor=null;

}

function ItemOver(obj)

{

if(objbeforeItem)

{

objbeforeItem.style.backgroundColor = objbeforeItembackgroundColor;

}

objbeforeItembackgroundColor = obj.style.backgroundColor;

objbeforeItem = obj;

obj.style.backgroundColor = "#B9D1F3";

}

// 多选的全选与取消

function checkJs(boolvalue)

{

if(document.all.checkboxname.length>1)

{

for(var i=0;i<document.all.checkboxname.length;i++)

{

document.all.checkboxname[i].checked = boolvalue;

}

else

document.all.checkboxname.checked = boolvalue;

}

// 只有全部选中时“全选”选中

function SingleCheckJs()

{

var flag1=false;

var flag2=false;

if (document.form1.checkboxname.length)

{

for (var i=0;i<document.form1.checkboxname.length;i++)

{

if(document.form1.checkboxname[i].checked)

flag1 = true;

else

flag2 = true;

}

else

{

if(document.form1.checkboxname.checked)

flag1 = true;

else

flag2 = true;

}

if(flag1==true&&flag2==false)

document.getElementById("chk").checked = true;

else

document.getElementById("chk").checked = false;

}

</script>

</head>

<body>

<div>

<tr>

<asp:GridView ID="GridView1" runat="server" Width="100%" CellPadding="4" ForeColor="#333333"

AutoGenerateColumns="False" AllowPaging="True" PageSize="12" BorderColor="Silver"

BorderStyle="Solid" BorderWidth="1px" OnRowDataBound="GridView1_RowDataBound"

ShowFooter="True" EmptyDataText="没有数据记录！！" AllowSorting="True" OnSorting="GridView1_Sorting">

<asp:BoundField HeaderText="编号" DataField="id" Visible="False" />

<asp:TemplateField HeaderText="<input type='checkbox' id='chk' name='chk' onclick='checkJs(this.checked);' />全选" FooterText="全选">

<input type="checkbox" id="checkboxname" name="checkboxname" value='<%# DataBinder.Eval(Container.DataItem, "id")%>' onclick='SingleCheckJs();' />

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="单选" FooterText="单选">

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText="自增列" FooterText="自增列">

<%# (Container.DataItemIndex+1).ToString()%>

</ItemTemplate>

</asp:TemplateField>

<asp:BoundField HeaderText="姓名" FooterText="姓名" DataField="name" SortExpression="name" />

<asp:BoundField HeaderText="身份证号" FooterText="身份证号" DataField="card" SortExpression="card" />

<asp:BoundField HeaderText="价格" FooterText="价格" DataField="price" DataFormatString="{0:￥#,##0.00}"

HtmlEncode="False" SortExpression="price" />

<asp:BoundField HeaderText="数字" FooterText="数字" DataField="price" DataFormatString="{0:0.00}"

HtmlEncode="False" SortExpression="price" />

<asp:BoundField HeaderText="建立时间" FooterText="建立时间" DataField="createdate" DataFormatString="{0:yyyy年MM月dd日 hh时mm分ss秒}"

HtmlEncode="False" SortExpression="createdate" />

</Columns>

</asp:GridView>

</td>

</tr>

<tr>

<asp:LinkButton ID="btnFirst" CommandArgument="first" OnClick="PagerButtonClick"

runat="server">首页</asp:LinkButton>

<asp:LinkButton ID="btnPrev" CommandArgument="prev" OnClick="PagerButtonClick" runat="server">上一页</asp:LinkButton>

<asp:LinkButton ID="btnNext" CommandArgument="next" OnClick="PagerButtonClick" runat="server">下一页</asp:LinkButton>

<asp:LinkButton ID="btnLast" CommandArgument="last" OnClick="PagerButtonClick" runat="server">尾页</asp:LinkButton>

<asp:Label ID="LblCurrentIndex" runat="server"></asp:Label>

<asp:Label ID="LblPageCount" runat="server"></asp:Label>

<asp:Label ID="LblRecordCount" runat="server"></asp:Label></td>

</tr>

<tr>

<td>

<asp:Button ID="Button2" runat="server" Text="checkbox得到选择的行" OnClick="Button2_Click">

</asp:Button>

<asp:Button ID="Button1" runat="server" Text="radio得到选择的行" OnClick="Button1_Click"></asp:Button>

</td>

</tr>

</table>

</div>

</form>

</body>

</html>

2.后台代码:

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

public partial class web_testgridview2 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

Button2.Attributes["onclick"] = "return slcNo_click();";

GridViewBind("");

}

private void GridViewBind(string Sqlsort)

{

string connStr = "server=xww;database=testdb;uid=sa;pwd=admin";

string SqlStr = "Select * FROM test01 where id<1000" + Sqlsort;

DataSet ds = new DataSet();

try

{

SqlConnection conn = new SqlConnection(connStr);

if (conn.State.ToString() == "Closed") conn.Open();

SqlDataAdapter da = new SqlDataAdapter(SqlStr, conn);

da.Fill(ds, "test01");

if (conn.State.ToString() == "Open") conn.Close();

GridView1.DataSource = ds.Tables[0].DefaultView;

GridView1.DataBind();

LblCurrentIndex.Text = "第 " + (GridView1.PageIndex + 1).ToString() + " 页";

LblPageCount.Text = "共 " + GridView1.PageCount.ToString() + " 页";

LblRecordCount.Text = "总共 " + ds.Tables[0].Rows.Count.ToString() + " 条";

if (ds.Tables[0].Rows.Count == 0)

{

btnFirst.Visible = false;

btnPrev.Visible = false;

btnNext.Visible = false;

btnLast.Visible = false;

LblCurrentIndex.Visible = false;

LblPageCount.Visible = false;

LblRecordCount.Visible = false;

}

else if (GridView1.PageCount == 1)

{

btnFirst.Visible = false;

btnPrev.Visible = false;

btnNext.Visible = false;

btnLast.Visible = false;

}

// 计算生成分页页码,分别为："首页" "上一页" "下一页" "尾页"

btnFirst.CommandName = "1";

btnPrev.CommandName = (GridView1.PageIndex == 0 ? "1" : GridView1.PageIndex.ToString());

btnNext.CommandName = (GridView1.PageCount == 1 ? GridView1.PageCount.ToString() : (GridView1.PageIndex + 2).ToString());

btnLast.CommandName = GridView1.PageCount.ToString();

}

catch (Exception ex)

{

Response.Write("数据库错误，错误原因：" + ex.Message);

Response.End();

}

protected void PagerButtonClick(object sender, EventArgs e)

{

GridView1.PageIndex = Convert.ToInt32(((LinkButton)sender).CommandName) - 1;

GridViewBind("");

}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

e.Row.Attributes["onmouseover"] = "ItemOver(this)";

}

protected void Button2_Click(object sender, EventArgs e)

{

string str = "";

string[] ckb = null;

str = Request.Form.Get("checkboxname");

ckb = str.Split(new char[] { ',' });

Response.Write("直接在页面中得到的值为：" + str + "<br>");

Response.Write("处理后存放在数组中，如下：<br>");

for (int i = 0; i < ckb.Length; i++)

{

Response.Write("ckb[" + i + "]的值为：" + ckb[i] + "<br>");

}

protected void Button1_Click(object sender, EventArgs e)

{

Response.Write(Request.Form.Get("RadioName"));

}

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)

{

string sql = "";

if (ViewState["SortDirection"] == null || ViewState["SortDirection"].ToString().CompareTo("") == 0)

{

ViewState["SortDirection"] = " desc";

}

else

ViewState["SortDirection"] = "";

sql = " order by " + e.SortExpression + ViewState["SortDirection"];

GridViewBind(sql);

}

3.数据库代码:

Create TABLE [dbo].[test01] (

[id] [decimal](18, 0) IDENTITY (1, 1) NOT NULL ,

[name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[card] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[createdate] [datetime] NULL ,

[price][money] null

) ON [PRIMARY]

Alter TABLE [dbo].[test01] ADD

CONSTRAINT [DF_test01_createdate] DEFAULT (getdate()) FOR [createdate],

CONSTRAINT [PK_test01] PRIMARY KEY CLUSTERED

(

[id]

) ON [PRIMARY]

刷新页面返回顶部

sunfei

公告

GridView的自定义分页，单选、多选、排序、自增列的简单应用