Gridview 使用方法大全----非常实用方法

k_lb

浏览: 798546 次
性别:
来自: 郑州

最近访客更多访客>>

u012363178

rattersnake

LuffyMother

uclnn

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

效果图：

设计代码：

<body style="text-align:center;" mce_style="text-align:center;"> <form id="form1" runat="server"> <div> 统计：你总共发布了 <asp:Label ID="lblTj" runat="server" ForeColor="#FF6600"></asp:Label> 条信息<br /> <br /> <table style="width:80%;"> <tr> <td> <table style="width:100%;"> <tr> <td> <asp:Button ID="btnCheckAll" runat="server" Text="全选" onclick="btnCheckAll_Click" /> </td> <td> <asp:Button ID="btnFanxuan" runat="server" Text="反选" onclick="btnFanxuan_Click" /> </td> <td> <asp:Button ID="Button3" runat="server" Text="批量刷新" /> </td> <td> <asp:Button ID="btnOpen" runat="server" Text="正常" onclick="btnOpen_Click" /> </td> <td> <asp:Button ID="btnClose" runat="server" Text="关闭" onclick="btnClose_Click" /> </td> <td> <asp:Button ID="btnDelete" runat="server" Text="删除" OnClientClick="return confirm('确认删除吗？')" onclick="btnDelete_Click" /> </td> <td> <asp:Label ID="lblPageIndex" runat="server" Text="1/2页"></asp:Label> </td> <td> <asp:Button ID="btnfirst" runat="server" onclick="btnfirst_Click" Text="首页" /> </td> <td> <asp:Button ID="btnPrevious" runat="server" onclick="btnPrevious_Click" Text="上一页" /> </td> <td> <asp:Button ID="btnNext" runat="server" onclick="btnNext_Click" Text="下一页" /> </td> <td> <asp:Button ID="btnLast" runat="server" onclick="btnLast_Click" Text="尾页" /> </td> </tr> </table> </td> </tr> <tr> <td> <asp:GridView ID="grvTradeList" runat="server" Width="100%" AllowPaging="True" onpageindexchanging="grvTradeList_PageIndexChanging" PageSize="2" AutoGenerateColumns="False" onrowdeleting="grvTradeList_RowDeleting" onrowediting="grvTradeList_RowEditing" onrowupdating="grvTradeList_RowUpdating" CellPadding="4" ForeColor="#333333" GridLines="None"> <PagerSettings NextPageImageUrl="~/Company/images/next.gif" /> <Columns> <asp:TemplateField> <HeaderTemplate> <asp:CheckBox ID="checkAll" runat="server" AutoPostBack="True" oncheckedchanged="checkAll" Text="全选" /> </HeaderTemplate> <ItemTemplate> <asp:CheckBox ID="Check" runat="server" /> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="ID" HeaderText="ID" /> <asp:TemplateField HeaderText="招聘岗位"> <ItemTemplate> <asp:Label ID="Label2" runat="server" ondatabinding="Label2_DataBinding" Text='<%# Eval("FLID") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="RSXQ" HeaderText="招聘人数" /> <asp:BoundField DataField="GZJY" HeaderText="工作经验" /> <asp:BoundField DataField="GZ" HeaderText="工资" DataFormatString="{0:c}" /> <asp:TemplateField HeaderText="状态"> <ItemTemplate> <asp:Label ID="Label1" runat="server" ondatabinding="Label1_DataBinding" Text='<%# Eval("ZT") %>'></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="操作"> <ItemTemplate> <asp:LinkButton ID="lkbEdit" runat="server" CommandName="edit" CommandArgument='<%# Eval("ID") %>' >编辑</asp:LinkButton> <asp:LinkButton ID="lkbRef" runat="server" CommandName="update" CommandArgument='<%# Eval("ID") %>' >刷新</asp:LinkButton> <asp:LinkButton ID="lkbDelete" runat="server" CommandName="delete" CommandArgument='<%# Eval("ID") %>' OnClientClick="return confirm('确认删除吗？')">删除</asp:LinkButton> </ItemTemplate> </asp:TemplateField> </Columns> <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <EditRowStyle BackColor="#999999" /> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> </asp:GridView> </td> </tr> <tr> <td> </td> </tr> </table> <br /> </div> </form> <p> <a href="cmp_JobsAdd.aspx" mce_href="cmp_JobsAdd.aspx">添加招聘信息》</a></p> <p> <a href="cmp_EmployeeList.aspx" mce_href="cmp_EmployeeList.aspx">员工信息列表》</a></p> </body>

CS代码：

public partial class Company_cmp_JobsList : System.Web.UI.Page { public static int PageNumber = 2;//每页记录个数 public static int PageCount;//总页数 public static int PageNow = 1;//当前页 public static int cmpid; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //Session["cmpID"] = 2; try { cmpid = Convert.ToInt32(Session["cmpID"].ToString()); } catch (Exception err) { Response.Write("<mce:script language='javascript'></mce:script>"); return; } Bind(); lblPageIndex.Text = PageNow.ToString() + "/" + PageCount.ToString() + "页"; } } //数据绑定 public void Bind() { DataSet ds = new DataSet(); ds = BLL.JZ_ZPXX.GetList("GSID=" + cmpid); grvTradeList.DataSource = ds.Tables[0]; grvTradeList.DataBind(); PageCount = ds.Tables[0].Rows.Count / PageNumber;//总页数 if ((ds.Tables[0].Rows.Count % PageNumber) != 0) { PageCount++; } if (PageCount == 0)//如果没有记录，则显示0/0页 { PageNow = 0; } lblTj.Text = ds.Tables[0].Rows.Count.ToString();//统计信息数 } //全选button protected void btnCheckAll_Click(object sender, EventArgs e) { for (int i = grvTradeList.Rows.Count - 1; i >= 0; i--) { CheckBox cb1 = (CheckBox)grvTradeList.Rows[i].FindControl("check"); cb1.Checked = true; } } //全选checkbox protected void checkAll(object sender, EventArgs e) { CheckBox cb = (CheckBox)sender; if (cb.Text == "全选") { foreach (GridViewRow gvr in grvTradeList.Rows) { CheckBox cb1 = (CheckBox)gvr.FindControl("check"); cb1.Checked = cb.Checked;//子checkbox与父checkbox相同 } } } //反选 protected void btnFanxuan_Click(object sender, EventArgs e) { for (int i = grvTradeList.Rows.Count - 1; i >= 0; i--) { CheckBox cbox = (CheckBox)grvTradeList.Rows[i].FindControl("check"); cbox.Checked = !cbox.Checked; } } //分页 protected void grvTradeList_PageIndexChanging(object sender, GridViewPageEventArgs e) { pagechange(e.NewPageIndex); PageNow = e.NewPageIndex + 1; lblPageIndex.Text = PageNow.ToString() + "/" + PageCount.ToString() + "页"; } /// <summary> /// 跳转到指定页 /// </summary> /// <param name="page">页号</param> public void pagechange(int page) { if (page < 0 || page > PageCount) { return; } grvTradeList.PageIndex = page; Bind(); } //首页 protected void btnfirst_Click(object sender, EventArgs e) { pagechange(0); if (PageCount == 0) PageNow = 0; else PageNow = 1; lblPageIndex.Text = PageNow.ToString() + "/" + PageCount.ToString() + "页"; } //上一页 protected void btnPrevious_Click(object sender, EventArgs e) { if (grvTradeList.PageIndex > 0)//不是首页 { PageNow = grvTradeList.PageIndex; lblPageIndex.Text = PageNow.ToString() + "/" + PageCount.ToString() + "页"; pagechange(grvTradeList.PageIndex - 1); } } //下一页 protected void btnNext_Click(object sender, EventArgs e) { if (PageCount != 0) { pagechange(grvTradeList.PageIndex + 1); PageNow = grvTradeList.PageIndex + 1; lblPageIndex.Text = PageNow.ToString() + "/" + PageCount.ToString() + "页"; } } //尾页 protected void btnLast_Click(object sender, EventArgs e) { pagechange(PageCount - 1); PageNow = PageCount; lblPageIndex.Text = PageNow.ToString() + "/" + PageCount.ToString() + "页"; } //删除 protected void grvTradeList_RowDeleting(object sender, GridViewDeleteEventArgs e) { BLL.JZ_ZPXX.Delete(Convert.ToInt32(grvTradeList.Rows[e.RowIndex].Cells[1].Text)); Bind(); } //编辑 protected void grvTradeList_RowEditing(object sender, GridViewEditEventArgs e) { Response.Redirect("cmp_JobsEdit.aspx?jobid=" + grvTradeList.Rows[e.NewEditIndex].Cells[1].Text); } //刷新 protected void grvTradeList_RowUpdating(object sender, GridViewUpdateEventArgs e) { Bind(); } //正常 protected void btnOpen_Click(object sender, EventArgs e) { for (int i = grvTradeList.Rows.Count - 1; i >= 0; i--) { CheckBox cb1 = (CheckBox)grvTradeList.Rows[i].FindControl("check"); if (cb1.Checked) { int id = Convert.ToInt32(grvTradeList.Rows[i].Cells[1].Text); Model.JZ_ZPXX Model_ZPXX = new Model.JZ_ZPXX(); Model_ZPXX = BLL.JZ_ZPXX.GetModel(id); Model_ZPXX.ZT = false; BLL.JZ_ZPXX.Update(Model_ZPXX); } } Bind(); } //关闭 protected void btnClose_Click(object sender, EventArgs e) { for (int i = grvTradeList.Rows.Count - 1; i >= 0; i--) { CheckBox cb1 = (CheckBox)grvTradeList.Rows[i].FindControl("check"); if (cb1.Checked) { int id = Convert.ToInt32(grvTradeList.Rows[i].Cells[1].Text); Model.JZ_ZPXX Model_ZPXX = new Model.JZ_ZPXX(); Model_ZPXX = BLL.JZ_ZPXX.GetModel(id); Model_ZPXX.ZT = true; BLL.JZ_ZPXX.Update(Model_ZPXX); } } Bind(); } //删除 protected void btnDelete_Click(object sender, EventArgs e) { for (int i = grvTradeList.Rows.Count - 1; i >= 0; i--) { CheckBox cb1 = (CheckBox)grvTradeList.Rows[i].FindControl("check"); if (cb1.Checked) { int id = Convert.ToInt32(grvTradeList.Rows[i].Cells[1].Text); BLL.JZ_ZPXX.Delete(id); } } Bind(); } //状态 protected void Label1_DataBinding(object sender, EventArgs e) { Label lb1 = (Label)sender; if (lb1.Text == "True") { lb1.Text = "关闭"; } else { lb1.Text = "正常"; } } //招聘岗位 protected void Label2_DataBinding(object sender, EventArgs e) { //这里只是显示最终招聘岗位，没有显示其父分类 Label lb2 = (Label)sender; int FLID = Convert.ToInt32(lb2.Text.Trim()); Model.JZ_GWFL Model_GWFL = new Model.JZ_GWFL(); BLL.JZ_GWFL Bll_GWFL=new BLL.JZ_GWFL(); Model_GWFL = Bll_GWFL.GetModel(FLID); if (Model_GWFL == null) { //如果不存在则不能对其进行编辑 lb2.Text = "<div style="/" mce_style="/""color:red/">该分类已经不存在，请删除这条记录</div>"; GridViewRow grvr = (GridViewRow)lb2.Parent.Parent; LinkButton lkbEdit = (LinkButton)grvr.FindControl("lkbEdit"); lkbEdit.Enabled = false; ; } lb2.Text = Model_GWFL.FLMC; } }

分享到：