Horizontal Scrollbar is not visible on DataGridView

Question

I have a DataGridView on Window form which is populated with 30 columns and thousands of rows. ScrollBars property is set to Both, but still horizontal scroll bar is not visible. even I am unable to scroll with arrow key from keyboard.

I tried it by setting ScrollBars property to Horizontal as well, but that does not make any difference.

Any suggestions please?

Thanks

Thanks for you reply @V4Vendetta. Its solved now; one of the columns has `Frozen` property set as `True`. which should be `false` for all columns. Now ScrollBar is working absolutely fine for me. Cheers — Scorpion, Mar 07 '11 at 11:38

score 47 · Accepted Answer · answered Mar 07 '11 at 11:35

47

Well Guys, its sorted out.

I am answering my own question; it may help someone in future.

one of the columns has Frozen property set as True. which should be false for all columns. Now ScrollBar is working absolutely fine for me.

Cheers

enter image description here

answered Mar 07 '11 at 11:35

Scorpion

4,495
7
39
60

Awesome, all my columns was set to frozen, that's why the scrollbar didn't show. I would never think of that, ty! – Cyril Gandon May 24 '13 at 08:25
All mine are set to frozen and I still have the problem :/ – DontFretBrett Dec 23 '13 at 22:51
@DontFretBrett try to set of Frozen = False. – Scorpion Jan 16 '14 at 10:25
4

To add; Only the __leftmost__ columns may be frozen if you want scrollbars to appear. Also, at least a part of the first __not-frozen column must be visible__. – TaW Jan 16 '15 at 11:20
For me it was simply not visible because I had set the height of the data grid view to a value that it was crossing the height boundary of its container control. – RBT Jul 04 '16 at 11:42
5

For me the problem was that i had a column with AutoSizeMode property to Fill, i changed it to DisplayedCells and worked fine. – Ricky Stam Dec 01 '16 at 14:21
If all are frozen then it would not work. At least the last columns needs to have Frozen=false – Ananda Prasad Bandaru May 15 '18 at 17:01

score 23 · Answer 2 · answered Jan 19 '13 at 18:22

23

I know this has already been resolved, but I've come across another reason why this could happen, so thought I'd add it as an answer in case someone else has the same problem.

If your form has a DataGridView that is docked to fill the form, and the form also has a status bar, then depending on the order they're created, the status bar can hide the DataGridView's scrollbar. To fix this, right click on the DataGridView, and select "Bring to Front".

answered Jan 19 '13 at 18:22

Dan

5,692
3
35
66

1

Who knew. This answer saved me since I just so happened to be using a status bar on the bottom of my form. "Bring to Front" solved my problem and started showing my horizontal scroll on my datagridview. Thanks! – CODe Dec 07 '13 at 16:51
Just stumbled upon the same problem after copying [example code from MSDN online docs](https://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview%28v=vs.110%29.aspx). – mkluwe Mar 24 '16 at 11:05
that's true! 100% for me as well here using VS2013 under win7. Thanks @Dan . – gumuruh Mar 28 '18 at 13:05

score 10 · Answer 3 · edited Nov 05 '15 at 19:41

10

When I encountered this annoying problem, it was due to the AutoSizeColumnsMode property of the DGV that was set to Fill

I fixed it by changing that property to AllCells, but any other value will work. It works even if the DGV is docked and I have multiple docked panels, and the first column is Frozen.

edited Nov 05 '15 at 19:41

ryanyuyu

6,366
10
48
53

answered Nov 04 '15 at 14:30

Fabio Michelini

1,067
8
5

score 5 · Answer 4 · answered Feb 27 '15 at 20:38

5

The docking.Fill of the DGV is a little buggy.
It happens when you have multiple docked panels, toolbars, etc. More common when you're creating your columns at runtime.

The control thinks it is wider than its container and the Horizontal scrollbar does not spawn.

Frozen, autosize, brint to front and the other remedies mentioned don't always work. The most reliable workaround is to Dock.Left and set the DGV's width at run time. This way the DGV doesn't get confused about how wide it is.

answered Feb 27 '15 at 20:38

Joe

51
1
1

I found every time I copied and pasted the dgv from another tab, it would somehow manage to change the size of my dgv's elsewhere (raising the y by around 10 points) and ultimately hiding the scrollbars from view – NadimAJ Nov 25 '20 at 18:23

score 5 · Answer 5 · answered Nov 27 '16 at 20:36

5

i had the similar problem. What I did was, check each of your Datagrid columns and set the Frozen to "false". Hope that helps.

answered Nov 27 '16 at 20:36

Raymond Dumalaog

353
4
13

1

This was exactly my problem and now it's fixed. Not sure why it's down-voted. – braX Aug 16 '17 at 18:42

score 4 · Answer 6 · edited Jan 16 '18 at 04:12

I was having this irritating problem. I had already created the DataGridView on my Form and am setting all the databinding and properties setting in the .CS file.

I just commented the line in my code behind file (.cs) i.e.

gvTblContent.AutoSize = true;

You need not to set the AutoSize property, horizontal and vertical scrollbars will be provided by default otherwise you can use :

gvTblContent.ScrollBars = ScrollBars.Both;

score 2 · Answer 7 · answered Oct 21 '19 at 10:36

2

I had a similar problem, not due to the frozen property, but most likely to DataGridView bugs, after I added some rows programmatically. After reading this answer to another question I solved using:

dgv.PerformLayout()

after adding those rows, just before dgv was about to be shown.

answered Oct 21 '19 at 10:36

BillyJoe

878
7
25

I'll be da**ed. That was my issue, right before presenting the data. My issue was the DGV was updated and the scrollbar appeared half way in. You could see there was a scrollbar but the actual bar did not show. Adding that command right before presenting the data fixed my issue. – Jonathan Monestel Mar 11 '21 at 20:47

score 1 · Answer 8 · answered Sep 09 '16 at 19:24

1

In my case i just used ANCHOR Top, Bottom, Left, Right instead of DOCK Fill.

Try it.

answered Sep 09 '16 at 19:24

NoWar

36,338
80
323
498

score 1 · Answer 9 · answered Jun 16 '20 at 23:57

1

I had a similar issue but inside SplitContainer. None of the above worked, but use all four anchors instead of Dock.Fill of DataGridView.

answered Jun 16 '20 at 23:57

Max

751
6
10

score 1 · Answer 10 · answered Jun 29 '23 at 14:28

In my case, the datagridviews were inside a Tab Control. I found that if I clicked on any of the headers to sort the column, the Scroll bar(s) would show up.

After doing a bunch of trial and error, I got this to work..

    private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)
    {
        //Ran into a strange issue where the Scroll bars would not work on any of the data grids.
        //After a bunch of trial and error, I discovered that once you clicked on a tab and sorted on 
        //a column, it would show up. So this is programically doing it.

        TabPage myTabPage = ((System.Windows.Forms.TabControl)sender).SelectedTab;
        DataGridView myDG = myTabPage.Controls[0] as DataGridView;
        if (myDG != null && myDG.Rows.Count > 0)
        {
            //myDG.Sort(myDG.Columns[0], ListSortDirection.Ascending);  //Basically this should not change the sort order.
            myDG.PerformLayout();  //This seems to work as well, but only in this event, but at least it doesn't change the sort.
        }
    }

Thanks buddy exactly the same situation! – Stefan Pintilie Jul 03 '23 at 16:45 — Stefan Pintilie, Jul 03 '23 at 16:45

score 0 · Answer 11 · answered Sep 15 '15 at 07:50

0

I also meet this problem. It's a stupid situation in my case.

Please check the position/size of DataGridView whether out of the form.

answered Sep 15 '15 at 07:50

Mystic Lin

365
4
15

score 0 · Answer 12 · answered May 25 '16 at 15:05

0

I had the same problem and found that my dataGridView was slightly larger than the form that it was in. I adjusted the size to fit in the Form and it worked! Hope this helps!

answered May 25 '16 at 15:05

Robbie

1

score 0 · Answer 13 · answered Feb 21 '17 at 23:58

Multiple show/hide columns on my side was causing the same issue. Had to add dataGridView1.ScrollBars = ScrollBars.Both; after I process all the columns and rows in the datagridview

Nothing of the above helped before that 1. No Frozen Columns 2. Form load has dataGridView1.ScrollBars = ScrollBars.Both; 3. No Status bar

score 0 · Answer 14 · answered Apr 03 '17 at 13:07

I too had this problem in VS2015 on a winform.

The winform has a table layout split into 4 rows, 1 column. Into the rows I place panels for placing other controls except the DataGrid row which is in the last row. The DataGrid is set with Dock to fill. The form also has a Status bar at the bottom, for future use.

What I found is that the status bar blocked the scrollbar as mentioned previously.

I added another row to the table layout but that would display a large blank space at the bottom of the form both at run time and design. Resizing the form did not resolve either. I tried setting the row height of the table layout but it did not work. I tried 1 pixel, 5 pixels etc. no change. In the end I gave up and removed the Status bar, wasn't using it for anything anyway.

score 0 · Answer 15 · answered Mar 13 '18 at 18:10

I had a DataGridView sitting inside a cell of a TableLayoutPanel, and neither scroll bar was showing up on the DataGridView. I think the size of the DataGridView also wasn't being managed properly with the DataGridView being docked to fill a cell of the TableLayoutPanel. I didn't have any frozen columns.

I was able to fix it by placing the DataGridView inside a Panel, and setting AutoScroll=true on the Panel, to let the Panel manage the scrolling. I docked the panel to fill inside the cell of the TableLayoutPanel, and docked the DataGridView to fill inside of the Panel.

score 0 · Answer 16 · edited Jul 09 '18 at 05:52

0

In my case Scroll bar didn't appear until when I realized the above frozen column state and read-only. I have done frozen columns for read-only column as well the one editable column in my dataGridView. When I remove frozen=false for editable column, the horizontal bar appear.

edited Jul 09 '18 at 05:52

Brijesh Joshi

1,817
1
9
24

answered Jul 09 '18 at 03:56

Kishor Oswal

1

score 0 · Answer 17 · answered Aug 16 '18 at 03:30

0

I set some first columns frozen to true it(H_bar) still works. But I set frozen = true to a invisible column (column.visible=false), it gone.

answered Aug 16 '18 at 03:30

Huỳnh Hữu Ân

113
1
4

score 0 · Answer 18 · answered Sep 16 '18 at 05:19

I had the same problem with DataGridView inside a tableLayoutPanel.

None of the above helped me.

It turns out that the column in the tableLayoutPanel in which the DataGridView is is set to AutoSize.

The solution is to set the tableLayoutPanel columns to actual value or percent.

score 0 · Answer 19 · answered Nov 30 '18 at 20:03

All your frozen columns should fit within the form. Otherwise horizontal Scrollbar does not show up. If there is no horizontal Scrollbar then make your form wider until you see your last frozen field and then Horizontal Scrollbar will magically appear.

score 0 · Answer 20 · answered Dec 28 '19 at 23:07

0

There one more thing you could check on. The "Enabled" property of the GridView control should be set at "true". DataGridView Properties:

answered Dec 28 '19 at 23:07

user12616324

1

score 0 · Answer 21 · answered Jan 16 '20 at 00:09

Fixed my problem, but it was none of the above.

In my situation, I was creating my entire form at run-time. Each DataGridView was Dock.Fill inside a TableLayoutPanel. You don't have to specify row or columns for a TableLayoutPanel if there is only going to be one, and it should be 100%. Doing this however breaks DataGridView. Fixed my problem by simply adding the row 100% definition.

Horizontal Scrollbar is not visible on DataGridView

21 Answers21

Linked

Related