Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Or you could use this grid I just made. It will automatically add a border to every cell in the grid. This is the result:</p> <p><img src="https://i.stack.imgur.com/pZv5O.png" alt="enter image description here"></p> <p>C#:</p> <pre><code>using System.Windows; using System.Windows.Controls; using System.Windows.Media; namespace GridWithBorder { public class BorderGrid : Grid { protected override void OnRender(DrawingContext dc) { double leftOffset = 0; double topOffset = 0; Pen pen = new Pen(Brushes.Black, 3); pen.Freeze(); foreach (RowDefinition row in this.RowDefinitions) { dc.DrawLine(pen, new Point(0, topOffset), new Point(this.ActualWidth, topOffset)); topOffset += row.ActualHeight; } // draw last line at the bottom dc.DrawLine(pen, new Point(0, topOffset), new Point(this.ActualWidth, topOffset)); //foreach (ColumnDefinition column in this.ColumnDefinitions) //{ // dc.DrawLine(pen, new Point(leftOffset, 0), new Point(leftOffset, this.ActualHeight)); // leftOffset += column.ActualWidth; //} // draw last line on the right //dc.DrawLine(pen, new Point(leftOffset, 0), new Point(leftOffset, this.ActualHeight)); base.OnRender(dc); } } } </code></pre> <p>XAML:</p> <pre><code>&lt;Window x:Class="GridWithBorder.MainWindow" xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:local="clr-namespace:GridWithBorder" Title="MainWindow" Height="350" Width="525"&gt; &lt;local:BorderGrid&gt; &lt;local:BorderGrid.RowDefinitions&gt; &lt;RowDefinition /&gt; &lt;RowDefinition /&gt; &lt;RowDefinition /&gt; &lt;/local:BorderGrid.RowDefinitions&gt; &lt;local:BorderGrid.ColumnDefinitions&gt; &lt;ColumnDefinition /&gt; &lt;ColumnDefinition /&gt; &lt;ColumnDefinition /&gt; &lt;ColumnDefinition /&gt; &lt;/local:BorderGrid.ColumnDefinitions&gt; &lt;Rectangle Grid.Row="0" Grid.Column="0" Fill="Red" Margin="5" /&gt; &lt;Rectangle Grid.Row="0" Grid.Column="1" Fill="Blue" Margin="5" /&gt; &lt;Rectangle Grid.Row="0" Grid.Column="2" Fill="Orange" Margin="5" /&gt; &lt;Rectangle Grid.Row="0" Grid.Column="3" Fill="Red" Margin="5" /&gt; &lt;Rectangle Grid.Row="1" Grid.Column="0" Fill="Yellow" Margin="5" /&gt; &lt;Rectangle Grid.Row="1" Grid.Column="1" Fill="Green" Margin="5" /&gt; &lt;Rectangle Grid.Row="1" Grid.Column="2" Fill="Purple" Margin="5" /&gt; &lt;Rectangle Grid.Row="1" Grid.Column="3" Fill="Green" Margin="5" /&gt; &lt;Rectangle Grid.Row="2" Grid.Column="0" Fill="Orange" Margin="5" /&gt; &lt;Rectangle Grid.Row="2" Grid.Column="1" Fill="Red" Margin="5" /&gt; &lt;Rectangle Grid.Row="2" Grid.Column="2" Fill="Blue" Margin="5" /&gt; &lt;Rectangle Grid.Row="2" Grid.Column="3" Fill="Red" Margin="5" /&gt; &lt;/local:BorderGrid&gt; &lt;/Window&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POAssigning border to every Grid row
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USSimon_Weaver
    1. USCarlo
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks, this is clever. I am having a hard time modifying it to put borders around each _row_, not each cell. Nice idea, though, until this point I was trying to do it only in XAML.
      singulars
      1. PO
      1. USdotancohen
    2. CO@dotancohen ah ok, then just comment the part I just commented in the C# code, you'll get this result http://screencast.com/t/NwdxtGQNyq. Lmk if you need the first and last vertical lines (to have the border around the whole grid) I can do that too.
      singulars
      1. PO
      1. USCarlo
    3. CO@dotancohen example of border all around the grid and rows but not the columns here: http://screencast.com/t/d8GNqXRKGPf
      singulars
      1. PO
      1. USCarlo
 

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