Gridview 实现第一列数据鼠标点击效果,并对gridview分页,删除,完整版
为了省略数据库连接,方便演示,自己定义了dataset数据集提供演示
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindView();
InitButtons();
InitDrp();
//GvShow.AllowSorting = true;
}
}
private void BindView()
{
//DataTable dt = BindData();
//ViewState["PageCount"] = dt.Rows.Count.ToString();
//this.GvShow.DataSource = dt;
//this.GvShow.DataBind();
this.GvShow.Attributes.Add("SortExpression", "Name");
this.GvShow.Attributes.Add("SortDirection", "ASC");
BindGridView();
}
protected void GvShow_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes.Add("onmouseover", "this.setAttribute('BKC',this.style.backgroundColor);this.style.cursor='default',this.style.backgroundColor='#C6C6C6'");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=this.getAttribute('BKC');");
}
}
protected void PagerButton_Command(object sender, System.Web.UI.WebControls.CommandEventArgs e)
{
switch (e.CommandName)
{
case "begin":
this.GvShow.PageIndex = 0;
; break;
case "before":
if (this.GvShow.PageIndex > 0)
{
this.GvShow.PageIndex -= 1;
}
; break;
case "after":
if (this.GvShow.PageIndex < this.GvShow.PageCount - 1)
{
this.GvShow.PageIndex += 1;
}
; break;
case "end":
this.GvShow.PageIndex = this.GvShow.PageCount - 1;
; break;
}
BindView();
InitButtons();
}
private void InitButtons()
{
txtNowPage.Text = (this.GvShow.PageIndex + 1).ToString();
txtAllPage.Text = this.GvShow.PageCount.ToString();
txtTotal.Text = ViewState["PageCount"].ToString();
txtNowRed.Text = this.GvShow.PageSize.ToString();
this.cmdbegin.Enabled = false;
this.cmdbefore.Enabled = false;
this.cmdafter.Enabled = false;
this.cmdend.Enabled = false;
if (this.GvShow.PageCount > 1)
{
this.cmdbegin.Enabled = true;
this.cmdbefore.Enabled = true;
this.cmdafter.Enabled = true;
this.cmdend.Enabled = true;
if (this.GvShow.PageIndex == 0)
{
this.cmdbegin.Enabled = false;
this.cmdbefore.Enabled = false;
}
else if (this.GvShow.PageIndex == this.GvShow.PageCount - 1)
{
this.cmdafter.Enabled = false;
this.cmdend.Enabled = false;
}
}
}
protected void lbtnTurnNewPage_Click(object sender, EventArgs e)
{
try
{
int pageIndexNumber = Convert.ToInt32(this.txtTurn.Text.Trim());
if (pageIndexNumber > this.GvShow.PageCount)
{
Response.Write("越界!");
return;
}
else if (pageIndexNumber <= 0)
{
Response.Write("负数不灵!");
return;
}
this.GvShow.PageIndex = pageIndexNumber - 1;
BindView();
InitButtons();
}
catch
{
Response.Write("请输入数字!");
return;
}
}
// #region 下拉列表分页跳转
protected void drpPageNumbers_SelectedIndexChanged(object sender, EventArgs e)
{
DropDownList drpPageNumbers = (DropDownList)sender;
//改变GridView的页签
this.GvShow.PageIndex = Convert.ToInt32(ControlDrp);
//页签改变后,重新绑定
BindView();
InitButtons();
}
private void InitDrp()
{
this.drpPageNumbers.Items.Clear();
for (int i = 0; i < this.GvShow.PageCount; i++)
{
this.drpPageNumbers.Items.Add(new ListItem((i + 1).ToString(), i.ToString()));
}
}
private String ControlDrp
{
set
{
this.drpPageNumbers.SelectedValue = value;
}
get
{
return this.drpPageNumbers.SelectedValue;
}
}
private string GetNameById(int id) {
DataTable dt = BindData();
DataRow dr = dt.Rows[id];
string name = dr["Name"].ToString();
return name;
}
private DataTable BindData()
{
DataTable dtData = new DataTable();
dtData.Columns.Add("ID");
dtData.Columns.Add("Name");
dtData.Columns.Add("Sex");
DataRow drData;
drData = dtData.NewRow();
drData[0] = 2;
drData[1] = "zhangsan";
drData[2] = "man";
dtData.Rows.Add(drData);
drData = dtData.NewRow();
drData[0] = 4;
drData[1] = "lisi";
drData[2] = "man";
dtData.Rows.Add(drData);
drData = dtData.NewRow();
drData[0] = 3;
drData[1] = "wagnwu";
drData[2] = "man";
dtData.Rows.Add(drData);
drData = dtData.NewRow();
drData[0] = 1;
drData[1] = "xiaofang";
drData[2] = "woman";
dtData.Rows.Add(drData);
drData = dtData.NewRow();
drData[0] = 5;
drData[1] = "xiaojuan";
drData[2] = "man";
dtData.Rows.Add(drData);
drData = dtData.NewRow();
drData[0] = 6;
drData[1] = "zhaoliu";
drData[2] = "man";
dtData.Rows.Add(drData);
return dtData;
}
protected void GvShow_SelectedIndexChanged(object sender, EventArgs e)
{
GridViewRow row = GvShow.SelectedRow;
LinkButton lb = row.FindControl("lblRegionName") as LinkButton;
//现在获取到了指定控件,就可以用指定控件获取控件值,进行相关操作
}
/// <summary>
/// 实现点击排序,对Name进行排序
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GvShow_Sorting(object sender, GridViewSortEventArgs e)
{
string sortExpression = e.SortExpression.ToString();
// 假定为排序方向为“顺序”
string sortDirection = "Name DESC";
//string sortDirection = GvShow.Attributes["SortDirection"];
// “ASC”与事件参数获取到的排序方向进行比较,进行GridView排序方向参数的修改
//if (sortExpression == this.GvShow.Attributes["SortExpression"])
//{
// //获得下一次的排序状态
// sortDirection = (this.GvShow.Attributes["SortDirection"].ToString() == sortDirection ? "DESC" : "ASC");
//}
// 重新设定GridView排序数据列及排序方向
//this.GvShow.Attributes["SortExpression"] = sortExpression;
//this.GvShow.Attributes["SortDirection"] = sortDirection;
DataTable dt = new DataTable();
dt = BindData();
dt.DefaultView.Sort = sortDirection;
GvShow.DataSource = dt;
GvShow.DataBind();
//BindGridView();
}
/// <summary>
/// 删除对象事件,为了演示本例只模仿了一个删除动作,并没有对对象进行删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GvShow_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//删除成功后需跳转到当前页面
Response.Write("<script language=javascript>alert('sucessfully')</script>");
Response.Write("<script language=javascript>window.location.href='WebForm1.aspx'</script>");
}
前端页面:
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td>
<asp:GridView id="GvShow" runat="server" Width="910px" BorderColor="#F8F8F8"
BorderWidth="1px" PageSize="3"
CellPadding="1" HorizontalAlign="Center" BorderStyle="None" AllowPaging="True"
AutoGenerateColumns="False" AllowSorting="True"
onrowdeleting="GvShow_RowDeleting"
onrowdatabound="GvShow_RowDataBound" Height="132px"
onselectedindexchanged="GvShow_SelectedIndexChanged"
onsorting="GvShow_Sorting" >
<SelectedRowStyle ForeColor="#FFFF99" BackColor="#C6C6C6"></SelectedRowStyle>
<AlternatingRowStyle BackColor="#EEF2F1"></AlternatingRowStyle>
<RowStyle BackColor="White" Height="24" ></RowStyle>
<HeaderStyle Wrap="False" HorizontalAlign="Center" Height="24px" ForeColor="Black" VerticalAlign="Middle"
BackColor="#BFD5FA"></HeaderStyle>
<PagerStyle ForeColor="White" HorizontalAlign="Center" BackColor="ActiveBorder" Font-Underline="false" />
<PagerSettings Mode="Numeric" Position="Bottom" Visible="false" />
<Columns>
<asp:TemplateField HeaderText="provienceName">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle"></ItemStyle>
<ItemTemplate>
<asp:LinkButton ID="lblRegionName" runat="server" Text='<%#Eval("ID") %>' CommandName="Select"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="cityName" SortExpression="Name">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle"></ItemStyle>
<ItemTemplate>
<asp:Label ID="lblCityName" runat="server" Text='<%#Eval("Name") %>' ></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="userName">
<ItemStyle HorizontalAlign="Center" VerticalAlign="Middle"></ItemStyle>
<ItemTemplate>
<asp:Label ID="lblUserName" runat="server" Text='<%#Eval("Sex") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Opreation" ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False"
CommandName="Delete" OnClientClick='return confirm("Are you sure?")'
Text="Delete"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
<td>
<table id="tablePager" runat="server" cellSpacing="0" cellPadding="0" width="100%" align="center" border="0">
<tr>
<td vAlign="middle" align="center">『<asp:linkbutton id="cmdbegin" runat="server" CommandName="begin" OnCommand="PagerButton_Command" >首页</asp:linkbutton>』
『<asp:linkbutton id="cmdbefore" runat="server" CommandName="before" OnCommand="PagerButton_Command" >上一页</asp:linkbutton>』
『<asp:linkbutton id="cmdafter" runat="server" CommandName="after" OnCommand="PagerButton_Command" >下一页</asp:linkbutton>』
『<asp:linkbutton id="cmdend" runat="server" CommandName="end" OnCommand="PagerButton_Command" >尾页</asp:linkbutton>』
</td>
<td vAlign="middle" align="center">页次:<asp:label id="txtNowPage" runat="server" ForeColor="red">0</asp:label>/<asp:label id="txtAllPage" runat="server" ForeColor="red">0</asp:label>页
共<asp:label id="txtTotal" runat="server" ForeColor="red">0</asp:label>条记录
<asp:label id="txtNowRed" runat="server" ForeColor="red">0</asp:label>条记录/页
</td>
<td>
<asp:LinkButton ID="lbtnTurnNewPage" runat="server" Text="跳转"
οnclick="lbtnTurnNewPage_Click"></asp:LinkButton>
<asp:TextBox ID="txtTurn" runat="server" Width="20" Height="20"></asp:TextBox>
</td>
<td>
<asp:DropDownList ID="drpPageNumbers" runat="server" AutoPostBack="true"
onselectedindexchanged="drpPageNumbers_SelectedIndexChanged">
</asp:DropDownList>
</td>
</tr>
</table>
</td>
</tr>
</table>
show Cell:<asp:Label ID="Label1" runat="server"></asp:Label>
</div>
</form>
</body>