显示和隐藏DataGrid中的列

最新推荐文章于 2021-08-17 10:10:57 发布

luoboqingcai

最新推荐文章于 2021-08-17 10:10:57 发布

阅读量1.4k

点赞数

分类专栏： DataGrid 文章标签： datagrid integer class 脚本 web string

本文链接：https://blog.csdn.net/luoboqingcai/article/details/116815

版权

DataGrid 专栏收录该内容

42 篇文章 0 订阅

订阅专栏

要显示和隐藏DataGrid中的列，最关键的是AutoGenerateColumns设置为False：下面就是实现这一功能的aspx代码和脚本代码：

  &amp;lt;%@ Page Language="vb" AutoEventWireup="false" Codebehind="ShowHideCols.aspx.vb" Inherits="aspxWeb.ShowHideCols"%&amp;gt; &amp;lt;!DOCTYPE html PUBLIC "-//W3C//DTD html 4.0 Transitional//EN"&amp;gt; &amp;lt;HTML&amp;gt; &amp;lt;HEAD&amp;gt; &amp;lt;title&amp;gt;ShowHideCols&amp;lt;/title&amp;gt; &amp;lt;meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0"&amp;gt; &amp;lt;meta name="CODE_LANGUAGE" content="Visual Basic 7.0"&amp;gt; &amp;lt;meta name="vs_defaultClientScript" content="JavaScript"&amp;gt; &amp;lt;meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"&amp;gt; &amp;lt;/HEAD&amp;gt; &amp;lt;body MS_POSITIONING="GridLayout"&amp;gt; &amp;lt;form id="Form1" method="post" runat="server"&amp;gt; &amp;lt;asp:Button ID="btnShow" Text="Show Details" OnClick="ShowDetails" Runat="server" /&amp;gt; &amp;lt;asp:Button ID="btnHide" Text="Hide Details" OnClick="HideDetails" Runat="server" /&amp;gt; &amp;lt;asp:DataGrid ID="dtgCusts" Runat="server" AutoGenerateColumns="False" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" BackColor="White" CellPadding="3" GridLines="Vertical"&amp;gt; &amp;lt;Columns&amp;gt; &amp;lt;asp:BoundColumn DataField="Title" /&amp;gt; &amp;lt;asp:BoundColumn DataField="id" Visible="False" /&amp;gt; &amp;lt;asp:BoundColumn DataField="CreateDate" DataFormatString="{0:yyyy-MM-dd HH:mm:ss}" Visible="False" /&amp;gt; &amp;lt;asp:EditCommandColumn EditText="Edit" HeaderText="Edit" Visible="False" /&amp;gt; &amp;lt;/Columns&amp;gt; &amp;lt;AlternatingItemStyle BackColor="#DCDCDC" /&amp;gt; &amp;lt;ItemStyle ForeColor="Black" BackColor="#EEEEEE" /&amp;gt; &amp;lt;headerStyle Font-Bold="True" ForeColor="White" BackColor="#000084" /&amp;gt; &amp;lt;/asp:DataGrid&amp;gt; &amp;lt;/form&amp;gt; &amp;lt;/body&amp;gt; &amp;lt;/HTML&amp;gt;

后代码脚本

  Imports System.Data Imports System.Data.OleDb Public Class ShowHideCols Inherits System.Web.UI.Page Protected WithEvents btnShow As System.Web.UI.WebControls.Button Protected WithEvents btnHide As System.Web.UI.WebControls.Button Protected WithEvents dtgCusts As System.Web.UI.WebControls.DataGrid #Region " Web 窗体设计器生成的代码 " '该调用是 Web 窗体设计器所必需的。 &amp;lt;System.Diagnostics.DebuggerStepThrough()&amp;gt; Private Sub InitializeComponent() End Sub Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs)_ Handles MyBase.Init 'CODEGEN: 此方法调用是 Web 窗体设计器所必需的 '不要使用代码编辑器修改它。 InitializeComponent() End Sub #End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)_ Handles MyBase.Load '在此处放置初始化页的用户代码 btnShow.Text = "显示列" btnHide.Text = "隐藏列" dtgCusts.Columns(1).HeaderText = "" dtgCusts.Columns(0).HeaderText = "标题" dtgCusts.Columns(2).HeaderText = "发布日期" dtgCusts.Columns(3).HeaderText = "编辑" If Not IsPostBack Then BindTheData() End If End Sub Sub BindTheData() Dim objConn As OleDbConnection Dim objCmd As OleDbCommand objConn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" _ + Server.MapPath("Test.mdb")) Dim strSql As String strSql = "SELECT Top 10 id,Title,CreateDate FROM Document" objCmd = New OleDbCommand(strSql, objConn) objConn.Open() dtgCusts.DataSource = objCmd.ExecuteReader() dtgCusts.DataBind() objConn.Close() objConn.Dispose() End Sub Sub ShowDetails(ByVal sender As System.Object, ByVal e As System.EventArgs) Dim intCounter As Integer For intCounter = 1 To dtgCusts.Columns.Count - 1 dtgCusts.Columns(intCounter).Visible = True Next End Sub Sub HideDetails(ByVal sender As System.Object, ByVal e As System.EventArgs) Dim intCounter As Integer For intCounter = 1 To dtgCusts.Columns.Count - 1 dtgCusts.Columns(intCounter).Visible = False Next End Sub End Class