C# Discussion Boards - CodeProject

Strange problems with DataGridView with Panels in the heading [modified]

arnold_w13-Jan-10 3:36

13-Jan-10 3:36

I want to be able to add a Panel with controls onto the headings of a DataGridView. I have come pretty far, but now I am stuck with two issues. The code is rather complex with lots of events so in order to be able to help me with these issues, you probably have to reproduce the problem and see them for yourself. Unfortunately, this means I have to include lots of code in this post and please accept my apologies for doing that. The issues I am asking for help with are the following:
1. If you sort the last column, the last column scrolls a little bit for some reason.
2. If I don't add any rows to the table and scroll horizontically, the Panels in the headings don't move.

public partial class Form1 : Form
{
  private Table table;
  public Form1()
  {
    InitializeComponent();
    this.Load += new EventHandler(Form1_Load);
    table = new Table(new string[] { "Column 1", "Column 2", "Column 3" });
    table.Location = new Point(0, 0);
    table.Size = new Size(300, 300);

    table.addRows(new string[][] {
      new string[] { "Row 00, Column 0", "Row 00, Column 1", "Row 00, Column 2" },
      new string[] { "Row 01, Column 0", "Row 01, Column 1", "Row 01, Column 2" },
      new string[] { "Row 02, Column 0", "Row 02, Column 1", "Row 02, Column 2" },
      new string[] { "Row 03, Column 0", "Row 03, Column 1", "Row 03, Column 2" },
      new string[] { "Row 04, Column 0", "Row 04, Column 1", "Row 04, Column 2" },
      new string[] { "Row 05, Column 0", "Row 05, Column 1", "Row 05, Column 2" },
      new string[] { "Row 06, Column 0", "Row 06, Column 1", "Row 06, Column 2" },
      new string[] { "Row 07, Column 0", "Row 07, Column 1", "Row 07, Column 2" },
      new string[] { "Row 08, Column 0", "Row 08, Column 1", "Row 08, Column 2" },
      new string[] { "Row 09, Column 0", "Row 09, Column 1", "Row 09, Column 2" },
      new string[] { "Row 10, Column 0", "Row 10, Column 1", "Row 10, Column 2" },
      new string[] { "Row 11, Column 0", "Row 11, Column 1", "Row 11, Column 2" },
      new string[] { "Row 12, Column 0", "Row 12, Column 1", "Row 12, Column 2" }
    });

    this.Controls.Add(table);
  }


  private void Form1_Load(object sender, System.EventArgs e)
  {
    table.parentFormLoad();
  }
}


public class Table : Control
{
  private DataGridView dataGridView = new DataGridView();
  private DataTable dataTable = new DataTable();
  private DataColumn[] dataColumns;

  public Table(string[] columnHeadings)
  {
    this.SizeChanged += new EventHandler(Control_SizeChanged);
    dataGridView.AllowUserToAddRows = false;
    dataGridView.AllowUserToDeleteRows = false;
    dataGridView.AllowUserToOrderColumns = false;
    dataGridView.Dock = DockStyle.Fill;

    dataGridView.DataSource = dataTable;
    if (columnHeadings != null)
    {
      dataColumns = new DataColumn[columnHeadings.Length];
      for (int i = 0; i < columnHeadings.Length; i++)
      {
        dataColumns[i] = new GenericDataColumn(i, columnHeadings[i], new MinMaxDatePanel(), dataGridView);
        dataTable.Columns.Add(dataColumns[i]);
      }
    }
    this.Controls.AddRange(new Control[] { dataGridView });
  }


  public void parentFormLoad()
  {
    dataGridView.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
    dataGridView.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;

    int maxColumnHeight = dataGridView.ColumnHeadersHeight;
    for (int i = 0; i < dataColumns.Length; i++)
    {
      if (maxColumnHeight < ((GenericDataColumn)dataColumns[i]).recommendedSize.Height)
      {
        maxColumnHeight = ((GenericDataColumn)dataColumns[i]).recommendedSize.Height;
      }
      dataGridView.Columns[i].Width = ((GenericDataColumn)dataColumns[i]).recommendedSize.Width;
      ((GenericDataColumn)dataColumns[i]).parentDataGridViewFinishedLoading();
    }
    dataGridView.ColumnHeadersHeight = maxColumnHeight;
  }


  private void Control_SizeChanged(object sender, EventArgs e)
  {
    dataGridView.Size = this.Size;
  }


  public void addRows(string[][] cellValues)
  {
    for (int i = 0; i < cellValues.Length; i++)
    {
      dataTable.Rows.Add(cellValues[i]);
    }
  }
}


public class MinMaxDatePanel : Panel
{
  private const int STANDARD_COLUMN_HEIGHT = 23;
  private const int DATEPICKER_WIDTH = 130;
  private int LABEL_WIDTH;
  private Label minDateLabel;
  private Label maxDateLabel;
  private DateTimePicker minDatePicker;
  private DateTimePicker maxDatePicker;


  public MinMaxDatePanel()
  {
    // Determine width of label
    Label dummyLabel = new Label();
    dummyLabel.Text = "Start Date:";
    dummyLabel.Visible = false;
    dummyLabel.AutoSize = true;
    this.Controls.Add(dummyLabel);
    LABEL_WIDTH = dummyLabel.Width;
    this.Controls.Remove(dummyLabel);


    this.minDatePicker = new DateTimePicker();
    this.maxDatePicker = new DateTimePicker();
    this.minDatePicker.Width = DATEPICKER_WIDTH;
    this.maxDatePicker.Width = DATEPICKER_WIDTH;
    this.minDatePicker.Location = new Point(LABEL_WIDTH, 0);
    this.maxDatePicker.Location = new Point(minDatePicker.Location.X, STANDARD_COLUMN_HEIGHT);
    this.minDatePicker.ShowCheckBox = true;
    this.maxDatePicker.ShowCheckBox = true;
    this.minDatePicker.MinDate = new DateTime(2005, 01, 01);
    this.maxDatePicker.MinDate = new DateTime(2005, 01, 01);
    this.minDatePicker.MaxDate = new DateTime(2099, 12, 31);
    this.maxDatePicker.MaxDate = new DateTime(2099, 12, 31);
    this.minDatePicker.Value = this.minDatePicker.MinDate;
    this.maxDatePicker.Value = this.maxDatePicker.MaxDate;
    this.minDatePicker.Checked = false;
    this.maxDatePicker.Checked = false;

    this.minDateLabel = new Label();
    this.maxDateLabel = new Label();
    this.minDateLabel.Text = "Start Date:";
    this.maxDateLabel.Text = "End Date:";
    this.minDateLabel.Width = LABEL_WIDTH;
    this.maxDateLabel.Width = LABEL_WIDTH;
    this.minDateLabel.Location = new Point(0, minDatePicker.Location.Y + 2);
    this.maxDateLabel.Location = new Point(0, maxDatePicker.Location.Y + 2);
    this.Size = new Size(this.minDatePicker.Location.X + this.minDatePicker.Width + 3, 2 * STANDARD_COLUMN_HEIGHT);

    this.Controls.AddRange(new Control[] {
      minDateLabel, maxDateLabel,
      minDatePicker, maxDatePicker});
  }
}


public class GenericDataColumn : DataColumn
{
  private Size STANDARD_COLUMN_SIZE = new Size(120, 23);
  private int columnIndex;
  private Size uncutPanelSize = new Size(0, 0);
  private Point[] initialControlLocations;
  private DataGridView dataGridView;
  private Panel panel;
  private SortType sortType = SortType.None;

  public GenericDataColumn(int columnIndex,
                           string columnName,
                           Panel panel,
                           DataGridView dataGridView)
  {
    this.columnIndex = columnIndex;
    this.ColumnName = columnName;
    this.dataGridView = dataGridView;
    this.panel = panel;
    if (panel != null)
    {
      this.uncutPanelSize = panel.Size;
      this.initialControlLocations = new Point[panel.Controls.Count];
      for (int i = 0; i < panel.Controls.Count; i++)
      {
        initialControlLocations[i] = panel.Controls[i].Location;
      }
      // Set the correct vertical position of the panel. Set the horisontal position
      // to something outside of the dataGridView.
      this.panel.Location = new Point(Int32.MaxValue, STANDARD_COLUMN_SIZE.Height + 1);
    }
    dataGridView.Controls.Add(this.panel);
  }


  public Size recommendedSize
  {
    get
    {
      if (panel == null)
      {
        return STANDARD_COLUMN_SIZE;
      }
      else
      {
        // Maybe check maximum of size of header text and panel size
        return new Size(uncutPanelSize.Width + 2, STANDARD_COLUMN_SIZE.Height + uncutPanelSize.Height + 1);
      }
    }
  }


  public void parentDataGridViewFinishedLoading()
  {
    dataGridView.Paint += new PaintEventHandler(dataGridView_Paint);
    dataGridView.Resize += new EventHandler(dataGridView_Resize);
    dataGridView.Scroll += new ScrollEventHandler(dataGridView_Scroll);
    dataGridView.ColumnWidthChanged += new DataGridViewColumnEventHandler(dataGridView_ColumnWidthChanged);
    dataGridView.RowPostPaint += new DataGridViewRowPostPaintEventHandler(dataGridView_RowPostPaint);
    dataGridView.ColumnHeaderMouseClick += new DataGridViewCellMouseEventHandler(dataGridView_ColumnHeaderMouseClick);
    updatePanelGeograpy();
  }


  private enum SortType
  {
    Ascending,
    Descending,
    None
  }


  private void dataGridView_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
  {
    if (e.ColumnIndex == columnIndex)
    {
      if (sortType == SortType.Ascending)
      {
        sortType = SortType.Descending;
      }
      else
      {
        sortType = SortType.Ascending;
      }
    }
    else
    { // Another column was clicked. Reset this column's sorting.
      sortType = SortType.None;
    }
  }


  private void dataGridView_Paint(object sender, PaintEventArgs e)
  {
    Rectangle r1 = dataGridView.GetCellDisplayRectangle(columnIndex, -1, true);
    if (10 <= r1.Width)
    { // We need at least 10 pixel to draw the arrow
      if (sortType == SortType.Ascending)
      {
        drawSortArrow(e.Graphics, new Point(r1.X + r1.Width - 10, r1.Y + 5), true);
      }
      else if (sortType == SortType.Descending)
      {
        drawSortArrow(e.Graphics, new Point(r1.X + r1.Width - 10, r1.Y + 5), false);
      }
    }

    r1.X += 1;
    r1.Y = STANDARD_COLUMN_SIZE.Height + 1;
    r1.Width -= 2;
    r1.Height = recommendedSize.Height - STANDARD_COLUMN_SIZE.Height - 1;
    e.Graphics.FillRectangle(new SolidBrush(dataGridView.ColumnHeadersDefaultCellStyle.BackColor), r1);
  }


  private void dataGridView_Scroll(object sender, ScrollEventArgs e)
  {
    dataGridView.Invalidate();
  }


  private void dataGridView_RowPostPaint(Object sender, DataGridViewRowPostPaintEventArgs e)
  {
    if (e.IsFirstDisplayedRow)
    {
      updatePanelGeograpy();
    }
  }


  private void dataGridView_Resize(object sender, EventArgs e)
  {
    updatePanelGeograpy();
  }


  private void dataGridView_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
  {
    if (e.Column.DisplayIndex == columnIndex - 1)
    { // We need to move the column
      updatePanelGeograpy();
    }
    else if (e.Column.DisplayIndex == columnIndex)
    {
      uncutPanelSize.Width = e.Column.Width - 2;
      panel.Width = uncutPanelSize.Width;
      updatePanelGeograpy();
    }
  }


  private void cutPanel(int cutFromLeft, int cutFromRight)
  {
    if ((panel == null) || (panel.Controls == null) || (panel.Controls.Count <= 0))
    {
      return;
    }

    // Determine new panel width
    int newPanelWidth = uncutPanelSize.Width;
    if (0 < cutFromLeft)
    {
      newPanelWidth -= cutFromLeft;
    }
    if (0 < cutFromRight)
    {
      newPanelWidth -= cutFromRight;
    }
    panel.Width = newPanelWidth;

    // Move around components appropriately
    if (0 <= cutFromLeft)
    {
      for (int i = 0; i < panel.Controls.Count; i++)
      {
        panel.Controls[i].Location = new Point(initialControlLocations[i].X - cutFromLeft, initialControlLocations[i].Y);
      }
    }
  }


  private void updatePanelGeograpy()
  {
    Rectangle r1 = dataGridView.GetCellDisplayRectangle(columnIndex, -1, true);
    Rectangle r2 = dataGridView.GetCellDisplayRectangle(columnIndex, -1, false);

    int columnWidth = dataGridView.Columns[columnIndex].Width;
    int hiddenToTheRight = r2.Width - r1.Width;
    int hiddenToTheLeft = 0;
    if (r1.Width + hiddenToTheRight < columnWidth)
    {
      hiddenToTheLeft = columnWidth - r1.Width - hiddenToTheRight;
    }

    // Do we need to move the panel?
    if (hiddenToTheLeft == 0)
    {
      panel.Location = new Point(r1.X + 1, panel.Location.Y);
    }
    else if (0 < hiddenToTheLeft)
    { // Place the panel to the right of the cell in the upper leftmost corner
      panel.Location = new Point(dataGridView.GetCellDisplayRectangle(-1, -1, true).Width + 1, panel.Location.Y);
    }

    // Do we need to cut the panel?
    cutPanel(hiddenToTheLeft, hiddenToTheRight);
  }


  private void drawSortArrow(Graphics graphics, Point location, bool arrowPointingUpwards)
  {
    Color grayColorToUse = Color.FromArgb(132, 130, 132);
    if (arrowPointingUpwards)
    {
      graphics.DrawLine(new Pen(Color.White, 1), new Point(location.X + 0, location.Y + 6), new Point(location.X + 7, location.Y + 6));
      graphics.DrawLine(new Pen(Color.White, 1), new Point(location.X + 4, location.Y + 0), new Point(location.X + 4, location.Y + 1));
      graphics.DrawLine(new Pen(Color.White, 1), new Point(location.X + 5, location.Y + 1), new Point(location.X + 5, location.Y + 3));
      graphics.DrawLine(new Pen(Color.White, 1), new Point(location.X + 6, location.Y + 3), new Point(location.X + 6, location.Y + 4));
      graphics.DrawLine(new Pen(Color.White, 1), new Point(location.X + 6, location.Y + 5), new Point(location.X + 7, location.Y + 5));
      graphics.DrawLine(new Pen(grayColorToUse, 1), new Point(location.X + 3, location.Y + 0), new Point(location.X + 3, location.Y + 1));
      graphics.DrawLine(new Pen(grayColorToUse, 1), new Point(location.X + 2, location.Y + 1), new Point(location.X + 2, location.Y + 3));
      graphics.DrawLine(new Pen(grayColorToUse, 1), new Point(location.X + 1, location.Y + 3), new Point(location.X + 1, location.Y + 4));
      graphics.DrawLine(new Pen(grayColorToUse, 1), new Point(location.X + 0, location.Y + 5), new Point(location.X + 1, location.Y + 5));
    }
    else
    {
      graphics.DrawLine(new Pen(Color.White, 1), new Point(location.X + 0, location.Y + 0), new Point(location.X + 7, location.Y + 0));
      graphics.DrawLine(new Pen(Color.White, 1), new Point(location.X + 6, location.Y + 1), new Point(location.X + 7, location.Y + 1));
      graphics.DrawLine(new Pen(Color.White, 1), new Point(location.X + 6, location.Y + 2), new Point(location.X + 6, location.Y + 3));
      graphics.DrawLine(new Pen(Color.White, 1), new Point(location.X + 5, location.Y + 3), new Point(location.X + 5, location.Y + 5));
      graphics.DrawLine(new Pen(Color.White, 1), new Point(location.X + 4, location.Y + 5), new Point(location.X + 4, location.Y + 6));
      graphics.DrawLine(new Pen(grayColorToUse, 1), new Point(location.X + 0, location.Y + 1), new Point(location.X + 1, location.Y + 1));
      graphics.DrawLine(new Pen(grayColorToUse, 1), new Point(location.X + 1, location.Y + 2), new Point(location.X + 1, location.Y + 3));
      graphics.DrawLine(new Pen(grayColorToUse, 1), new Point(location.X + 2, location.Y + 3), new Point(location.X + 2, location.Y + 5));
      graphics.DrawLine(new Pen(grayColorToUse, 1), new Point(location.X + 3, location.Y + 5), new Point(location.X + 3, location.Y + 6));
    }
  }
}

modified on Wednesday, January 13, 2010 9:42 AM

Re: Strange problems with DataGridView with Panels in the heading

arnold_w13-Jan-10 4:48

arnold_w

13-Jan-10 4:48

I solved issue #1. The problem was probably that the scrollbar belongs to the Control it is inheriting and the DataGridView doesn't know if the scrollbar is present or not. If I let the Table-class inherit DataGridView instead of Control then issue #1 goes away.

How to save a webpage to a jpeg

kozu13-Jan-10 3:35

kozu

13-Jan-10 3:35

Hi,
I have a winForm that hosts a webcontrol. Is there any way I can save the page displayed by the control to jpg?

thanx

Re: How to save a webpage to a jpeg

Nuri Ismail13-Jan-10 3:49

Nuri Ismail

13-Jan-10 3:49

Did you try DrawToBitmap()[^] method?

Re: How to save a webpage to a jpeg

kozu13-Jan-10 6:45

kozu

13-Jan-10 6:45

I tried the following in the webBrowser1_Navigated handler, but the image is blank:

Bitmap bitmap = new Bitmap(webBrowser1.Width, webBrowser1.Height);
webBrowser1.DrawToBitmap(bitmap, new Rectangle(new Point(), webBrowser1.Size));
bitmap.Save("C:\\test.jpg", ImageFormat.Jpeg);
bitmap.Dispose();

any ideas?

thanx

Re: How to save a webpage to a jpeg

Luc Pattyn13-Jan-10 9:25

Luc Pattyn

13-Jan-10 9:25

last time I did that with a WebBrowser, the image was black, not blank!?
And no, I haven't found a solution yet (I haven't been looking very hard either).

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Happy New Year to all.
We hope 2010 soon brings us automatic PRE tags!
Until then, please insert them manually.

Re: How to save a webpage to a jpeg

Nuri Ismail13-Jan-10 20:58

Nuri Ismail

13-Jan-10 20:58

Hi,

Apparently using DrawToBitmap on WebBrowser control works only for some sites. [^]
I also found this[^], which might help you. But i haven't tried it yet.

Regards,

third party components

djsproject13-Jan-10 3:33

djsproject

13-Jan-10 3:33

can someone tell what third party components are and how can one integrate them in once programs?thanks in advance........

Re: third party components

Richard MacCutchan13-Jan-10 3:38

Richard MacCutchan

13-Jan-10 3:38

djsproject wrote:
can someone tell what third party components are

Components written by a third party; that is to say not by the provider of your development environment (e.g. Microsoft) and not by you. How you integrate them into your program depends entirely on what sort of components they are and what they are designed to do.

MVP 2010 - are they mad?

Re: third party components

djsproject13-Jan-10 3:42

djsproject

13-Jan-10 3:42

can u give me an example to illustrate more

Re: third party components

Richard MacCutchan13-Jan-10 4:26

Richard MacCutchan

13-Jan-10 4:26

djsproject wrote:
can u give me an example to illustrate more

Example of what? I just explained that third party products are made by other people, I have no idea which ones you are interested in. There are thousands on the internet for everything associated with computing.

MVP 2010 - are they mad?

Re: third party components

Ashfield13-Jan-10 5:07

Ashfield

13-Jan-10 5:07

You have been given the facts, now go and do your own homework.

Bob
Ashfield Consultants Ltd
Proud to be a Code Project MVP

Re: third party components

Mirko198013-Jan-10 22:31

Mirko1980

13-Jan-10 22:31

These (and many other more) are third part components:
http://www.telerik.com/
http://www.opentk.com/
http://www.icsharpcode.net/OpenSource/SharpZipLib/

need suggestion for the code

abcurl13-Jan-10 3:25

abcurl

13-Jan-10 3:25

Project 1

I have four classes

class1
this contains the variables, properties and constructors
suppose

private string abc;

Interface2
This contains interfaces

void a1();

class3
this will have function definitions. basically this will contains functions to do the
database interactions

public void a1()
{
 // code.....
}

class4
this will inherit Interface 2 and will override the definition.

public void a1()
{
 class3 a = new class3();
 a.a1();
}

Project 2

class5
this will have function

public static Interface2 Getclass4_Details()
{
    return new class4();
}

Project 3

In the form button click

i am doing

Interface2 Obj = null;
Obj = project2.class5.Getclass4_Details();
obj.a1();

I am approaching in the above way to do database interaction. Am I approaching i the right direction ?

Re: need suggestion for the code

Richard MacCutchan13-Jan-10 3:41

Richard MacCutchan

13-Jan-10 3:41

abcurl wrote:
Am I approaching i the right direction ?

I suspect not, but it is difficult to understand what you are trying to achieve. The only thing I would say is that this looks extremely complicated; are you sure you need so many classes and interfaces?

MVP 2010 - are they mad?

Re: need suggestion for the code

abcurl13-Jan-10 3:43

abcurl

13-Jan-10 3:43

I am trying to do database interaction using the factory pattern.
Please help

Re: need suggestion for the code

Richard MacCutchan13-Jan-10 4:29

Richard MacCutchan

13-Jan-10 4:29

I would suggest looking at some of the links here[^]. It is not a simple matter of a few lines of code, you will need to study the subject in some depth to get a workable solution.

MVP 2010 - are they mad?

Re: need suggestion for the code

David Skelly13-Jan-10 4:23

David Skelly

13-Jan-10 4:23

It's not immediately clear to me why you need class4 as well as class3. What value do you gain by having class4 in there instead of having class3 implement interface 2? Class 4 seems to do nothing but bucket-pass calls straight on to class 3.

By the way, better names might make the example a bit easier to understand.

Re: need suggestion for the code

abcurl13-Jan-10 4:27

abcurl

13-Jan-10 4:27

Reason - I am implementing the multiple inheritence concept in class4
by overriding the function

Re: need suggestion for the code

darkelv13-Jan-10 5:06

darkelv

13-Jan-10 5:06

Both classes are in the same assembly, I too see no point in having class4 there, btw i think you should subclass Class3 instead of creating a new instance in the function in class4.

C# VS 2008 3.5 Controlling volume with TrackBar

Wheels01213-Jan-10 3:24

Wheels012

13-Jan-10 3:24

Good morning.

I have an app which uses the Windows Media Player control, but I am using customized buttons instead of the player controls.

I wan to increase and decrease the volume with a TrackBar control, but I am not sure how to access the volumn properties of the axWindowsMediaPlayer1.currentMedia.

Any suggestions? Thnak you, WHEELS

Re: C# VS 2008 3.5 Controlling volume with TrackBar

Covean13-Jan-10 4:25

Covean

13-Jan-10 4:25

You can read and write the volume by accessing the volume property of the media player settings.

axWindowsMediaPlayer1.settings.volume = (range 0 - 100)

Hope that helps (not tested)!

Greetings
Covean

Re: C# VS 2008 3.5 Controlling volume with TrackBar

Wheels01213-Jan-10 4:50

Wheels012

13-Jan-10 4:50

Exactly what I needed. Thank you, WHEELS

I need an ebay program

totolcm13-Jan-10 2:21

totolcm

13-Jan-10 2:21

I need a program in PHP which can extract the hidden biders from ebay.I will have to insert the item number and the program must show me all bidders of the auction and their emails.
Also the same program must extract the registered contact information for any specified bidder specially the email address

I will pay for this
If someone can help please contact me at totos_back@yahoo.com

Thanks

Re: I need an ebay program

Luc Pattyn13-Jan-10 2:25

Luc Pattyn

13-Jan-10 2:25

totolcm wrote:
a program in PHP

and that is why you post in the C# forum?

Dead | X|

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Happy New Year to all.
We hope 2010 soon brings us automatic PRE tags!
Until then, please insert them manually.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.