asp.net的GridView控件使用方法大全_.Net教程
教程Tag：暫無Tag,歡迎添加,賺取U幣!
推薦：ASP.NET站點RSS功能實現方法RSS也稱聚合，通常被用于新聞和Blog中，是基于XML的一種形式，網站提供RSS輸出，有利于讓用戶發現網站內容的更新，并在不打開網站頁面的情況下閱讀內容。 下面是如何使用ASP.NET實現該功能。 通知瀏覽器網站提供了RSS輸出：把下面的這句放在博客或這站點的he
GridView控件是asp.net開發中經常用到的控件之一，本網頁設計教程詳細介紹GridView的使用方法。前臺.aspx
| <asp:Label ID="tplb" runat="server" Text="總頁數："></asp:Label> <asp:Label ID="lblPageCount" runat="server" Text=""></asp:Label> <asp:Label ID="curLabel" runat="server" Text="當前頁："></asp:Label> <asp:Label ID="lblPage" Text="1" runat="server"></asp:Label> <asp:LinkButton ID="lblFirstButton" runat="server" OnClick="lblFirstButton_Click" >|<</asp:LinkButton> <asp:LinkButton ID="lblPreButton" runat="server" OnClick="lblPreButton_Click" ><</asp:LinkButton> <asp:LinkButton ID="lblNextButton" runat="server" OnClick="lblNextButton_Click" >></asp:LinkButton> <asp:LinkButton ID="lblLastButton" runat="server" OnClick="lblLastButton_Click" >>|</asp:LinkButton> <asp:DropDownList ID="ddlPage" runat="server" Width="40px" AutoPostBack="True" OnSelectedIndexChanged="ddlPage_SelectedIndexChanged"> <asp:ListItem>10</asp:ListItem> <asp:ListItem>15</asp:ListItem> <asp:ListItem>20</asp:ListItem> <asp:ListItem>30</asp:ListItem> </asp:DropDownList> <asp:Label ID="PageSizeLabel" runat="server" Text="條/頁"></asp:Label> |
后臺 #region分頁
| protected void BindFollowExamInfoGridView(int PersonID) { int currentpage = Convert.ToInt32(lblPage.Text); DataTable dt = new DataTable(); dt = feibf.GetByPersonIDFollowExamInfo(PersonID); //查詢指定人的隨訪信息記錄 if (dt.Rows.Count > 0) { FollowExamInfoGridView.DataSource = dt; FollowExamInfoGridView.DataBind(); PagedDataSource ps = new PagedDataSource(); ps.DataSource = dt.DefaultView; ps.AllowPaging = true; ps.PageSize = Convert.ToInt32(ddlPage.SelectedValue); lblPageCount.Text = ps.PageCount.ToString(); this.lblPreButton.Enabled = true; this.lblNextButton.Enabled = true; ps.CurrentPageIndex = currentpage - 1; if (currentpage == 1) { this.lblPreButton.Enabled = false; this.lblFirstButton.Enabled = false; } else { this.lblPreButton.Enabled = true; this.lblFirstButton.Enabled = true; } if (currentpage == ps.PageCount) { this.lblNextButton.Enabled = false; this.lblLastButton.Enabled = false; } else { this.lblNextButton.Enabled = true; this.lblLastButton.Enabled = true; } FollowExamInfoGridView.DataSource = ps; FollowExamInfoGridView.DataBind(); } } protected void lblPreButton_Click(object sender, EventArgs e) { this.lblPage.Text = Convert.ToString(Convert.ToUInt32(lblPage.Text) - 1); BindFollowExamInfoGridView(Convert.ToInt32(Request.QueryString["PersonID"])); } protected void lblNextButton_Click(object sender, EventArgs e) { this.lblPage.Text = Convert.ToString(Convert.ToUInt32(lblPage.Text) + 1); BindFollowExamInfoGridView(Convert.ToInt32(Request.QueryString["PersonID"])); } protected void lblFirstButton_Click(object sender, EventArgs e) { this.lblPage.Text = "1"; BindFollowExamInfoGridView(Convert.ToInt32(Request.QueryString["PersonID"])); } protected void lblLastButton_Click(object sender, EventArgs e) { this.lblPage.Text = lblPageCount.Text; BindFollowExamInfoGridView(Convert.ToInt32(Request.QueryString["PersonID"])); } protected void ddlPage_SelectedIndexChanged(object sender, EventArgs e) { lblPage.Text = "1"; BindFollowExamInfoGridView(Convert.ToInt32(Request.QueryString["PersonID"])); } #endregion |
排序
| Allowsort = “true” sortExpression = “ID” DataView dv = SortBindGrid(dt); #region排序 protected void FollowExamInfoGridView_Sorting(object sender, GridViewSortEventArgs e) { ViewState["sortexpression"] = e.SortExpression; if (ViewState["sortdirection"] == null) { ViewState["sortdirection"] = "asc"; } else { if (ViewState["sortdirection"].ToString() == "asc") { ViewState["sortdirection"] = "desc"; } else { ViewState["sortdirection"] = "asc"; } } BindFollowExamInfoGridView(Convert.ToInt32(HiddenPersonID.Value)); } public DataView SortBindGrid(DataTable table) { if (table != null) { DataView dv = table.DefaultView; if (ViewState["sortexpression"] != null && ViewState["sortdirection"] != null) { dv.Sort = ViewState["sortexpression"].ToString() + " " + ViewState["sortdirection"].ToString(); } return dv; } else { return null; } } #endregion |
=======自帶分頁
#region自帶分頁
| protected void FollowExamInfoGridView_PageIndexChanging(object sender, GridViewPageEventArgs e) { FollowExamInfoGridView.PageIndex = e.NewPageIndex; BindFollowExamInfoGridView(Convert.ToInt32(HiddenPersonID.Value)); } #endregion |
選中Grid View 的實現
#region實現選中行
| <SelectedRowStyle BackColor="AliceBlue" ForeColor="Gray" /> <asp:CommandField ShowSelectButton="True"/> if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Attributes.Add("onclick", "this.cells[0].childNodes[0].click()"); } protected void GridViewRegiment_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = GridViewRegiment.SelectedRow; int RegimentID = Convert.ToInt32(row.Cells[1].Text); Response.Redirect("UpdateRegimentation.aspx?RegimentID=" + RegimentID); } #endregion |
顯示顏色和刪除
| protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { //int i; //for (i = 0; i < GridViewRegiment.Rows.Count; i++) //{ if (e.Row.RowType == DataControlRowType.DataRow) { //當有編輯列時，避免出錯，要加的RowState判斷 if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate) { ((ImageButton)e.Row.Cells[2].FindControl("IBtndelete")).Attributes.Add("onclick", "javascript:return confirm(’你確認要刪除："" + e.Row.Cells[0].Text + ""嗎?’)"); } e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor=’#00A9FF’"); e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=’#E6F5FA’"); } //} } |
GridView空的處理
1 顯示無表頭的空紀錄，EmptyDataText="沒有記錄"
2 顯示表頭的空紀錄
| DataTable dt = new DataTable(); dt = feibf.GetByPersonIDFollowExamInfo(PersonID); //查詢指定人的隨訪信息記錄 DataView dv = SortBindGrid(dt); if (dt.Rows.Count > 0) { FollowExamInfoGridView.DataSource = dv; FollowExamInfoGridView.DataBind(); } else { //添加新行顯示表頭 dt.Rows.Add(dt.NewRow()); FollowExamInfoGridView.DataSource = dt; FollowExamInfoGridView.DataBind(); //處理新行 int columnCount = FollowExamInfoGridView.Rows[0].Cells.Count; //清除掉該空行的全部單元格 FollowExamInfoGridView.Rows[0].Cells.Clear(); //新建單元格對象 FollowExamInfoGridView.Rows[0].Cells.Add(new TableCell()); //合并單元格 FollowExamInfoGridView.Rows[0].Cells[0].ColumnSpan = columnCount; //設置單元格提示內容 FollowExamInfoGridView.Rows[0].Cells[0].Style.Value = "text-align:center"; FollowExamInfoGridView.Rows[0].Cells[0].Text = "此人無隨訪信息"; } |
GridView 的導出
| EnableEventValidation="false" |
#region導出
| public override void VerifyRenderingInServerForm(Control control) { } protected void BtnPrint_Click(object sender, EventArgs e) { Response.Clear(); Response.Buffer = true; Response.Charset = "GB2312"; Response.AppendHeader("Content-Disposition", "attachment;filename=FileName.xls"); // 如果設置為GetEncoding("GB2312");導出的文件將會出現亂碼�。�！ Response.ContentEncoding = System.Text.Encoding.UTF7; Response.ContentType = "application/ms-excel";//設置輸出文件類型為excel文件。 System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); this.AfficheGV.RenderControl(oHtmlTextWriter); Response.Output.Write(oStringWriter.ToString()); Response.Flush(); Response.End(); } #endregion |
ToolTip GridView詳細信息的顯示
前臺
| <script type="text/javascript" > function Tooltip(cella,cellb) { document.getElementById("dc").innerText = "詳細信息："+cellb; document.getElementById("id").innerText = "ID："+cella; x= event.clientX+document.body.scrollLeft; y=event.clientY+document.body.scrollTop+20; toolTipLayer.style.display="inline"; toolTipLayer.style.left=x; toolTipLayer.style.top=y; } </script> <div id="toolTipLayer" style=" position:absolute; display:none; background-color:Aqua; border-color:Blue; border-style:solid; border-color:Blue; border-width:1px; " > <table> <tr><td>Affiche</td></tr> <tr><td id ="dc"></td></tr> <tr><td id ="id"> </td></tr> </table> </div> |
后臺
| protected void AfficheGV_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate) { 1 e.Row.Attributes.Add("onmouseover", "Tooltip(’" +e.Row.Cells[0].Text.ToString()+ "’,’"+e.Row.Cells[1].Text.ToString()+"’)"); 2 e.Row.Attributes.Add("onmouseover","javascript:Tooltip(’e.Row.Cells[0].Text’);"); 3 e.Row.Attributes.Add("onmouseover", "Tooltip(’e.Row.Cells[0].Text’)"); } } } |
#region自帶編輯
| protected void GVAffiche_RowEditing(object sender, GridViewEditEventArgs e) { GVAffiche.EditIndex = e.NewEditIndex; BindGVAffiche(); } protected void GVAffiche_RowDeleting(object sender, GridViewDeleteEventArgs e) { GVAffiche.EditIndex = -1; MyAffiche.DelAfficeBF( Convert.ToInt32(GVAffiche.DataKeys[e.RowIndex].Value.ToString())); BindGVAffiche(); } protected void GVAffiche_RowUpdating(object sender, GridViewUpdateEventArgs e) { int id = Convert.ToInt32(((TextBox)(GVAffiche.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim()); string dc = ((TextBox)(GVAffiche.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim(); MyAffiche.UpdateAfficheBf(id,dc); GVAffiche.EditIndex = -1; BindGVAffiche(); } protected void GVAffiche_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) { GVAffiche.EditIndex = -1; BindGVAffiche(); } #endregion |
#region樣式的控制
| protected void GVAffiche_RowDataBound(object sender, GridViewRowEventArgs e) { //首先判斷是否是數據行 if (e.Row.RowType == DataControlRowType.DataRow) { //當有編輯列時，避免出錯，要加的RowState判斷 if (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate) { ((Button)e.Row.Cells[7].FindControl("btnDel")).Attributes.Add("onclick","javascript:return confirm(’你確認刪除："" + e.Row.Cells[1].Text + ""’)"); //當鼠標停留時更改背景色 e.Row.Attributes.Add("onmouseover", "color=this.style.backgroundColor;this.style.backgroundColor=’#00A9FF’"); //當鼠標移開時還原背景色 e.Row.Attributes.Add("onmouseout","this.style.backgroundColor=color"); GVAffiche.Attributes.Add("style", "word-break:keep-all;word-wrap:normal"); //GVAffiche.Attributes.Add("style", "word-break:break-all;word-wrap:break-word"); if (e.Row.Cells[1].Text == "444") { e.Row.Cells[1].BackColor = System.Drawing.Color.Red; } } } } #endregion |
以上是GridView控件的一些基礎使用大全，希望對大家有所用處。
分享：asp.net使用存儲過程實現用戶登錄cs代碼如下 stringUserName=txtUserName.Text.ToString(); stringPassWord=txtPassWord.Text.ToString(); PassWord=FormsAuthentication.HashPasswordForStoringInConfigFile(PassWord,md5).ToLower().Substring(8,16); SqlParameter[]par=newSqlParameter
相關.Net教程：
- asp.net如何得到GRIDVIEW中某行某列值的方法
- .net SMTP發送Email實例(可帶附件)
- js實現廣告漂浮效果的小例子
- asp.net Repeater 數據綁定的具體實現
- Asp.Net 無刷新文件上傳并顯示進度條的實現方法及思路
- Asp.net獲取客戶端IP常見代碼存在的偽造IP問題探討
- VS2010 水晶報表的使用方法
- ASP.NET中操作SQL數據庫(連接字符串的配置及獲取)
- asp.net頁面傳值測試實例代碼
- DataGridView - DataGridViewCheckBoxCell的使用介紹
- asp.net中javascript的引用(直接引入和間接引入)
- 三層+存儲過程實現分頁示例代碼
- 相關鏈接：
- 教程說明：
.Net教程-asp.net的GridView控件使用方法大全
。