如何在asp.net中隐藏网格视图中的数据表列
我想在网格视图中隐藏列。我创建了一个数据表，并在其中添加了来自数据库的数据，然后将其与网格视图绑定在一起。现在我想隐藏0索引列，但它并没有隐藏。请帮帮我。
这是我的代码。
` `int = Convert.ToInt16(Session" companyID ")；
DataTable taskTable = new DataTable("TaskList");
SqlConnection sql_connection = new SqlConnection("data source=.\\SQLEXPRESS;Integrated Security=SSPI; initial catalog=db_ease");
SqlCommand sqlCommand = new SqlCommand("select tbl_employee.empID,tbl_employee.empEmploymentID,tbl_employee.empFirstname,tbl_employee.empMiddlename,tbl_employee.empLastname,tbl_employee.empGender,tbl_employee.empMobileNo,tbl_employee.empMac,tbl_association.associationStatus from tbl_employee inner join tbl_association on tbl_employee.empID=tbl_association.empID where tbl_association.companyID="+companyID, sql_connection);
SqlDataAdapter adapter = new SqlDataAdapter(sqlCommand);
adapter.Fill(taskTable);
Session["TaskTable"] = taskTable;
taskTable.Columns[0].ColumnName = "Employee ID";
taskTable.Columns[1].ColumnName = "Employment ID";
taskTable.Columns[2].ColumnName = "First Name";
taskTable.Columns[3].ColumnName = "Middle Name";
taskTable.Columns[4].ColumnName = "Last Name";
taskTable.Columns[5].ColumnName = "Gender";
taskTable.Columns[6].ColumnName = "Mobile No";
taskTable.Columns[7].ColumnName = "MAC Address";
taskTable.Columns[8].ColumnName = "Status";
BindData();
displayGridView.Columns[0].Visible = false;
sql_connection.Close();`这是我的网格视图
<asp:GridView ID="displayGridView" runat="server" CssClass="table table-striped table-bordered dataTable" OnRowEditing="displayGridView_RowEditing" OnRowUpdating="displayGridView_RowUpdating" OnRowDeleting="displayGridView_RowDeleting" OnRowCancelingEdit="displayGridView_RowCancelingEdit" AllowPaging="true" OnPageIndexChanging="displayGridView_PageIndexChanging" OnSorting="displayGridView_RowSorting" AutoGenerateDeleteButton="true" AutoGenerateEditButton="true" PagerSettings-FirstPageText="First" PagerSettings-LastPageText="Last" PagerSettings-Mode="NumericFirstLast" PagerSettings-PageButtonCount="4" PageSize="4" EmptyDataText="No data found" AllowSorting="True" OnDataBound="displayGridView_OnDataBound" > </asp:GridView>
回答 2
Stack Overflow用户
发布于 2014-07-16 13:36:28
您应该像这样隐藏displayGridView_RowDataBound事件上的列。
protected void displayGridView_RowDataBound(object sender, GridViewRowEventArgs e)
{
e.Row.Cells[0].Visible = false;
}Stack Overflow用户
发布于 2014-07-16 13:39:37
当您只需要网格视图中的一些列时，您应该只在aspx文件中添加这些列，如下所示：
<asp:GridView ID="GridView1" AutoGenerateColumns="false" runat="server">
<Columns>
<asp:BoundField HeaderText="Header Name" DataField="NameOfFieldInDatabase" />
<asp:BoundField HeaderText="Header Name2" DataField="NameOfFieldInDatabase2" />
<asp:BoundField HeaderText="Header Name3" DataField="NameOfFieldInDatabase3" />
</Columns>
</asp:GridView>您还应该像上面的代码一样将AutoGenerateColumns="false“添加到网格视图中，否则您将拥有定制的列以及所有其他自动生成的列
https://stackoverflow.com/questions/24772831
复制相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号