blocks|key|1111032|text|我不能说4，然而这在3.5+SP1是不可能的，至少在没有注册事件的情况下是不可能的，我想不惜一切代价避免。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1111033|相反，您可以将生成代码更改为AutoGenerateColumns=False，然后将您关心的列放入XAML中，因为底层数据仍将被适当地放入列中|offset|length|style|CODE|1111034|++++++++++++<dg:DataGridTextColumn+Header="Display"+Binding="{Binding+DisplayName}"/>
++++++++++++<dg:DataGridTextColumn+Header="Host"+Binding="{Binding+HostName}"/>
++++++++++++<dg:DataGridTextColumn+Header="Database"+Binding="{Binding+Database}"/>
++++++++++++<dg:DataGridTextColumn+Header="Username"+Binding="{Binding+Username}"/>
++++++++++++<dg:DataGridTextColumn+Header="Password"+Binding="{Binding+Password}"/>|code-block|syntax|javascript|1111035|这将允许您只显示与底层模型相关的列，并将Header更改为您认为合适的显示方式，这样您就不会被模型上的Property名称所束缚。|1111036|entityMap^0|0|E|P|0|0|K|6|1F|8|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|U|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|V|8|@$D|W|E|X|F|G]|$D|Y|E|Z|F|G]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|10|8|@]|9|@]|A|$]]]|P|$]]

I can't speak for 4, however it was not possible in 3.5 SP1, at least without registering for an event which I wanted to avoid at all costs. 

What you could do instead is change your generation code to <code>AutoGenerateColumns=False</code> then just place the columns you care about within the XAML as the underlying data will all still be placed within the columns appropriately 

<pre><code> &lt;dg:DataGridTextColumn Header="Display" Binding="{Binding DisplayName}"/&gt;
 &lt;dg:DataGridTextColumn Header="Host" Binding="{Binding HostName}"/&gt;
 &lt;dg:DataGridTextColumn Header="Database" Binding="{Binding Database}"/&gt;
 &lt;dg:DataGridTextColumn Header="Username" Binding="{Binding Username}"/&gt;
 &lt;dg:DataGridTextColumn Header="Password" Binding="{Binding Password}"/&gt;
</code></pre>

This will allow you to display the only columns you care about in relation to the underlying model as well as change the <code>Header</code> to display as you see fit, so you are not tied to the <code>Property</code> name on the model.

blocks|key|1111085|text|在数据网格中，订阅AutoGeneratingColumn事件，事件args+(DataGridAutoGeneratingColumnEventArgs)具有列名和"Cancel"，如果列名为ID，则设置Cancel+=+true。应该能行得通。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1111086|entityMap^0|9|K|Y|4|14|11|2C|6|2V|D|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]|$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|G|$]]

in your datagrid, subscribe for the <code>AutoGeneratingColumn</code> event, the event <code>args</code> (<code>DataGridAutoGeneratingColumnEventArgs</code>) has the column name and a "<code>Cancel</code>", if the column name is ID then set <code>Cancel = true</code>. should do the trick.

blocks|key|1111107|text|其他可能是Visibility.Collapsed|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1111108|++++private+void+dataGrid_AutoGeneratingColumn(object+sender,+
++++++++DataGridAutoGeneratingColumnEventArgs+e)
++++{
++++++++//Set+properties+on+the+columns+during+auto-generation+
++++++++switch+(e.Column.Header.ToString())
++++++++{
++++++++++++case+"rownameYouWantToHide":
++++++++++++++++e.Column.Visibility+=+Visibility.Collapsed;
++++++++++++++++break;
++++++++}
++++}|code-block|syntax|javascript|1111109|entityMap^0|5|K|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Other possibility would be <code>Visibility.Collapsed</code>:

<pre><code> private void dataGrid_AutoGeneratingColumn(object sender, 
 DataGridAutoGeneratingColumnEventArgs e)
 {
 //Set properties on the columns during auto-generation 
 switch (e.Column.Header.ToString())
 {
 case "rownameYouWantToHide":
 e.Column.Visibility = Visibility.Collapsed;
 break;
 }
 }
</code></pre>

blocks|key|1111152|text|您可以使用行为(可重用代码)来完成此工作...这样，您就可以使用attribute，将列可见性集中在一个地方。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1111153|用法：|1111154|<Window
...
+xmlns:extension="clr-namespace:WpfControlLibrary.Extension;assembly=WpfControlLibrary">

<DataGrid+...
++++extension:DataGridBehavior.UseBrowsableAttributeOnColumn="True">|code-block|syntax|javascript|1111155|..。|1111156|public+class+YourObjectItem
{
++++[Browsable(false)]
++++++++public+Assembly+Assembly+{+get;+set;+}|1111157|代码：|1111158|using+System;
using+System.ComponentModel;
using+System.Windows;
using+System.Windows.Controls;

namespace+HQ.Wpf.Util.Behaviors
{
++++///+<summary>
++++///+Using+this+behavior+on+a+dataGRid+will+ensure+to+display+only+columns+with+"Browsable+Attributes"
++++///+</summary>
++++public+static+class+DataGridBehavior
++++{
++++++++public+static+readonly+DependencyProperty+UseBrowsableAttributeOnColumnProperty+=
++++++++++++DependencyProperty.RegisterAttached("UseBrowsableAttributeOnColumn",
++++++++++++typeof(bool),
++++++++++++typeof(DataGridBehavior),
++++++++++++new+UIPropertyMetadata(false,+UseBrowsableAttributeOnColumnChanged));

++++++++public+static+bool+GetUseBrowsableAttributeOnColumn(DependencyObject+obj)
++++++++{
++++++++++++return+(bool)obj.GetValue(UseBrowsableAttributeOnColumnProperty);
++++++++}

++++++++public+static+void+SetUseBrowsableAttributeOnColumn(DependencyObject+obj,+bool+val)
++++++++{
++++++++++++obj.SetValue(UseBrowsableAttributeOnColumnProperty,+val);
++++++++}

++++++++private+static+void+UseBrowsableAttributeOnColumnChanged(DependencyObject+obj,+DependencyPropertyChangedEventArgs+e)
++++++++{
++++++++++++var+dataGrid+=+obj+as+DataGrid;
++++++++++++if+(dataGrid+!=+null)
++++++++++++{
++++++++++++++++if+((bool)e.NewValue)
++++++++++++++++{
++++++++++++++++++++dataGrid.AutoGeneratingColumn+%2B=+DataGridOnAutoGeneratingColumn;
++++++++++++++++}
++++++++++++++++else
++++++++++++++++{
++++++++++++++++++++dataGrid.AutoGeneratingColumn+-=+DataGridOnAutoGeneratingColumn;
++++++++++++++++}
++++++++++++}
++++++++}

++++++++private+static+void+DataGridOnAutoGeneratingColumn(object+sender,+DataGridAutoGeneratingColumnEventArgs+e)
++++++++{
++++++++++++var+propDesc+=+e.PropertyDescriptor+as+PropertyDescriptor;

++++++++++++if+(propDesc+!=+null)
++++++++++++{
++++++++++++++++foreach+(Attribute+att+in+propDesc.Attributes)
++++++++++++++++{
++++++++++++++++++++var+browsableAttribute+=+att+as+BrowsableAttribute;
++++++++++++++++++++if+(browsableAttribute+!=+null)
++++++++++++++++++++{
++++++++++++++++++++++++if+(!browsableAttribute.Browsable)
++++++++++++++++++++++++{
++++++++++++++++++++++++++++e.Cancel+=+true;
++++++++++++++++++++++++}
++++++++++++++++++++}

++++++++++++++++++++//+As+proposed+by+"dba"+stackoverflow+user+on+webpage:+
++++++++++++++++++++//+https://stackoverflow.com/questions/4000132/is-there-a-way-to-hide-a-specific-column-in-a-datagrid-when-autogeneratecolumns
++++++++++++++++++++//+I+added+few+next+lines:
++++++++++++++++++++var+displayName+=+att+as+DisplayNameAttribute;
++++++++++++++++++++if+(displayName+!=+null)
++++++++++++++++++++{
++++++++++++++++++++++++e.Column.Header+=+displayName.DisplayName;
++++++++++++++++++++}
++++++++++++++++}
++++++++++++}
++++++++}
++++}
}|1111159|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|X|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|Q|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|R|$]]

You can use a behavior (reusable code) to do the job... This way you can use attribute which would centralize the column visibility in one place.

Usage:

<pre><code>&lt;Window
...
 xmlns:extension="clr-namespace:WpfControlLibrary.Extension;assembly=WpfControlLibrary"&gt;

&lt;DataGrid ...
 extension:DataGridBehavior.UseBrowsableAttributeOnColumn="True"&gt;
</code></pre>

...

<pre><code>public class YourObjectItem
{
 [Browsable(false)]
 public Assembly Assembly { get; set; }
</code></pre>

Code:

<pre><code>using System;
using System.ComponentModel;
using System.Windows;
using System.Windows.Controls;

namespace HQ.Wpf.Util.Behaviors
{
 /// &lt;summary&gt;
 /// Using this behavior on a dataGRid will ensure to display only columns with "Browsable Attributes"
 /// &lt;/summary&gt;
 public static class DataGridBehavior
 {
 public static readonly DependencyProperty UseBrowsableAttributeOnColumnProperty =
 DependencyProperty.RegisterAttached("UseBrowsableAttributeOnColumn",
 typeof(bool),
 typeof(DataGridBehavior),
 new UIPropertyMetadata(false, UseBrowsableAttributeOnColumnChanged));

 public static bool GetUseBrowsableAttributeOnColumn(DependencyObject obj)
 {
 return (bool)obj.GetValue(UseBrowsableAttributeOnColumnProperty);
 }

 public static void SetUseBrowsableAttributeOnColumn(DependencyObject obj, bool val)
 {
 obj.SetValue(UseBrowsableAttributeOnColumnProperty, val);
 }

 private static void UseBrowsableAttributeOnColumnChanged(DependencyObject obj, DependencyPropertyChangedEventArgs e)
 {
 var dataGrid = obj as DataGrid;
 if (dataGrid != null)
 {
 if ((bool)e.NewValue)
 {
 dataGrid.AutoGeneratingColumn += DataGridOnAutoGeneratingColumn;
 }
 else
 {
 dataGrid.AutoGeneratingColumn -= DataGridOnAutoGeneratingColumn;
 }
 }
 }

 private static void DataGridOnAutoGeneratingColumn(object sender, DataGridAutoGeneratingColumnEventArgs e)
 {
 var propDesc = e.PropertyDescriptor as PropertyDescriptor;

 if (propDesc != null)
 {
 foreach (Attribute att in propDesc.Attributes)
 {
 var browsableAttribute = att as BrowsableAttribute;
 if (browsableAttribute != null)
 {
 if (!browsableAttribute.Browsable)
 {
 e.Cancel = true;
 }
 }

 // As proposed by "dba" stackoverflow user on webpage: 
 // https://stackoverflow.com/questions/4000132/is-there-a-way-to-hide-a-specific-column-in-a-datagrid-when-autogeneratecolumns
 // I added few next lines:
 var displayName = att as DisplayNameAttribute;
 if (displayName != null)
 {
 e.Column.Header = displayName.DisplayName;
 }
 }
 }
 }
 }
}
</code></pre>

blocks|key|1111231|text|我最近做到了这一点，并想分享我的解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1111232|我刚刚创建了一个视图模型，希望数据网格遵循该模型，并且对于希望它忽略的字段(即，不自动为其生成列)，只需将这些字段设置为private。它的工作方式非常出色，并且不需要不必要的代码。|1111233|例如，下面是我传递给包含数据网格的视图的视图模型。我只需将不想作为列的字段设置为私有，即可获得所需的所有内容，如我的示例中的"FullPath“字段所示。我知道这可能不是在每个场景中都可能实现的，但对我来说效果很好。|1111234|namespace+dev
{+++
++++///+<summary>
++++///+View+model+for+tag+list+view+in+data+grid
++++///+</summary>
++++public+class+TagDataViewModel+:+BaseViewModel
++++{
++++++++///+<summary>
++++++++///+Default+constructor
++++++++///+</summary>
++++++++///+<param+name="path">The+JSONPath+to+this+item</param>
++++++++public+TagDataViewModel(string+path)
++++++++{
++++++++++++FullPath+=+path;
++++++++}

++++++++///+<summary>
++++++++///+Gets+and+sets+the+JSONPath+to+this+item
++++++++///+</summary>
++++++++private+string+FullPath+{+get;+set;+}

++++++++///+<summary>
++++++++///+Gets+the+name
++++++++///+</summary>
++++++++public+string+Name+=>+ProjectHelpers.GetPropertyValue(FullPath,+"Name");

++++++++///+<summary>
++++++++///+Gets+the+address
++++++++///+</summary>
++++++++public+string+Address+=>+ProjectHelpers.GetPropertyValue(FullPath,+"Address");

++++++++///+<summary>
++++++++///+Gets+the+data+type
++++++++///+</summary>
++++++++public+string+DataType+=>+ProjectHelpers.GetPropertyValue(FullPath,+"DataType");

++++++++///+<summary>
++++++++///+Gets+the+scan+rate
++++++++///+</summary>
++++++++public+string+ScanRate+=>+ProjectHelpers.GetPropertyValue(FullPath,+"ScanRate");

++++++++///+<summary>
++++++++///+Gets+the+scaling+type
++++++++///+</summary>
++++++++public+string+ScalingType+=>+ProjectHelpers.GetPropertyValue(FullPath,+"ScalingType");
++++}
}|code-block|syntax|javascript|1111235|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

I've recently done this and wanted to share my solution:

I just made a view model I wanted the datagrid to follow and for the fields I wanted it to ignore (that is, not auto generate columns for), simply set those fields to private. Worked like a charm and there's no need for unnecessary code.

For example, here's the view model I pass to the view that contains the datagrid. I get all I need by simply setting the fields I don't want as columns to private, shown on the "FullPath" field in my example. I understand this may not be possible in every scenario, but worked for me quite well.

<pre><code>namespace dev
{ 
 /// &lt;summary&gt;
 /// View model for tag list view in data grid
 /// &lt;/summary&gt;
 public class TagDataViewModel : BaseViewModel
 {
 /// &lt;summary&gt;
 /// Default constructor
 /// &lt;/summary&gt;
 /// &lt;param name="path"&gt;The JSONPath to this item&lt;/param&gt;
 public TagDataViewModel(string path)
 {
 FullPath = path;
 }

 /// &lt;summary&gt;
 /// Gets and sets the JSONPath to this item
 /// &lt;/summary&gt;
 private string FullPath { get; set; }

 /// &lt;summary&gt;
 /// Gets the name
 /// &lt;/summary&gt;
 public string Name =&gt; ProjectHelpers.GetPropertyValue(FullPath, "Name");

 /// &lt;summary&gt;
 /// Gets the address
 /// &lt;/summary&gt;
 public string Address =&gt; ProjectHelpers.GetPropertyValue(FullPath, "Address");

 /// &lt;summary&gt;
 /// Gets the data type
 /// &lt;/summary&gt;
 public string DataType =&gt; ProjectHelpers.GetPropertyValue(FullPath, "DataType");

 /// &lt;summary&gt;
 /// Gets the scan rate
 /// &lt;/summary&gt;
 public string ScanRate =&gt; ProjectHelpers.GetPropertyValue(FullPath, "ScanRate");

 /// &lt;summary&gt;
 /// Gets the scaling type
 /// &lt;/summary&gt;
 public string ScalingType =&gt; ProjectHelpers.GetPropertyValue(FullPath, "ScalingType");
 }
}
</code></pre>

blocks|key|896497|text|我使用Browsable属性和Visibility:+Collapsed实现了这一点|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|896498|模型|896499|class+CourseModel
{
++++[Description("")]
++++[ReadOnly(false)]
++++public+bool+Select+{+get;+set;+}+=+true;+//+Checkbox

++++[Description("Course+ID")]
++++[ReadOnly(true)]
++++[Browsable(false)]
++++public+string+ID+{+get;+set;+}+//+Hidden+column

++++[Description("Course+Title")]
++++[ReadOnly(true)]
++++public+string+Title+{+get;+set;+}
}|code-block|syntax|javascript|896500|自定义控件扩展：|896501|using+System.ComponentModel;
using+System.Windows;
using+System.Windows.Controls;

namespace+MyProject.FrontEnd.Controls
{
++++class+CustomDataGrid+:+DataGrid
++++{
++++++++//+Take+attributes+of+POCO,+if+available+(https://stackoverflow.com/a/17255496/979621)

++++++++protected+override+void+OnAutoGeneratingColumn(DataGridAutoGeneratingColumnEventArgs+e)
++++++++{
++++++++++++try
++++++++++++{
++++++++++++++++base.OnAutoGeneratingColumn(e);
++++++++++++++++var+propertyDescriptor+=+e.PropertyDescriptor+as+PropertyDescriptor;
++++++++++++++++e.Column.Header+=+propertyDescriptor.Description;
++++++++++++++++e.Column.IsReadOnly+=+propertyDescriptor.IsReadOnly;
++++++++++++++++e.Column.Visibility+=+propertyDescriptor.IsBrowsable+
++++++++++++++++++++++++++++++++++++++?+Visibility.Visible+
++++++++++++++++++++++++++++++++++++++:+Visibility.Collapsed;
++++++++++++}
++++++++++++catch
++++++++++++{
++++++++++++++++//+ignore;+retain+field+defaults
++++++++++++}
++++++++}
++++}
}|896502|ViewModel|896503|public+ObservableCollection<CourseModel>+Courses+{+get;+set;+}|896504|XAML|896505|<Window+
++++...
++++xmlns:controls="clr-namespace:MyProject.FrontEnd.Controls"+
++++...
>
...
<controls:CustomDataGrid+x:Name="courses"+
++++ItemsSource="{Binding+Path=Courses,+Mode=TwoWay,+
++++++++++++++++++NotifyOnSourceUpdated=True,+NotifyOnTargetUpdated=True}"+/>|896506|entityMap^0|3|9|F|L|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|15|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|16|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|17|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|18|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|19|8|@]|D|@]|E|$]]|$1|S|3|T|5|J|7|1A|8|@]|D|@]|E|$K|L]]|$1|U|3|V|5|6|7|1B|8|@]|D|@]|E|$]]|$1|W|3|X|5|J|7|1C|8|@]|D|@]|E|$K|L]]|$1|Y|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|Z|$]]

I achieved this using <code>Browsable</code> attribute and <code>Visibility: Collapsed</code>
Model
<pre class="lang-cs prettyprint-override"><code>class CourseModel
{
 [Description(&quot;&quot;)]
 [ReadOnly(false)]
 public bool Select { get; set; } = true; // Checkbox

 [Description(&quot;Course ID&quot;)]
 [ReadOnly(true)]
 [Browsable(false)]
 public string ID { get; set; } // Hidden column

 [Description(&quot;Course Title&quot;)]
 [ReadOnly(true)]
 public string Title { get; set; }
}
</code></pre>
Custom control extension:
<pre class="lang-cs prettyprint-override"><code>using System.ComponentModel;
using System.Windows;
using System.Windows.Controls;

namespace MyProject.FrontEnd.Controls
{
 class CustomDataGrid : DataGrid
 {
 // Take attributes of POCO, if available (https://stackoverflow.com/a/17255496/979621)

 protected override void OnAutoGeneratingColumn(DataGridAutoGeneratingColumnEventArgs e)
 {
 try
 {
 base.OnAutoGeneratingColumn(e);
 var propertyDescriptor = e.PropertyDescriptor as PropertyDescriptor;
 e.Column.Header = propertyDescriptor.Description;
 e.Column.IsReadOnly = propertyDescriptor.IsReadOnly;
 e.Column.Visibility = propertyDescriptor.IsBrowsable 
 ? Visibility.Visible 
 : Visibility.Collapsed;
 }
 catch
 {
 // ignore; retain field defaults
 }
 }
 }
}
</code></pre>
ViewModel
<pre class="lang-cs prettyprint-override"><code>public ObservableCollection&lt;CourseModel&gt; Courses { get; set; }
</code></pre>
XAML
<pre><code>&lt;Window 
 ...
 xmlns:controls=&quot;clr-namespace:MyProject.FrontEnd.Controls&quot; 
 ...
&gt;
...
&lt;controls:CustomDataGrid x:Name=&quot;courses&quot; 
 ItemsSource=&quot;{Binding Path=Courses, Mode=TwoWay, 
 NotifyOnSourceUpdated=True, NotifyOnTargetUpdated=True}&quot; /&gt;
</code></pre>

I have a WPF 4.0 DataGrid that is bound to a DataTable using AutoGenerateColumns=True. The columns are dynamic, however I know there is always going to be a column named ID and I would like to hide this column. Is there a way I can do this?

Is there a way to hide a specific column in a DataGrid when AutoGenerateColumns=True?

数据网格

Windows

我有一个使用AutoGenerateColumns=True绑定到DataTable的WPF4.0 DataGrid。这些列是动态的，但是我知道总会有一个名为ID的列，我想隐藏这一列。有什么办法可以做到这一点吗？

问当AutoGenerateColumns=True时，有没有办法隐藏DataGrid中的特定列？
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问当AutoGenerateColumns=True时，有没有办法隐藏DataGrid中的特定列？EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问当AutoGenerateColumns=True时，有没有办法隐藏DataGrid中的特定列？
EN