Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Put this in your resources change the part surrounded by ** to:</p> <pre><code>**&lt;whatever xmlns:MyDataGridColumnHeadersPresenter x:Name="PART_ColumnHeadersPresenter" Visibility="{Binding HeadersVisibility, ConverterParameter={x:Static DataGridHeadersVisibility.Column}, Converter={x:Static DataGrid.HeadersVisibilityConverter}, RelativeSource={RelativeSource AncestorType={x:Type DataGrid}}}"/&gt;** &lt;Style x:Key="DataGridStyle1" TargetType="{x:Type DataGrid}"&gt; &lt;Setter Property="Background" Value="{DynamicResource {x:Static SystemColors.ControlBrushKey}}"/&gt; &lt;Setter Property="Foreground" Value="{DynamicResource {x:Static SystemColors.ControlTextBrushKey}}"/&gt; &lt;Setter Property="BorderBrush" Value="#FF688CAF"/&gt; &lt;Setter Property="BorderThickness" Value="1"/&gt; &lt;Setter Property="RowDetailsVisibilityMode" Value="VisibleWhenSelected"/&gt; &lt;Setter Property="ScrollViewer.CanContentScroll" Value="true"/&gt; &lt;Setter Property="ScrollViewer.PanningMode" Value="Both"/&gt; &lt;Setter Property="Stylus.IsFlicksEnabled" Value="False"/&gt; &lt;Setter Property="Template"&gt; &lt;Setter.Value&gt; &lt;ControlTemplate TargetType="{x:Type DataGrid}"&gt; &lt;Border BorderBrush="{TemplateBinding BorderBrush}" BorderThickness="{TemplateBinding BorderThickness}" Background="{TemplateBinding Background}" Padding="{TemplateBinding Padding}" SnapsToDevicePixels="True"&gt; &lt;ScrollViewer x:Name="DG_ScrollViewer" Focusable="false"&gt; &lt;ScrollViewer.Template&gt; &lt;ControlTemplate TargetType="{x:Type ScrollViewer}"&gt; &lt;Grid&gt; &lt;Grid.ColumnDefinitions&gt; &lt;ColumnDefinition Width="Auto"/&gt; &lt;ColumnDefinition Width="*"/&gt; &lt;ColumnDefinition Width="Auto"/&gt; &lt;/Grid.ColumnDefinitions&gt; &lt;Grid.RowDefinitions&gt; &lt;RowDefinition Height="Auto"/&gt; &lt;RowDefinition Height="*"/&gt; &lt;RowDefinition Height="Auto"/&gt; &lt;/Grid.RowDefinitions&gt; &lt;Button Command="{x:Static DataGrid.SelectAllCommand}" Focusable="false" Style="{DynamicResource {ComponentResourceKey ResourceId=DataGridSelectAllButtonStyle, TypeInTargetAssembly={x:Type DataGrid}}}" Visibility="{Binding HeadersVisibility, ConverterParameter={x:Static DataGridHeadersVisibility.All}, Converter={x:Static DataGrid.HeadersVisibilityConverter}, RelativeSource={RelativeSource AncestorType={x:Type DataGrid}}}" Width="{Binding CellsPanelHorizontalOffset, RelativeSource={RelativeSource AncestorType={x:Type DataGrid}}}"/&gt; &lt;Grid Grid.Column="1"&gt; &lt;Grid.RowDefinitions&gt; &lt;RowDefinition Height="Auto" /&gt; &lt;RowDefinition Height="Auto" /&gt; &lt;/Grid.RowDefinitions&gt; **&lt;DataGridColumnHeadersPresenter x:Name="PART_ColumnHeadersPresenter" Visibility="{Binding HeadersVisibility, ConverterParameter={x:Static DataGridHeadersVisibility.Column}, Converter={x:Static DataGrid.HeadersVisibilityConverter}, RelativeSource={RelativeSource AncestorType={x:Type DataGrid}}}"/&gt;** &lt;StackPanel Orientation="Horizontal" Grid.Row = "1" Grid.Column="1" &gt;&lt;Button Height="100"&gt;test&lt;/Button&gt; &lt;Button Height="100"&gt;test&lt;/Button&gt; &lt;Button Height="100"&gt;test&lt;/Button&gt; &lt;Button Height="100"&gt;test&lt;/Button&gt; &lt;/StackPanel&gt; &lt;/Grid&gt;&lt;ScrollContentPresenter x:Name="PART_ScrollContentPresenter" CanContentScroll="{TemplateBinding CanContentScroll}" Grid.ColumnSpan="2" Grid.Row="1"/&gt; &lt;ScrollBar x:Name="PART_VerticalScrollBar" Grid.Column="2" Maximum="{TemplateBinding ScrollableHeight}" Orientation="Vertical" Grid.Row="1" Visibility="{TemplateBinding ComputedVerticalScrollBarVisibility}" Value="{Binding VerticalOffset, Mode=OneWay, RelativeSource={RelativeSource TemplatedParent}}" ViewportSize="{TemplateBinding ViewportHeight}"/&gt; &lt;Grid Grid.Column="1" Grid.Row="2"&gt; &lt;Grid.ColumnDefinitions&gt; &lt;ColumnDefinition Width="{Binding NonFrozenColumnsViewportHorizontalOffset, RelativeSource={RelativeSource AncestorType={x:Type DataGrid}}}"/&gt; &lt;ColumnDefinition Width="*"/&gt; &lt;/Grid.ColumnDefinitions&gt; &lt;ScrollBar x:Name="PART_HorizontalScrollBar" Grid.Column="1" Maximum="{TemplateBinding ScrollableWidth}" Orientation="Horizontal" Visibility="{TemplateBinding ComputedHorizontalScrollBarVisibility}" Value="{Binding HorizontalOffset, Mode=OneWay, RelativeSource={RelativeSource TemplatedParent}}" ViewportSize="{TemplateBinding ViewportWidth}"/&gt; &lt;/Grid&gt; &lt;/Grid&gt; &lt;/ControlTemplate&gt; &lt;/ScrollViewer.Template&gt; &lt;ItemsPresenter SnapsToDevicePixels="{TemplateBinding SnapsToDevicePixels}"/&gt; &lt;/ScrollViewer&gt; &lt;/Border&gt; &lt;/ControlTemplate&gt; &lt;/Setter.Value&gt; &lt;/Setter&gt; &lt;Style.Triggers&gt; &lt;Trigger Property="IsGrouping" Value="true"&gt; &lt;Setter Property="ScrollViewer.CanContentScroll" Value="false"/&gt; &lt;/Trigger&gt; &lt;/Style.Triggers&gt; &lt;/Style&gt; </code></pre> <p>Declare your grid in xaml like this:</p> <pre><code>&lt;DataGrid Margin="30,30,36,23" Grid.Row="1" Style="{DynamicResource DataGridStyle1}"&gt; &lt;DataGrid.Columns&gt; &lt;DataGridTextColumn Header="fiorst"/&gt; &lt;DataGridTextColumn Header="semd"/&gt; &lt;/DataGrid.Columns&gt; &lt;/DataGrid&gt; </code></pre> <p>Notice the stack panel with the buttons you can put whatever you want over there. Hope this helps</p> <p>If you want to change the DataGridColumnsHeaderPresenter I would do it like this.</p> <pre><code>[TemplatePart(Name = "PART_ItemsHolder", Type = typeof(Panel))] public class MyDataGridColumnsHeaderPresenter:DataGridColumnsHeaderPresenter { private Panel _itemsHolder = null; public override void OnApplyTemplate() { base.OnApplyTemplate(); _itemsHolder = GetTemplateChild("PART_ItemsHolder") as Panel; } //for whatever other functionality you need for the sorting you can use the _itemsHolder variable } </code></pre> <p>This is the default template for the presenter:</p> <pre><code>&lt;ControlTemplate TargetType="{x:Type DataGridColumnHeadersPresenter}"&gt; &lt;Grid&gt; &lt;DataGridColumnHeader IsHitTestVisible="False" Name="PART_FillerColumnHeader"/&gt; &lt;ItemsPresenter /&gt; &lt;/Grid&gt; &lt;/ControlTemplate&gt; </code></pre> <p>I would change it to something like this:</p> <pre><code>&lt;ControlTemplate TargetType="{x:Type MyDataGridColumnHeadersPresenter}"&gt; &lt;Grid&gt; &lt;Grid.RowDefinitions&gt; &lt;RowDefinition Height = "Auto" /&gt; &lt;RowDefinition Height = "Auto" /&gt; &lt;/Grid.RowDefinitions&gt; &lt;DataGridColumnHeader IsHitTestVisible="False" Name="PART_FillerColumnHeader"/&gt; &lt;ItemsPresenter Grid.Row="0" /&gt; &lt;StackPanel Grid.Row="1" x:Name="PART_ItemsHolder /&gt; &lt;/Grid&gt; &lt;/ControlTemplate&gt; </code></pre> <p>Here is the style for the default DataGrid </p> <pre><code>&lt;Style x:Key="{ComponentResourceKey ResourceId=DataGridSelectAllButtonStyle, TypeInTargetAssembly={x:Type DataGrid}}" TargetType="{x:Type Button}"&gt; &lt;Setter Property="Template"&gt; &lt;Setter.Value&gt; &lt;ControlTemplate TargetType="{x:Type Button}"&gt; &lt;Grid&gt; &lt;Rectangle x:Name="Border" Fill="{DynamicResource {x:Static SystemColors.ControlBrushKey}}" SnapsToDevicePixels="True"/&gt; &lt;Polygon x:Name="Arrow" Fill="Black" HorizontalAlignment="Right" Margin="8,8,3,3" Opacity="0.15" Points="0,10 10,10 10,0" Stretch="Uniform" VerticalAlignment="Bottom"/&gt; &lt;/Grid&gt; &lt;ControlTemplate.Triggers&gt; &lt;Trigger Property="IsMouseOver" Value="True"&gt; &lt;Setter Property="Stroke" TargetName="Border" Value="{DynamicResource {x:Static SystemColors.ControlDarkBrushKey}}"/&gt; &lt;/Trigger&gt; &lt;Trigger Property="IsPressed" Value="True"&gt; &lt;Setter Property="Fill" TargetName="Border" Value="{DynamicResource {x:Static SystemColors.ControlDarkBrushKey}}"/&gt; &lt;/Trigger&gt; &lt;Trigger Property="IsEnabled" Value="False"&gt; &lt;Setter Property="Visibility" TargetName="Arrow" Value="Collapsed"/&gt; &lt;/Trigger&gt; &lt;/ControlTemplate.Triggers&gt; &lt;/ControlTemplate&gt; &lt;/Setter.Value&gt; &lt;/Setter&gt; &lt;/Style&gt; &lt;Style x:Key="DataGridStyle1" TargetType="{x:Type DataGrid}"&gt; &lt;Setter Property="Background" Value="{DynamicResource {x:Static SystemColors.ControlBrushKey}}"/&gt; &lt;Setter Property="Foreground" Value="{DynamicResource {x:Static SystemColors.ControlTextBrushKey}}"/&gt; &lt;Setter Property="BorderBrush" Value="#FF688CAF"/&gt; &lt;Setter Property="BorderThickness" Value="1"/&gt; &lt;Setter Property="RowDetailsVisibilityMode" Value="VisibleWhenSelected"/&gt; &lt;Setter Property="ScrollViewer.CanContentScroll" Value="true"/&gt; &lt;Setter Property="ScrollViewer.PanningMode" Value="Both"/&gt; &lt;Setter Property="Stylus.IsFlicksEnabled" Value="False"/&gt; &lt;Setter Property="Template"&gt; &lt;Setter.Value&gt; &lt;ControlTemplate TargetType="{x:Type DataGrid}"&gt; &lt;Border BorderBrush="{TemplateBinding BorderBrush}" BorderThickness="{TemplateBinding BorderThickness}" Background="{TemplateBinding Background}" Padding="{TemplateBinding Padding}" SnapsToDevicePixels="True"&gt; &lt;ScrollViewer x:Name="DG_ScrollViewer" Focusable="false"&gt; &lt;ScrollViewer.Template&gt; &lt;ControlTemplate TargetType="{x:Type ScrollViewer}"&gt; &lt;Grid&gt; &lt;Grid.ColumnDefinitions&gt; &lt;ColumnDefinition Width="Auto"/&gt; &lt;ColumnDefinition Width="*"/&gt; &lt;ColumnDefinition Width="Auto"/&gt; &lt;/Grid.ColumnDefinitions&gt; &lt;Grid.RowDefinitions&gt; &lt;RowDefinition Height="Auto"/&gt; &lt;RowDefinition Height="*"/&gt; &lt;RowDefinition Height="Auto"/&gt; &lt;/Grid.RowDefinitions&gt; &lt;Button Command="{x:Static DataGrid.SelectAllCommand}" Focusable="false" Style="{DynamicResource {ComponentResourceKey ResourceId=DataGridSelectAllButtonStyle, TypeInTargetAssembly={x:Type DataGrid}}}" Visibility="{Binding HeadersVisibility, ConverterParameter={x:Static DataGridHeadersVisibility.All}, Converter={x:Static DataGrid.HeadersVisibilityConverter}, RelativeSource={RelativeSource AncestorType={x:Type DataGrid}}}" Width="{Binding CellsPanelHorizontalOffset, RelativeSource={RelativeSource AncestorType={x:Type DataGrid}}}"/&gt; &lt;Grid Grid.Column="1"&gt; &lt;Grid.RowDefinitions&gt; &lt;RowDefinition Height="Auto" /&gt; &lt;RowDefinition Height="Auto" /&gt; &lt;/Grid.RowDefinitions&gt; &lt;DataGridColumnHeadersPresenter x:Name="PART_ColumnHeadersPresenter" Visibility="{Binding HeadersVisibility, ConverterParameter={x:Static DataGridHeadersVisibility.Column}, Converter={x:Static DataGrid.HeadersVisibilityConverter}, RelativeSource={RelativeSource AncestorType={x:Type DataGrid}}}"/&gt; &lt;StackPanel Orientation="Horizontal" Grid.Row = "1" Grid.Column="1" &gt;&lt;Button Height="100"&gt;test&lt;/Button&gt; &lt;Button Height="100"&gt;test&lt;/Button&gt; &lt;Button Height="100"&gt;test&lt;/Button&gt; &lt;Button Height="100"&gt;test&lt;/Button&gt; &lt;/StackPanel&gt; &lt;/Grid&gt;&lt;ScrollContentPresenter x:Name="PART_ScrollContentPresenter" CanContentScroll="{TemplateBinding CanContentScroll}" Grid.ColumnSpan="2" Grid.Row="1"/&gt; &lt;ScrollBar x:Name="PART_VerticalScrollBar" Grid.Column="2" Maximum="{TemplateBinding ScrollableHeight}" Orientation="Vertical" Grid.Row="1" Visibility="{TemplateBinding ComputedVerticalScrollBarVisibility}" Value="{Binding VerticalOffset, Mode=OneWay, RelativeSource={RelativeSource TemplatedParent}}" ViewportSize="{TemplateBinding ViewportHeight}"/&gt; &lt;Grid Grid.Column="1" Grid.Row="2"&gt; &lt;Grid.ColumnDefinitions&gt; &lt;ColumnDefinition Width="{Binding NonFrozenColumnsViewportHorizontalOffset, RelativeSource={RelativeSource AncestorType={x:Type DataGrid}}}"/&gt; &lt;ColumnDefinition Width="*"/&gt; &lt;/Grid.ColumnDefinitions&gt; &lt;ScrollBar x:Name="PART_HorizontalScrollBar" Grid.Column="1" Maximum="{TemplateBinding ScrollableWidth}" Orientation="Horizontal" Visibility="{TemplateBinding ComputedHorizontalScrollBarVisibility}" Value="{Binding HorizontalOffset, Mode=OneWay, RelativeSource={RelativeSource TemplatedParent}}" ViewportSize="{TemplateBinding ViewportWidth}"/&gt; &lt;/Grid&gt; &lt;/Grid&gt; &lt;/ControlTemplate&gt; &lt;/ScrollViewer.Template&gt; &lt;ItemsPresenter SnapsToDevicePixels="{TemplateBinding SnapsToDevicePixels}"/&gt; &lt;/ScrollViewer&gt; &lt;/Border&gt; &lt;/ControlTemplate&gt; &lt;/Setter.Value&gt; &lt;/Setter&gt; &lt;Style.Triggers&gt; &lt;Trigger Property="IsGrouping" Value="true"&gt; &lt;Setter Property="ScrollViewer.CanContentScroll" Value="false"/&gt; &lt;/Trigger&gt; &lt;/Style.Triggers&gt; &lt;/Style&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POExtending DataGrid/Changing DataGrid header
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDIF
    1. USWegged
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POExtending DataGrid/Changing DataGrid header
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTBountyClose
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThis changes visual layout but it does not add functionality. Most likely I will need to use custom `DataGridColumnsHeaderPresenter` that adds new functions. How do I replace the original one ?
      singulars
      1. PO
      1. USdrasto
    2. COI dont think you need to change DataGridColumnsHeaderPresenter it inherits from itemscontrol that generates the column headers and I am not sure it is the logical place to add this panel. If you do want to go that route though I would create a new class inheriting from it and adding a template part for the panel. Ill add some code for this to my answer. A better idea may be to actually extend the DataGrid control itself.
      singulars
      1. PO
      1. USWegged
    3. CO@Wegged +1 for your edit. actually I'll extend `DataGrid` but I have to replace `DataGridColumnsHeaderPresenter` for sure... That si because I want to override default drag&drop functionality of `DataGridColumnsHeaderPresenter` so that the user will be able to drag column headers to the area above where he can drop it to group by that column.
      singulars
      1. PO
      1. USdrasto
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload