GridView数据绑定,删除,分页,全选,变色

 GridView数据绑定

前台：

<asp:GridView ID="grd" runat="server" AutoGenerateColumns="false" onrowdeleting="grd_RowDeleting" AllowPaging="True" onpageindexchanging="grd_PageIndexChanging" PageSize="10" onrowdatabound="grd_RowDataBound"> <Columns> <asp:TemplateField HeaderText=""> <ItemTemplate> <asp:CheckBox ID="check" runat="server" /> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="标题"> <ItemTemplate> <%#Eval("title") %> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="内容"> <ItemTemplate> <%#Eval("content") %> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText=""> <ItemTemplate> <asp:LinkButton ID="del" runat="server" CommandName="delete" CommandArgument='<%#Eval("ID") %>'>删除</asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView>

后台绑定代码：

public void bind() { using (SqlConnection conn = new SqlConnection(str)) { conn.Open(); string bind = "select ID,title,content from article order by ID"; SqlDataAdapter da = new SqlDataAdapter(bind, conn); DataSet ds = new DataSet(); da.Fill(ds); grd.DataSource = ds; grd.DataKeyNames = new string[] { "ID" }; //绑定ID字段 grd.DataBind(); } }

字段中加入一列实现的删除，对应的前台代码

  <ItemTemplate> <asp:LinkButton ID="del" runat="server" CommandName="delete" CommandArgument='<%#Eval("ID") %>'>删除</asp:LinkButton> </ItemTemplate

后台删除代码：

protected void grd_RowDeleting(object sender, GridViewDeleteEventArgs e) { using (SqlConnection conn = new SqlConnection(str)) { conn.Open(); //根据之前绑定的ID获取到要删除的ID string index=grd.DataKeys[e.RowIndex].Value.ToString(); string del = "delete from article where id=" + index; SqlCommand cmd = new SqlCommand(del, conn); cmd.ExecuteNonQuery(); bind(); } }

分页代码：

protected void grd_PageIndexChanging(object sender, GridViewPageEventArgs e) { grd.PageIndex = e.NewPageIndex; bind(); }

gridview加入checkbox实现全选删除

前台绑定代码：

<ItemTemplate> <asp:CheckBox ID="check" runat="server" /> </ItemTemplate>

外全选checkbox放在gridview外面

<asp:CheckBox ID="chekmore" runat="server" Text="全选" AutoPostBack="True" oncheckedchanged="chekmore_CheckedChanged"/> <asp:Button ID="btndel" runat="server" Text="删除选中" οnclick="btndel_Click" />

后台代码：

//此方法是实现点击全选checkbox后gridview控件的checkbox都选中。

protected void checkmore_CheckedChanged(object sender, EventArgs e) { if (chekmore.Checked) { //foreach 遍历gridview中的checkbox控件 foreach (GridViewRow g in grd.Rows) { (g.Cells[0].FindControl("check") as CheckBox).Checked = true; } } else { foreach (GridViewRow g in grd.Rows) { (g.Cells[0].FindControl("check") as CheckBox).Checked = false; } } }

还有另外一种方法，本人比较倾向：

protected void chekmore_CheckedChanged(object sender, EventArgs e) { if (chekmore.Checked) { for (int i = 0; i < grd.Rows.Count; i++) { CheckBox cbx = (CheckBox)grd.Rows[i].FindControl("check"); cbx.Checked = true; } } else { for (int i = 0; i < grd.Rows.Count; i++) { CheckBox cbx = (CheckBox)grd.Rows[i].FindControl("check"); cbx.Checked = false; } } }

实现全选删除

protected void btndel_Click(object sender, EventArgs e) { using(SqlConnection conn=new SqlConnection(str)) { for (int i = 0; i < grd.Rows.Count; i++) { CheckBox cbx = (CheckBox)grd.Rows[i].FindControl("check"); if (cbx.Checked == true) { conn.Open(); string del = "delete from article where ID=" + grd.DataKeys[i].Value; SqlCommand cmd = new SqlCommand(del, conn); cmd.ExecuteNonQuery(); conn.Close(); } } } bind(); }

双击GridView的RowDataBound事件；

鼠标移到GridView某一行时改变该行的背景色

protected void grd_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#63c157'"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c"); } }