13.GridView显示隐藏某一列：
本方案为月儿独创，不同于网上其他方式，我觉得用一个CheckBox更人性化，这样可以隐藏不必要的列，让用户自己选择需要出现的列，在处理多列时这是一个很好的解决方案！
本方案为月儿独创，不同于网上其他方式，我觉得用一个CheckBox更人性化，这样可以隐藏不必要的列，让用户自己选择需要出现的列，在处理多列时这是一个很好的解决方案！
效果图：
图1-开始
图2-点击显示的CheckBox后
解决方案：
Code
1public void bind()
2{
3 string sqlstr = "select top 5 * from 飞狐工作室";
4 sqlcon = new SqlConnection(strCon);
5 SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
6 DataSet myds = new DataSet();
7 sqlcon.Open();
8 myda.Fill(myds, "飞狐工作室");
9 GridView1.DataSource = myds;
10 GridView1.DataKeyNames = new string[] { "身份证号码" };
11 GridView1.DataBind();
12 sqlcon.Close();
13 GridView1.Columns[3].Visible = false;//一开始隐藏
14 CheckBox1.Checked = false;//如果不这样后面的代码会把他True
15}
双击CheckBox1，在CheckedChanged方法里写上代码，最后代码如下：
Code2
1protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
2{
3 GridView1.Columns[3].Visible=! GridView1.Columns[3].Visible;
4 Response.Write("GridView1的第4列现在的显示隐藏状态是："+GridView1.Columns[3].Visible.ToString());
5}
注意：CheckBox1的AutoPostBack要True！
后台代码
1using System;
2using System.Data;
3using System.Configuration;
4using System.Web;
5using System.Web.Security;
6using System.Web.UI;
7using System.Web.UI.WebControls;
8using System.Web.UI.WebControls.WebParts;
9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11public partial class _Default : System.Web.UI.Page
12{
13 SqlConnection sqlcon;
14 SqlCommand sqlcom;
15 string strCon = "Data Source=(local);Database=北风贸易;Uid=sa;Pwd=sa";
16 protected void Page_Load(object sender, EventArgs e)
17 {
18 if (!IsPostBack)
19 {
20 ViewState["SortOrder"] = "身份证号码";
21 ViewState["OrderDire"] = "ASC";
22 bind();
23 }
24 }
25 protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
26 {
27 GridView1.EditIndex = e.NewEditIndex;
28 bind();
29 }
30 protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
31 {
32 string sqlstr = "delete from 飞狐工作室 where 身份证号码='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
33 sqlcon = new SqlConnection(strCon);
34 sqlcom = new SqlCommand(sqlstr,sqlcon);
35 sqlcon.Open();
36 sqlcom.ExecuteNonQuery();
37 sqlcon.Close();
38 bind();
39 }
40 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
41 {
42 sqlcon = new SqlConnection(strCon);
43 string sqlstr = "update 飞狐工作室 set 姓名='"
44 + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',家庭住址='"
45 + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[3].Controls[0])).Text.ToString().Trim() + "' where 身份证号码='"
46 + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
47 sqlcom=new SqlCommand(sqlstr,sqlcon);
48 sqlcon.Open();
49 sqlcom.ExecuteNonQuery();
50 sqlcon.Close();
51 GridView1.EditIndex = -1;
52 bind();
53 }
54 protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
55 {
56 GridView1.EditIndex = -1;
57 bind();
58 }
59 public void bind()
60 {
61 string sqlstr = "select top 5 * from 飞狐工作室";
62 sqlcon = new SqlConnection(strCon);
63 SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
64 DataSet myds = new DataSet();
65 sqlcon.Open();
66 myda.Fill(myds, "飞狐工作室");
67 GridView1.DataSource = myds;
68 GridView1.DataKeyNames = new string[] { "身份证号码" };
69 GridView1.DataBind();
70 sqlcon.Close();
71 GridView1.Columns[3].Visible = false;
72 CheckBox1.Checked = false;
73 }
74 protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
75 {
76 GridView1.Columns[3].Visible=! GridView1.Columns[3].Visible;
77 Response.Write("GridView1的第4列现在的显示隐藏状态是："+GridView1.Columns[3].Visible.ToString());
78 }
79}
前台代码
1<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
2<html xmlns="http://www.w3.org/1999/xhtml" >
3<head runat="server">
4 <title>GridView显示隐藏列 清清月儿http://blog.csdn.net/21aspnet </title>
5</head>
6<body style="font-size=12px">
7 <form id="form1" runat="server">
8 <div>
9 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="3" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing"
10 OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" Font-Size="12px" >
11 <FooterStyle BackColor="White" ForeColor="#000066" />
12 <Columns>
13 <asp:BoundField DataField="身份证号码" HeaderText="编号" ReadOnly="True" />
14 <asp:BoundField DataField="姓名" HeaderText="用户姓名" />
15 <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
16 <asp:BoundField DataField="家庭住址" HeaderText="家庭住址" />
17 <asp:CommandField HeaderText="选择" ShowSelectButton="True" />
18 <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
19 <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
20 </Columns>
21 <RowStyle ForeColor="#000066" />
22 <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
23 <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" />
24 <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
25 </asp:GridView>
26 <asp:CheckBox ID="CheckBox1" runat="server" AutoPostBack="True" Font-Size="12px"
27 OnCheckedChanged="CheckBox1_CheckedChanged" Text="显示隐藏家庭住址" /></div>
28 </form>
29</body>
30</html>
浙公网安备 33010602011771号