如何不显示绑定到datagrid中的某列

参考:
http://www.syncfusion.com/FAQ/WinForms/FAQ_c44c.asp#q708q

引用:
There are several ways to hide a column:

  1. You can use your DataSet's ColumnMapping property to hide a column.

// Creating connection and command sting
string conStr = @"Provider=Microsoft.JET.OLEDB.4.0;data source=C:\northwind.mdb";
string sqlStr = "SELECT * FROM Employees";

// Create connection object
OleDbConnection conn = new OleDbConnection(conStr);

// Create data adapter object
OleDbDataAdapter da = new OleDbDataAdapter(sqlStr,conn);

// Create a dataset object and fill with data using data adapter's Fill method
DataSet ds = new DataSet();
da.Fill(ds, "Employees");

// Hide the column and attach dataset's DefaultView to the datagrid control
ds.Tables["Employees"].Columns["LastName"].ColumnMapping = MappingType.Hidden;
dataGrid1.DataSource = ds.Tables["Employees"];

  1. Another way to hide a column is to set its width to zero.

  2. Another way to hide a column is to create a custom table style, and as you add columnstyles to your tablestyle, omit the column you want hidden.

Published At
Categories with Web编程
Tagged with
comments powered by Disqus