The `DataGridColumn` is not actually part of the `VisualTree`, so bindings on the class cannot find their source

You can set things like the `Visibility` and `Width` property in the `CellStyle` or `HeaderStyle` of the `DataGridColumn`, although that isn't quite the same.

The closest I've found to a solution would be to create a [Freezable][1] object in your `<DataGrid.Resources>` that stores the binding, then use that `StaticResource` in the `Visibility` binding. It's not a pretty solution, but it's the only one I can find at this time.

You can view of an example of it [here][2]

 <DataGrid.Resources>
 <local:BindingProxy x:Key="proxy" Data="{Binding IsChecked, 
 ElementName=IncludeFullHist, 
 Converter={StaticResource boolItemsConverter}}" />
 </DataGrid.Resources>

 <DataGridTextColumn Header="First Name" Binding="{Binding Path=FirstName}"
 Visibility="{Binding Path=Data, Source={StaticResource proxy}}"/> 

 [1]: http://msdn.microsoft.com/en-us/library/system.windows.freezable.aspx
 [2]: http://www.thomaslevesque.com/2011/03/21/wpf-how-to-bind-to-data-when-the-datacontext-is-not-inherited/

I have a datagrid whose `ItemsSource` binds to a `CollectionViewSource`. 
In each column I specify the `Path` property of the binding to get the specific information to display.

What I'd like to do is toggle some of the columns with a checkbox if the user wants more info. To do this, I need to bind the visibility property to the value of the checkbox (with a converter) but I'm pretty sure the data context of the column is interfering with the binding.



 <DataGrid ItemsSource="{Binding Source={StaticResource cvs}}" ....>
 <DataGrid.Columns>
 <DataGridTextColumn Header="First Name" Binding="{Binding Path=FirstName}"
 Visibility="{Binding IsChecked,
 ElementName=IncludeFullHist, 
 Converter={StaticResource boolItemsConverter}}"/> 
 </DataGrid.Columns>
 </DataGrid>


I need the checkbox in my viewmodel as well, so I have its `IsChecked` property bound to a property on my ViewModel



 <CheckBox x:Name="IncludeFullHist" IsChecked="{Binding Path=ManagerFullHist }" />

---

For other elements in my page, I've been able to hook up visibility bindings with either of the two following methods, but neither seem to work when I copy them over into the datagrid:



 <TextBlock DockPanel.Dock="Left" Text=" Visible 2 " 
 Visibility="{Binding Path=DataContext.ManagerFullHist,
 RelativeSource={RelativeSource FindAncestor,
 AncestorType={x:Type UserControl}},
 Converter={StaticResource boolItemsConverter}}"/>
 <TextBlock DockPanel.Dock="Left" Text=" Visible 3 " 
 Visibility="{Binding Path=ManagerFullHist, 
 Source={StaticResource mainWinResource},
 Converter={StaticResource boolItemsConverter}}"/>

Any suggestions on ways that I can solve this in the datagrid? 
Please let me know if I've omitted any code that could be potentially helpful.

Bind DataGridTextColumn Visibility Property in WPF

If you don't want to download the WPF ToolKit (which has both the IntegerUpDown control or a MaskedTextBox), you can implement it yourself as adapted from this article on [Masked TextBox In WPF][1] using the [**`UIElement.PreviewTextInput`**][2] and [**`DataObject.Pasting`**][3] events.


Here's what you would put in your window:



<pre><code>&lt;Window x:Class="WpfApp1.MainWindow" Title="MainWindow" 
 xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
 xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"&gt;
 &lt;StackPanel Orientation="Vertical" Width="100" Height="100" HorizontalAlignment="Left" VerticalAlignment="Top"&gt;

 &lt;TextBlock Name="NumericLabel1" Text="Enter Value:" /&gt;
 &lt;TextBox Name="NumericInput1" 
 PreviewTextInput="MaskNumericInput" 
 DataObject.Pasting="MaskNumericPaste" /&gt;
 &lt;/StackPanel&gt;
&lt;/Window&gt;</code></pre>



And then implement the C# in your codebehind:




<pre><code>public partial class MainWindow : Window
{
 public MainWindow()
 {
 InitializeComponent();
 }

 private void MaskNumericInput(object sender, TextCompositionEventArgs e)
 {
 e.Handled = !TextIsNumeric(e.Text);
 }

 private void MaskNumericPaste(object sender, DataObjectPastingEventArgs e)
 {
 if (e.DataObject.GetDataPresent(typeof(string)))
 {
 string input = (string)e.DataObject.GetData(typeof(string));
 if (!TextIsNumeric(input)) e.CancelCommand();
 }
 else
 {
 e.CancelCommand();
 }
 }

 private bool TextIsNumeric(string input)
 {
 return input.All(c => Char.IsDigit(c) || Char.IsControl(c));
 }
}</code></pre>


[1]: https://www.c-sharpcorner.com/uploadfile/rahul4_saxena/masked-textbox-in-wpf/
[2]: https://learn.microsoft.com/en-us/dotnet/api/system.windows.uielement.previewtextinput?view=netframework-4.7.2
[3]: https://learn.microsoft.com/en-us/dotnet/api/system.windows.dataobject.pasting?view=netframework-4.7.2

Do you know how to restrict user input in textbox, this textbox only accepts integer? By the way I'm developing for Windows 8. I've tried what I searched from SO and from Google but it's not working,

How to accept only integers in a WPF textbox

Here's an extension method to output to any DataTable to a csv (which excel can open)



	Imports System.Text
	Imports System.IO
	Imports System.Runtime.CompilerServices

	Module ExtensionMethods

		<Extension()> _
		Public Sub OutputAsCSV(ByVal dt As DataTable, ByVal filePath As String)
			Dim sb As New StringBuilder()
					
					'write column names to string builder
			Dim columnNames As String() = (From col As DataColumn In dt.Columns Select col.ColumnName).ToArray
			sb.AppendLine(String.Join(",", columnNames))
					
					'write cell value in each row to string builder
			For Each row As DataRow In dt.Rows
				Dim fields As String() = (From cell In row.ItemArray Select CStr(cell)).ToArray
				sb.AppendLine(String.Join(",", fields))
			Next
					
					'write string builder to file
			File.WriteAllText(filePath, sb.ToString())
		End Sub

	End Module

I have a datagrid which populates a datatable, I want to export the DataTable to excel on click of a button. I am using MVVM for this application. So is it ok to implement the export feature in my view? 

Secondly, as i am using xaml and desktop application, how do i capture the grid and its details.

Can any one suggest me some pointers? I am new to this.

Thanks,
Sagar

DataTable to excel conversion

Well this is silly, but it [looks like][SO] the `VisualStateManager.VisualStateGroups` needs to be inside of the Page's child element, which in this case is `Grid`. I'll accept any other answer that can explain why that is. 

**MainView.xaml.vb**:



 <Page x:Name="PageRoot"
 x:Class="WinStoreMvvmTemplate.View.MainView"
 xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
 xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">
 
 <Grid Background="Red" x:Name="ContentGrid">
 
 <VisualStateManager.VisualStateGroups>
 <VisualStateGroup>
 <VisualState x:Name="RegularLayout"/>
 <VisualState x:Name="SmallLayout">
 <Storyboard>
 <ObjectAnimationUsingKeyFrames 
 Storyboard.TargetName="ContentGrid"
 Storyboard.TargetProperty="Background">
 <DiscreteObjectKeyFrame KeyTime="0" Value="Blue"/>
 </ObjectAnimationUsingKeyFrames>
 </Storyboard>
 </VisualState>
 </VisualStateGroup>
 </VisualStateManager.VisualStateGroups>
 
 </Grid>
 </Page>

[SO]: https://stackoverflow.com/q/19735860/1366033

I'm trying to add some screen size breakpoints to a Xaml/VB app in Windows 8.1. I'm handling the SizeChanged event in the codebehind for my main view, and calling `VisualStateManager.GoToState` which should propagate to the predefined Visual States that are sitting in my .xaml file. Here's the entire bit of code for a tiny example that should change the background color on a small screen, but doesn't.

**MainView.xaml**:



 <Page x:Name="PageRoot"
 x:Class="WinStoreMvvmTemplate.MainView"
 xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
 xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">

 <Grid Background="Red" x:Name="ContentGrid"></Grid>
 
 <VisualStateManager.VisualStateGroups>
 <VisualStateGroup>
 <VisualState x:Name="SmallLayout">
 <Storyboard>
 <ObjectAnimationUsingKeyFrames 
 Storyboard.TargetName="ContentGrid"
 Storyboard.TargetProperty="Background">
 <DiscreteObjectKeyFrame KeyTime="0" Value="Blue"/>
 </ObjectAnimationUsingKeyFrames>
 </Storyboard>
 </VisualState>
 </VisualStateGroup>
 </VisualStateManager.VisualStateGroups>
 </Page>

**MainView.xaml.vb**:



 Public NotInheritable Class MainView : Inherits Page

 Private Sub WindowSizeChanged(sender As Object, e As SizeChangedEventArgs) _
 Handles Me.SizeChanged
 If e.NewSize.Width < 340 Then
 VisualStateManager.GoToState(Me, "SmallLayout", True)
 End If
 End Sub

 End Class

The event is definitely firing on the code end and the `GoToState` method is definitely being called.

Any idea why the xaml isn't picking up these changes?