Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Sadly, WinForms does not like to have too many controls, especially when you get into the hundreds. You can never have each control paint at the same time since each control will send its own paint message to windows.</p> <p>I think the best way to approach a game board like MineSweeper is to just use one control and draw the grid of buttons.</p> <p>Simple Mine class:</p> <pre><code>public class Mine { public Rectangle Bounds { get; set; } public bool IsBomb { get; set; } public bool IsRevealed { get; set; } } </code></pre> <p>Then create a new control where you inherit from the Panel control and set the DoubleBuffered property to prevent any flicker:</p> <pre><code>public class MineSweeperControl : Panel { private int columns = 16; private int rows = 12; private Mine[,] mines; public MineSweeperControl() { this.DoubleBuffered = true; this.ResizeRedraw = true; // initialize mine field: mines = new Mine[columns, rows]; for (int y = 0; y &lt; rows; ++y) { for (int x = 0; x &lt; columns; ++x) { mines[x, y] = new Mine(); } } } // adjust each column and row to fit entire client area: protected override void OnResize(EventArgs e) { int top = 0; for (int y = 0; y &lt; rows; ++y) { int left = 0; int height = (this.ClientSize.Height - top) / (rows - y); for (int x = 0; x &lt; columns; ++x) { int width = (this.ClientSize.Width - left) / (columns - x); mines[x, y].Bounds = new Rectangle(left, top, width, height); left += width; } top += height; } base.OnResize(e); } protected override void OnPaint(PaintEventArgs e) { e.Graphics.SmoothingMode = SmoothingMode.AntiAlias; for (int y = 0; y &lt; rows; ++y) { for (int x = 0; x &lt; columns; ++x) { if (mines[x, y].IsRevealed) { e.Graphics.FillRectangle(Brushes.DarkGray, mines[x, y].Bounds); } else { ControlPaint.DrawButton(e.Graphics, mines[x, y].Bounds, ButtonState.Normal); } } } base.OnPaint(e); } // determine which button the user pressed: protected override void OnMouseDown(MouseEventArgs e) { for (int y = 0; y &lt; rows; ++y) { for (int x = 0; x &lt; columns; ++x) { if (mines[x, y].Bounds.Contains(e.Location)) { mines[x, y].IsRevealed = true; this.Invalidate(); MessageBox.Show( string.Format("You pressed on button ({0}, {1})", x.ToString(), y.ToString()) ); } } } base.OnMouseDown(e); } } </code></pre> <p><img src="https://i.stack.imgur.com/pz1dB.png" alt="enter image description here"></p>
    singulars
    1. This table or related slice is empty.
    1. POForeach loop to create 100 buttons, painting all buttons at same time as to prevent flicker
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USLarsTech
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POForeach loop to create 100 buttons, painting all buttons at same time as to prevent flicker
      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. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThat's clever... I'm liking this. Now to see if I can wrap my head around the code.
      singulars
      1. PO
      1. USAnteara
    2. COAlright, I made a pastebin trying to understand the code since it's too long to post here. http://pastebin.com/tUpkM77G I would appreciate it if you could review that and tell me anything I have wrong (terminology too), as I appreciate the chance to learn when I can. This is a great answer so I'll set it as accepted.
      singulars
      1. PO
      1. USAnteara
    3. COJust an update.. I've noticed that the clicking of buttons gets slow when I'm using an image for the buttons. This is how I'm doing it: `ControlPaint.DrawButton(e.Graphics, mines[x, y].Bounds, ButtonState.Normal);` `e.Graphics.DrawImage(mineImage, mines[x, y].Bounds);` I think I need a faster way of getting the button clicks as opposed to going through each element of the array until I get to where I clicked. It might also be because of the format of the image. I'll try PixelFormat.Format32bppPArgb if I can. Can you give any suggestions for the clicking algorithm?
      singulars
      1. PO
      1. USAnteara
 

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