主頁(yè) > 知識(shí)庫(kù) > asp.net的GridView控件使用方法大全

asp.net的GridView控件使用方法大全

熱門(mén)標(biāo)簽:戶(hù)外地圖標(biāo)注軟件手機(jī)哪個(gè)好用 鄭州400電話(huà)辦理 聯(lián)通 智能電話(huà)營(yíng)銷(xiāo)外呼系統(tǒng) 凱立德導(dǎo)航官網(wǎng)地圖標(biāo)注 電銷(xiāo)語(yǔ)音自動(dòng)機(jī)器人 萊蕪?fù)夂綦婁N(xiāo)機(jī)器人價(jià)格 長(zhǎng)春呼叫中心外呼系統(tǒng)哪家好 地圖標(biāo)注和認(rèn)領(lǐng) 五常地圖標(biāo)注

前臺(tái).aspx

復(fù)制代碼 代碼如下:

asp:Label ID="tplb" runat="server" Text="總頁(yè)數(shù):">/asp:Label>
asp:Label ID="lblPageCount" runat="server" Text="">/asp:Label>
asp:Label ID="curLabel" runat="server" Text="當(dāng)前頁(yè):">/asp:Label>
asp:Label ID="lblPage" Text="1" runat="server">/asp:Label>nbsp; 
asp:LinkButton ID="lblFirstButton" runat="server" OnClick="lblFirstButton_Click" >|lt;/asp:LinkButton>nbsp; 
asp:LinkButton ID="lblPreButton" runat="server" OnClick="lblPreButton_Click" >lt;/asp:LinkButton>nbsp; 
asp:LinkButton ID="lblNextButton" runat="server" OnClick="lblNextButton_Click" >gt;/asp:LinkButton>nbsp;
asp:LinkButton ID="lblLastButton" runat="server" OnClick="lblLastButton_Click" >gt;|/asp:LinkButton>nbsp; 
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="條/頁(yè)">/asp:Label>  

后臺(tái)  
復(fù)制代碼 代碼如下:

#region分頁(yè)
protected void BindFollowExamInfoGridView(int PersonID)
  {
    int currentpage = Convert.ToInt32(lblPage.Text);
    DataTable dt = new DataTable();
    dt = feibf.GetByPersonIDFollowExamInfo(PersonID);  //查詢(xún)指定人的隨訪信息記錄
    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 

=======自帶分頁(yè)
  #region自帶分頁(yè)

protected void FollowExamInfoGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
  {
    FollowExamInfoGridView.PageIndex = e.NewPageIndex;
    BindFollowExamInfoGridView(Convert.ToInt32(HiddenPersonID.Value));
  }
#endregion


  選中Grid View 的實(shí)現(xiàn)
復(fù)制代碼 代碼如下:

  #region實(shí)現(xiàn)選中行
   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

顯示顏色和刪除
復(fù)制代碼 代碼如下:

  protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
  {
    //int i;
    //for (i = 0; i GridViewRegiment.Rows.Count; i++)
    //{
      if (e.Row.RowType == DataControlRowType.DataRow)
      {
        //當(dāng)有編輯列時(shí),避免出錯(cuò),要加的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('你確認(rèn)要?jiǎng)h除:"" + 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 顯示無(wú)表頭的空紀(jì)錄,EmptyDataText="沒(méi)有記錄"
  2 顯示表頭的空紀(jì)錄
復(fù)制代碼 代碼如下:

DataTable dt = new DataTable();
  dt = feibf.GetByPersonIDFollowExamInfo(PersonID);  //查詢(xún)指定人的隨訪信息記錄
    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();
      //新建單元格對(duì)象
      FollowExamInfoGridView.Rows[0].Cells.Add(new TableCell());
      //合并單元格
      FollowExamInfoGridView.Rows[0].Cells[0].ColumnSpan = columnCount;
      //設(shè)置單元格提示內(nèi)容
      FollowExamInfoGridView.Rows[0].Cells[0].Style.Value = "text-align:center";
      FollowExamInfoGridView.Rows[0].Cells[0].Text = "此人無(wú)隨訪信息";
    } 

GridView 的導(dǎo)出
EnableEventValidation="false"
復(fù)制代碼 代碼如下:

#region導(dǎo)出
 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");
    // 如果設(shè)置為GetEncoding("GB2312");導(dǎo)出的文件將會(huì)出現(xiàn)亂碼?。?!
    Response.ContentEncoding = System.Text.Encoding.UTF7;
    Response.ContentType = "application/ms-excel";//設(shè)置輸出文件類(lèi)型為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詳細(xì)信息的顯示
  前臺(tái)
script type="text/javascript" >
  function Tooltip(cella,cellb)
  {
    document.getElementById("dc").innerText = "詳細(xì)信息:"+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> 


后臺(tái)
復(fù)制代碼 代碼如下:

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)
  {
    //首先判斷是否是數(shù)據(jù)行
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
      //當(dāng)有編輯列時(shí),避免出錯(cuò),要加的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('你確認(rèn)刪除:"" + e.Row.Cells[1].Text + ""')");
        //當(dāng)鼠標(biāo)停留時(shí)更改背景色
        e.Row.Attributes.Add("onmouseover", "color=this.style.backgroundColor;this.style.backgroundColor='#00A9FF'");
        //當(dāng)鼠標(biāo)移開(kāi)時(shí)還原背景色
        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控件的一些基礎(chǔ)使用大全,希望對(duì)大家有所用處。

您可能感興趣的文章:
  • ASP.NET 2.0/3.5中直接操作Gridview控件插入新記錄
  • asp.net GridView控件鼠標(biāo)移動(dòng)某行改變背景顏色(方法一)
  • asp.net GridView控件中模板列CheckBox全選、反選、取消
  • asp.net GridView控件中實(shí)現(xiàn)全選的解決方案
  • ASP.NET2.0中用Gridview控件操作數(shù)據(jù)的代碼
  • ASP.NET GridView控件在列上格式化時(shí)間及DataFormatString使用
  • asp.net中GridView控件遍歷的小例子
  • Asp.net的GridView控件實(shí)現(xiàn)單元格可編輯方便用戶(hù)使用
  • ASP.NET4 GridView的四種排序樣式詳解
  • ASP.NET使用GridView導(dǎo)出Excel實(shí)現(xiàn)方法
  • asp.net gridview分頁(yè):第一頁(yè) 下一頁(yè) 1 2 3 4 上一頁(yè) 最末頁(yè)
  • ASP.NET中為GridView添加刪除提示框的方法
  • asp.net中GridView數(shù)據(jù)鼠標(biāo)移入顯示提示信息
  • 如何用jQuery實(shí)現(xiàn)ASP.NET GridView折疊伸展效果
  • ASP.NET GridView中加入RadioButton不能單選的解決方案
  • 靈活掌握asp.net中g(shù)ridview控件的多種使用方法(上)
  • 靈活掌握asp.net中g(shù)ridview控件的多種使用方法(下)

標(biāo)簽:紅河 衢州 湖州 岳陽(yáng) 福州 宣城 西藏 西寧

巨人網(wǎng)絡(luò)通訊聲明:本文標(biāo)題《asp.net的GridView控件使用方法大全》,本文關(guān)鍵詞  asp.net,的,GridView,控件,使用方法,;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題,煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們,我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò),涉及言論、版權(quán)與本站無(wú)關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《asp.net的GridView控件使用方法大全》相關(guān)的同類(lèi)信息!
  • 本頁(yè)收集關(guān)于asp.net的GridView控件使用方法大全的相關(guān)信息資訊供網(wǎng)民參考!
  • 推薦文章