GridView很全的案例

1、GridView 72般絕技（適合新學(xué)者）目錄：GridView無代碼分頁排序GridView選中，編輯，取消，刪除GridView正反雙向排序GridView和下拉菜單DropDownList結(jié)合GridView和CheckBox結(jié)合鼠標(biāo)移到GridView某一行時(shí)改變?cè)撔械谋尘吧椒ㄒ皇髽?biāo)移到GridView某一行時(shí)改變?cè)撔械谋尘吧椒ǘ礼ridView實(shí)現(xiàn)刪除時(shí)彈出確認(rèn)對(duì)話框GridView實(shí)現(xiàn)自動(dòng)編號(hào)GridView實(shí)現(xiàn)自定義時(shí)間貨幣等字符串格式GridView實(shí)現(xiàn)用“.”代替超長字符串GridView一般換行與強(qiáng)制換行GridView顯示隱藏某一列GridView彈出新頁面/彈出新窗

2、口GridView固定表頭(不用javascript只用CSS，2行代碼，很好用)GridView合并表頭多重表頭無錯(cuò)完美版（以合并3列3行舉例）GridView突出顯示某一單元格（例如金額低于多少，分?jǐn)?shù)不及格等）GridView加入自動(dòng)求和求平均值小計(jì)GridView數(shù)據(jù)導(dǎo)入Excel/Excel數(shù)據(jù)讀入GridView2.GridView選中，編輯，取消，刪除：效果圖：后臺(tái)代碼：你可以使用sqlhelper,本文沒用。代碼如下：using System;using System.Data;using System.Configuration;using System.Web;using S

3、ystem.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page /清清月兒    SqlConnection sqlcon;    SqlCommand s

4、qlcom;    string strCon = "Data Source=(local);Database=數(shù)據(jù)庫名;Uid=帳號(hào);Pwd=密碼"    protected void Page_Load(object sender, EventArgs e)            if (!IsPostBack)         &#

5、160;          bind();                protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)            GridView1.EditIn

6、dex = e.NewEditIndex;        bind();    /刪除    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)            string sqlstr = "delete from 表 where i

7、d='" + GridView1.DataKeyse.RowIndex.Value.ToString() + "'"        sqlcon = new SqlConnection(strCon);        sqlcom = new SqlCommand(sqlstr,sqlcon);        sqlcon.Open();&#

8、160;       sqlcom.ExecuteNonQuery();        sqlcon.Close();        bind();    /更新    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) &

9、#160;          sqlcon = new SqlConnection(strCon);        string sqlstr = "update 表 set 字段1='"            + (TextBox)(GridView1.Rowse.RowIndex.Cells1.Contro

10、ls0).Text.ToString().Trim() + "',字段2='"            + (TextBox)(GridView1.Rowse.RowIndex.Cells2.Controls0).Text.ToString().Trim() + "',字段3='"            +

11、(TextBox)(GridView1.Rowse.RowIndex.Cells3.Controls0).Text.ToString().Trim() + "' where id='"             + GridView1.DataKeyse.RowIndex.Value.ToString() + "'"        sqlcom=new S

12、qlCommand(sqlstr,sqlcon);        sqlcon.Open();        sqlcom.ExecuteNonQuery();        sqlcon.Close();        GridView1.EditIndex = -1;    

13、    bind();    /取消    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)            GridView1.EditIndex = -1;        bind(); 

14、60;  /綁定    public void bind()            string sqlstr = "select * from 表"        sqlcon = new SqlConnection(strCon);        SqlDataAdapter myda = ne

15、w SqlDataAdapter(sqlstr, sqlcon);        DataSet myds = new DataSet();        sqlcon.Open();        myda.Fill(myds, "表");        GridView1.DataSource

16、= myds;        GridView1.DataKeyNames = new string "id" ;/主鍵        GridView1.DataBind();        sqlcon.Close();    前臺(tái)主要代碼：        

17、;                    . .<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"        

18、60;               ForeColor="#333333" GridLines="None" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing"          &#

19、160;             OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit">                   

20、     <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />                        <Columns>  

21、60;                         <asp:BoundField DataField="身份證號(hào)碼" HeaderText="用戶ID" ReadOnly="True" />       

22、0;                    <asp:BoundField DataField="姓名" HeaderText="用戶姓名" />                 

23、0;          <asp:BoundField DataField="員工性別" HeaderText="性別" />                            <

24、;asp:BoundField DataField="家庭住址" HeaderText="家庭住址" />                            <asp:CommandField HeaderText="選擇" ShowSelectButt

25、on="True" />                            <asp:CommandField HeaderText="編輯" ShowEditButton="True" />    

26、0;                       <asp:CommandField HeaderText="刪除" ShowDeleteButton="True" />             &

27、#160;          </Columns>                        <RowStyle ForeColor="#000066" />      &

28、#160;                 <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />              

29、60;         <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />                       

30、; <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />                    </asp:GridView>3.GridView正反雙向排序：效果圖：點(diǎn)姓名各2次的排序，點(diǎn)其他也一樣可以。后臺(tái)代碼：using Syste

31、m;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class Default3 :

32、 System.Web.UI.Page/清清月兒的博客    SqlConnection sqlcon;    string strCon = "Data Source=(local);Database=北風(fēng)貿(mào)易;Uid=sa;Pwd="    protected void Page_Load(object sender, EventArgs e)            if (!IsP

33、ostBack)                    ViewState"SortOrder" = "身份證號(hào)碼"            ViewState"OrderDire" = "ASC"   

34、;         bind();                protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)            string sPage = e.SortExpress

35、ion;        if (ViewState"SortOrder".ToString() = sPage)                    if (ViewState"OrderDire".ToString() = "Desc")    

36、            ViewState"OrderDire" = "ASC"            else                ViewState"OrderDir

37、e" = "Desc"                else                    ViewState"SortOrder" = e.SortExpression;    

38、            bind();        public void bind()                    string sqlstr = "select top 5 * from 飛狐工作室"   

39、;     sqlcon = new SqlConnection(strCon);        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);        DataSet myds = new DataSet();        sqlcon.Open(); 

40、0;      myda.Fill(myds, "飛狐工作室");        DataView view = myds.Tables"飛狐工作室".DefaultView;        string sort = (string)ViewState"SortOrder" + " " + (string)ViewState&

41、quot;OrderDire"        view.Sort = sort;        GridView1.DataSource = view;        GridView1.DataBind();        sqlcon.Close();    前臺(tái)主要代碼：&

42、lt;asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"                        CellPadding="3" Fo

43、nt-Size="9pt" OnSorting="GridView1_Sorting" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px">                   &#

44、160;    <FooterStyle BackColor="White" ForeColor="#000066" />                        <Columns>       &#

45、160;                     <asp:BoundField DataField="身份證號(hào)碼" HeaderText="用戶ID" SortExpression="身份證號(hào)碼" />          &#

46、160;                 <asp:BoundField DataField="姓名" HeaderText="用戶姓名" SortExpression="姓名"/>               

47、60;            <asp:BoundField DataField="員工性別" HeaderText="性別" SortExpression="員工性別"/>                    &#

48、160;       <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" SortExpression="家庭住址"/>                         

49、;                               </Columns>                  

50、;      <RowStyle ForeColor="#000066" />                        <SelectedRowStyle BackColor="#669999" Font-Bold="True" For

51、eColor="White" />                        <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />   &#

52、160;                    <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />            

53、60;       </asp:GridView>4.GridView和下拉菜單DropDownList結(jié)合：效果圖：后臺(tái)代碼：using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.We

54、bControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class Default4 : System.Web.UI.Page    SqlConnection sqlcon;    string strCon = "Data Source=(local);Database=北風(fēng)貿(mào)易;Uid=sa;Pwd=sa"    protected void Pa

55、ge_Load(object sender, EventArgs e)            DropDownList ddl;        if (!IsPostBack)                    string sqlstr = &

56、quot;select top 5 * from 飛狐工作室"            sqlcon = new SqlConnection(strCon);            SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);      &#

57、160;     DataSet myds = new DataSet();            sqlcon.Open();            myda.Fill(myds, "飛狐工作室");          

58、;  GridView1.DataSource = myds;            GridView1.DataBind();            for (int i = 0; i <= GridView1.Rows.Count - 1; i+)         &#

59、160;                  DataRowView mydrv = myds.Tables"飛狐工作室".DefaultViewi;                if (Convert.ToString(mydrv"員工性別").T

60、rim() = "True")                                    ddl = (DropDownList)GridView1.Rowsi.FindControl("DropDownList1&q

61、uot;);                    ddl.SelectedIndex = 0;                           

62、     if (Convert.ToString(mydrv"員工性別").Trim() = "False")                                   

63、; ddl = (DropDownList)GridView1.Rowsi.FindControl("DropDownList1");                    ddl.SelectedIndex = 1;              &#

64、160;                         sqlcon.Close();                public SqlDataReader ddlbind()      

65、0;     string sqlstr = "select distinct 員工性別 from 飛狐工作室"        sqlcon = new SqlConnection(strCon);        SqlCommand sqlcom = new SqlCommand(sqlstr, sqlcon);       

66、 sqlcon.Open();        return sqlcom.ExecuteReader();    前臺(tái)主要代碼：<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"        

67、0;               CellPadding="3" Font-Size="9pt"  BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px">      

68、;                  <FooterStyle BackColor="White" ForeColor="#000066" />                   

69、60;    <Columns>                             <asp:BoundField DataField="身份證號(hào)碼" HeaderText="用戶ID" SortExpression=&quo

70、t;身份證號(hào)碼" />                            <asp:BoundField DataField="姓名" HeaderText="用戶姓名" SortExpression="姓名"/>  

71、                          <asp:TemplateField HeaderText="員工性別">                

72、                <ItemTemplate>                               

73、60;    <asp:DropDownList ID="DropDownList1" runat="server" DataSource='<%# ddlbind()%>' DataValueField="員工性別" DataTextField="員工性別">               

74、0;                    </asp:DropDownList>                          &#

75、160;     </ItemTemplate>                            </asp:TemplateField>          &

76、#160;                 <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" SortExpression="家庭住址"/>              

77、0;                                         </Columns>       

78、0;                <RowStyle ForeColor="#000066" />                        <SelectedRowStyle

79、 BackColor="#669999" Font-Bold="True" ForeColor="White" />                        <PagerStyle BackColor="White" ForeColor="#000066&quo

80、t; HorizontalAlign="Left" />                        <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />  &#

81、160;                 </asp:GridView>5.GridView和CheckBox結(jié)合：效果圖：后臺(tái)代碼：using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebCon

82、trols;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class Default5 : System.Web.UI.Page/清清月兒     SqlConnection sqlcon;    string strCon = "Data Source=(local);Database=北風(fēng)貿(mào)易;Uid=sa;Pwd=sa"&#

83、160;   protected void Page_Load(object sender, EventArgs e)            if (!IsPostBack)                    bind();      

84、          protected void CheckBox2_CheckedChanged(object sender, EventArgs e)            for (int i = 0; i <= GridView1.Rows.Count - 1; i+)             

85、       CheckBox cbox = (CheckBox)GridView1.Rowsi.FindControl("CheckBox1");            if (CheckBox2.Checked = true)                

86、;            cbox.Checked = true;                        else             &

87、#160;              cbox.Checked = false;                            protected void Button2_Click(object sender, Eve

88、ntArgs e)            sqlcon = new SqlConnection(strCon);        SqlCommand sqlcom;        for (int i = 0; i <= GridView1.Rows.Count - 1; i+)      &

89、#160;             CheckBox cbox = (CheckBox)GridView1.Rowsi.FindControl("CheckBox1");            if (cbox.Checked = true)          

90、;                  string sqlstr = "delete from 飛狐工作室 where 身份證號(hào)碼='" + GridView1.DataKeysi.Value + "'"               

91、 sqlcom = new SqlCommand(sqlstr, sqlcon);                sqlcon.Open();                sqlcom.ExecuteNonQuery();      &#

92、160;         sqlcon.Close();                            bind();        protected void Button1_Click(objec

93、t sender, EventArgs e)            CheckBox2.Checked = false;        for (int i = 0; i <= GridView1.Rows.Count - 1; i+)                

94、60;   CheckBox cbox = (CheckBox)GridView1.Rowsi.FindControl("CheckBox1");            cbox.Checked = false;                public void bind()    &

95、#160;       string sqlstr = "select top 5 * from 飛狐工作室"        sqlcon = new SqlConnection(strCon);        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);    

96、60;   DataSet myds = new DataSet();        sqlcon.Open();        myda.Fill(myds, "tb_Member");        GridView1.DataSource = myds;        Gr

97、idView1.DataKeyNames = new string "身份證號(hào)碼" ;        GridView1.DataBind();        sqlcon.Close();    前臺(tái)主要代碼：<asp:GridView ID="GridView1" runat="server" AllowSorting="True" Au

98、toGenerateColumns="False"                        CellPadding="3" Font-Size="9pt"  BackColor="White" BorderColor="#CCCCCC" BorderSt

99、yle="None" BorderWidth="1px">                        <FooterStyle BackColor="White" ForeColor="#000066" />     

100、                   <Columns>                             <asp

101、:TemplateField>                                <ItemTemplate>            

102、60;                       <asp:CheckBox ID="CheckBox1" runat="server" />               &#

103、160;                </ItemTemplate>                            </asp:TemplateFiel

104、d>                             <asp:BoundField DataField="身份證號(hào)碼" HeaderText="用戶ID" SortExpression="身份證號(hào)碼" />  &

105、#160;                         <asp:BoundField DataField="姓名" HeaderText="用戶姓名" SortExpression="姓名"/>       &#

106、160;                                                <asp:BoundField

107、 DataField="家庭住址" HeaderText="家庭住址" SortExpression="家庭住址"/>                                   

108、60;                    </Columns>                        <RowStyle ForeColor=&quo

109、t;#000066" />                        <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />     

110、;                   <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />             &

111、#160;          <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />                    </asp:GridView&g

112、t;                     <asp:CheckBox ID="CheckBox2" runat="server" AutoPostBack="True" Font-Size="9pt" OnCheckedChanged="CheckBox2_CheckedChanged"&

113、#160;                       Text="全選" />                    <asp:Button ID=&quo

114、t;Button1" runat="server" Font-Size="9pt" Text="取消" OnClick="Button1_Click" />                    <asp:Button ID="Button2" runat="server&qu

115、ot; Font-Size="9pt" Text="刪除" OnClick="Button2_Click" />6.鼠標(biāo)移到GridView某一行時(shí)改變?cè)撔械谋尘吧椒ㄒ唬盒Ч麍D：做法：雙擊GridView的OnRowDataBound事件；在后臺(tái)的GridView1_RowDataBound()方法添加代碼，最后代碼如下所示：protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)     &

116、#160;      int i;        /執(zhí)行循環(huán)，保證每條數(shù)據(jù)都可以更新        for (i = 0; i < GridView1.Rows.Count; i+)                    /

117、首先判斷是否是數(shù)據(jù)行            if (e.Row.RowType = DataControlRowType.DataRow)                            /當(dāng)鼠標(biāo)停留時(shí)更改背景色 

118、               e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#00A9FF'");             

119、0;  /當(dāng)鼠標(biāo)移開時(shí)還原背景色                e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");                 

120、0;      前臺(tái)代碼：<html xmlns="/1999/xhtml" ><head runat="server">    <title>實(shí)現(xiàn)鼠標(biāo)劃過改變GridView的行背景色 清清月兒</head><body>    <form id="form1" runat="server">  

121、;  <div>        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="身份證號(hào)碼"            DataSourceID="SqlDataSource1&qu

122、ot; AllowSorting="True" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" Font-Size="12px" OnRowDataBound="GridView1_RowDataBound">       &

123、#160;    <Columns>                <asp:BoundField DataField="身份證號(hào)碼" HeaderText="身份證號(hào)碼" ReadOnly="True" SortExpression="身份證號(hào)碼" />     

124、           <asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />                <asp:BoundField DataField="家庭住址&quo

125、t; HeaderText="家庭住址" SortExpression="家庭住址" />                <asp:BoundField DataField="郵政編碼" HeaderText="郵政編碼" SortExpression="郵政編碼" />     

126、       </Columns>            <FooterStyle BackColor="White" ForeColor="#000066" />            <RowStyle ForeColor="#000066" />            <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" /&