Draw vertical bold lines between some columns in datagridview - C# Discussion Boards

empathy is Rose | [Rose]

«Where is the Life we have lost in living? Where is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information?» T. S. Elliot

How to find the processID of an IE Tab, from ShDocVw.InternetExplorer(ShDocVw.ShellDocs). The property HWND is same for all the tabs. Need a solution to find the processId of individual tabs.

What makes you think that each tab in IE has a separate processID?
Do Windows Forms apps open a new thread for each form? No - so why would you expect IE to do that for each tab?

As far as I am aware (from watching processes via Task Manager) IE doesn't open a new process for each tab - it does for some but not all, which implies that the ones where it appears to are not tab related but in some way content related.

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

Hi, by contrast Chrome opens a Process for every tab, and more: [^]. Right now, I have 34 Chrome Processes running, and the Google crash-handlers for 32 and 64 bits.

Not that you needed to know that WTF | :WTF:

«Where is the Life we have lost in living? Where is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information?» T. S. Elliot

I'm using the latest version of IE11

It appears as if each tab has its own process, so you could find the appropriate tab by searching for the IE instance that has the desired caption. When you find that instance, you can inspect the child hwnd's to findthe one with the caption, and send the appropriate WM_XXXX message to it.

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

Yes ... you need to look in "Task Manager" ... with "More Details" checked; to see how many processes ALL the browsers spawn. For only "presenting" they sure do "consume" a lot. The whole thing is now adware.

The Master said, 'Am I indeed possessed of knowledge? I am not knowing. But if a mean person, who appears quite empty-like, ask anything of me, I set it forth from one end to the other, and exhaust it.'
― Confucian Analects

Gerry Schmitz wrote:
For only "presenting" they sure do "consume" a lot. The whole thing is now adware.

Ever since the introduction of JS, they do not just "present" content.

It is a gateway for (potential) malicious code, and should be treated as such.

Bastard Programmer from Hell Suspicious | :suss:

If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

I want to draw vertical bold red lines between some columns in a datagridview. I created a form and a datagridview with six columns. I want to draw red bold vertical lines between first and second columns, and forth and fifth columns. Here's my code:

private void Form1_Load(object sender, EventArgs e)
 {
     //Add colums to dataGridView1
     this.dataGridView1.Columns.Add("Col_A", "Column A");
     this.dataGridView1.Columns.Add("Col_B", "Column B");
     this.dataGridView1.Columns.Add("Col_C", "Column C");
     this.dataGridView1.Columns.Add("Col_D", "Column D");
     this.dataGridView1.Columns.Add("Col_E", "Column E");
     this.dataGridView1.Columns.Add("Col_F", "Column F");

     //Add rows to datagridview
     for (int i = 0; i < 50; i++)
     {
         this.dataGridView1.Rows.Add("A" + i.ToString(), "B" + i.ToString(), "C" + i.ToString(),
                                     "D" + i.ToString(), "E" + i.ToString(), "F" + i.ToString());
     }

     //Set the width of columns
     for (int j = 0; j < this.dataGridView1.ColumnCount; j++)
     {
         this.dataGridView1.Columns[j].Width = 90;
     }

     this.dataGridView1.CellPainting += new DataGridViewCellPaintingEventHandler(dataGridView1_CellPainting);
 }

 //Cell painting event
 void dataGridView1_CellPainting(object sender, DataGridViewCellPaintingEventArgs e)
 {
     //Using red pen to draw border
     using (var redPen = new Pen(Color.Red, 3))
     {
         //Get the x coordination value of the left line
         int left_x = this.dataGridView1.GetCellDisplayRectangle(dataGridView1.Columns["Col_B"].Index, this.dataGridView1.Rows[0].Index, true).X;

         //Get the x coordination value of the right line
         int right_x = this.dataGridView1.GetCellDisplayRectangle(dataGridView1.Columns["Col_D"].Index, this.dataGridView1.Rows[0].Index, true).X
                       + this.dataGridView1.GetCellDisplayRectangle(dataGridView1.Columns["Col_D"].Index,this.dataGridView1.Rows[0].Index, true).Width;

         //Get the y coordination value of the top of each line
         int top_y = this.dataGridView1.GetCellDisplayRectangle(dataGridView1.Columns[0].Index, this.dataGridView1.Rows[0].Index, true).Y;

         //Get the y coordination value of the bottom of each line
         int bottom_y = this.dataGridView1.GetCellDisplayRectangle(dataGridView1.Columns[0].Index, this.dataGridView1.Rows[dataGridView1.Rows.Count - 1].Index, true).Y
                        + this.dataGridView1.GetCellDisplayRectangle(dataGridView1.Columns[0].Index, this.dataGridView1.Rows[dataGridView1.Rows.Count - 1].Index, true).Height;

         //Draw the lines using red pen and the x, y values above
         e.Graphics.DrawLine(redPen, new Point(left_x, top_y), new Point(left_x, bottom_y));
         e.Graphics.DrawLine(redPen, new Point(right_x, top_y), new Point(right_x, bottom_y));
     }
 }

What I got is two vertical red lines in the header row, instead of the entire grid. If I reduce the number of rows to just a few so that all the rows will appear in the form what it first appears, then the red lines appear just as I wanted. But when some rows are hidden, it's screwed up. What am I missing?

Thanks.

Don't use CellPainting - use RowPostPaint:

C#

private void DataGridView1_RowPostPaint(object sender, DataGridViewRowPostPaintEventArgs e)
    {
    DataGridView dgv = sender as DataGridView;
    if (dgv != null)
        {
        Rectangle rect = dgv.GetRowDisplayRectangle(e.RowIndex, false);

        int leftRow = dgv.Columns["Col_B"].Index;
        int rightRow = dgv.Columns["Col_D"].Index;
        int leftX = dgv.GetCellDisplayRectangle(leftRow, e.RowIndex, true).X;
        int rightX = dgv.GetCellDisplayRectangle(rightRow, e.RowIndex, true).X
                      + dgv.GetCellDisplayRectangle(rightRow, e.RowIndex, true).Width;

        e.Graphics.DrawLine(Pens.Red, new Point(leftX, rect.Top), new Point(leftX, rect.Bottom));
        e.Graphics.DrawLine(Pens.Red, new Point(rightX, rect.Top), new Point(rightX, rect.Bottom));
        }
    }

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

Thank you. It works like a charm.

You're welcome!

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

You could try using the built in border properties, see DataGridView.CellBorderStyle Property (System.Windows.Forms) | Microsoft Docs[^].

I want to create a program that will get data from an excel sheet shows in 4 combo box with a drop drown list. For example, if I choose menu1, drop list will the corresponding submenu (i.e, submenu11 & submenu12) rather than showing all other submenus. Again, once selecting submenu11, drop down list will show only the child111 & child112.

I have already imported the data from excel but unable to sort data in a combo box.

https://i.stack.imgur.com/6ixOP.png[^]

https://i.stack.imgur.com/LzZdn.png[^]

You need to be able to "relate" the combo boxes (data).

Parent3->parent2->parent1->child

parent2 is filtered (LINQ where) on parent3 "selected" item.
parent1 is filtered on parent2 selected item.
etc.

They can all use the same collection: p3 "full" view; p2 view limited to p3 selected item; etc.

(If no specific selected item, default to first in each "view").

The Master said, 'Am I indeed possessed of knowledge? I am not knowing. But if a mean person, who appears quite empty-like, ask anything of me, I set it forth from one end to the other, and exhaust it.'
― Confucian Analects

Thanks for your reply. But i have not so much knowledge in c#. If you give some coding help then it's very helpful for me

We are more than willing to help those that are stuck: but that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.

So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

Thank you, of course, I will do my part. I just ask you if you have any coding idea then please help me. I don't tell you to do my full project.

actually, I don't have any good c# programming knowledge I'm trying to learn from the internet. And this is not my school or work project.

I already read excel using OleDb and tried LINQ to shorting data but I still not able to.

And there you are making a huge mistake.
Stop trying to "learn from the internet" and get a good book (or better go on a course) - Addison Wesley do some good ones, as do Wrox and Microsoft. Even download this: Dot Net Zero[^] which will give you a lot of it.

The problem is that learning from the internet is pretty much random - and if any of that is YouTube then most of it is produced by people who know little (if any) more than you do, and have no idea who to make a video or teach. So you miss a lot of stuff that you don't know that you need to know - like SQL Injection in the Bill thread code. You are trying to run before you can walk - and that's a porr way to get started.

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!

If you've loaded the menu items from the spreadsheet, there must be some indicator in the data telling you which child item belongs to which parent item. If you know that one thing, building a hierarchical menu is pretty easy.

Beyond that, you haven't indicated what your data looks like, so we can't possibly help you any further.

".45 ACP - because shooting twice is just silly" - JSOP, 2010
-----
You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
-----
When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

Load each "child" LISTVIEW (query menu item collection) as the parent's listview "selection changed" event fires. Cascades to the lowest level.

This is an example of (hand-rolled) "data virtualization".

The Master said, 'Am I indeed possessed of knowledge? I am not knowing. But if a mean person, who appears quite empty-like, ask anything of me, I set it forth from one end to the other, and exhaust it.'
― Confucian Analects

You need to start by describing the structure/format in which the data is available in C#. Is it in a DataTable ? a CSV file ? a 2d array ? or ... ?

You can, of course, fill the top-level ComboBox when the Form loads, since its contents do not change.

«Where is the Life we have lost in living? Where is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information?» T. S. Elliot

modified 10-Jun-19 5:31am.

Thanks for your reply. But i have not so much knowledge in c#. If you give some coding help then it's very helpful for me

I'll be happy to assist you, but, if you can't tell me what format the data imported from Excel is in ... or, show me the working code you have now that imports the data: I can't offer any useful advice.

«Where is the Life we have lost in living? Where is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information?» T. S. Elliot

I imported from excel using OleDb. now I can't be shorting data. this code now I'm trying..

string stringconn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + tbxSelect.Text + ";Extended Properties=\"Excel 8.0;HDR=Yes;\";";
            OleDbConnection conn = new OleDbConnection(stringconn);
            if (tbxSelect.Text != "")
            {
                OleDbDataAdapter da = new OleDbDataAdapter("Select * from [" + tbxChoice.Text + "$]", conn);
                DataTable dt = new DataTable();
                //DataSet dt = new DataSet();
                dt.Clear();
                da.Fill(dt);
                //dataGridView1.DataSource = dt;

                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string firstRow = dt.Rows[i]["A"].ToString();
                    if (firstRow != "")
                    {
                        cmbRow1.Items.Add(firstRow);

                        if (!firstRow.Equals(Row1))
                        {
                            //essageBox.Show(firstRow);
                            RowIndex_1++;
                            //Menu{ firstRow, RowIndex_1 };
                        }
                        Row1 = firstRow;
                    }
                    MessageBox.Show(i.ToString(),RowIndex_1.ToString());
                }


                for (int j = 0; j < dt.Rows.Count; j++)
                {
                    string secondRow = dt.Rows[j]["B"].ToString();

                    if (secondRow != "")
                    {
                        cmbRow2.Items.Add(secondRow);
                        if (!secondRow.Equals(Row2))
                        {
                            //essageBox.Show(firstRow);
                            RowIndex_2++;

                            //Menu{ firstRow, RowIndex_1 };
                        }
                        Row2 = secondRow;
                    }
                    MessageBox.Show(j.ToString(), RowIndex_2.ToString());
                }

                for (int k = 0; k < dt.Rows.Count; k++)
                {
                    string secondRow = dt.Rows[k]["C"].ToString();

                    if (secondRow != "")
                        cmbRow3.Items.Add(secondRow);
                }

                for (int l = 0; l < dt.Rows.Count; l++)
                {
                    string secondRow = dt.Rows[l]["D"].ToString();

                    if (secondRow != "")
                        cmbRow4.Items.Add(secondRow);
                }

                for (int m = 0; m < dt.Rows.Count; m++)
                {
                    string secondRow = dt.Rows[m]["E"].ToString();

                    if (secondRow != "") ;
                        //cmbRow5.Items.Add(secondRow);
                }

                MessageBox.Show((dt.Rows.Count).ToString());
                conn.Close();
            }
            else
                MessageBox.Show("Er");

Don't do it like that! Never concatenate strings to build a SQL command. It leaves you wide open to accidental or deliberate SQL Injection attack which can destroy your entire database. Always use Parameterized queries instead.

When you concatenate strings, you cause problems because SQL receives commands like:

SQL

SELECT * FROM MyTable WHERE StreetAddress = 'Baker's Wood'

The quote the user added terminates the string as far as SQL is concerned and you get problems. But it could be worse. If I come along and type this instead: "x';DROP TABLE MyTable;--" Then SQL receives a very different command:

SQL

SELECT * FROM MyTable WHERE StreetAddress = 'x';DROP TABLE MyTable;--'

Which SQL sees as three separate commands:

SQL

SELECT * FROM MyTable WHERE StreetAddress = 'x';

A perfectly valid SELECT

SQL

DROP TABLE MyTable;

A perfectly valid "delete the table" command

SQL

--'

And everything else is a comment.
So it does: selects any matching rows, deletes the table from the DB, and ignores anything else.

So ALWAYS use parameterized queries! Or be prepared to restore your DB from backup frequently. You do take backups regularly, don't you?

Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!