Solved

VB.NET: Data Grid View Jumps to the Top of the Page When it Gains Focus

Posted on 2010-09-04
15
1,465 Views
Last Modified: 2012-05-10
Hi,

I have a Windows Form, containing a Panel with scroll bars. Within the Panel is a few text boxes at the top of the page and a Data Grid View with a lot of data in it. The Data Grid View starts about half way down the Panel and goes off the bottom, so you have to use the Panel scroll bars to view the bottom of the data.

This is the way it is supposed to look and work.

Unfortunately if the user goes onto the page and clicks a row close to the top, the Panel automatically scrolls so that the Data Grid View is at the top of the screen. It also selects a number of rows instead of just the clicked one.

Does anyone know of a solution to this, other than changing the structure of the form?

If you need any further information then please let me know.
0
Comment
Question by:philkeene
15 Comments
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33604648
Hi
check initially the anchor of the datagridview.also set multiselect to false.check these and let me know if you have a problem
0
 
LVL 17

Expert Comment

by:Zhaolai
ID: 33605421
I don't think you need a panel on the form, because you can set datagridview to have its own scroll bars, both vertical and horizontal. Since the datagridview takes up the lower part of the form, you can set its anchor to "Top, Bottom, Left, Right" so that when the form re-sizes, the datagridview changes the size accordingly.
 
0
 
LVL 8

Expert Comment

by:Mohit Vijay
ID: 33605434
Tab Index is a problem.

Please check available controls on your form, DataGrid view's tab index should be not smaller nor largest from all available controls those can take focus, reminder, label control cannot have focus, textbox, buttons can have focus.
0
 
LVL 4

Author Comment

by:philkeene
ID: 33610302
Hi Guys,
I'm not sure how well i described my problem, but I have found the solution here.
http://www.daniweb.com/forums/showthread.php?t=6213&highlight=scroll+bar+problems+in+vb.net
(Towards the bottom of the first page.)
Basically it says to create a new control inherited from the Panel, and to change the scrolltocontrol function to the following...
 
protected override Point ScrollToControl(System.Windows.Forms.Control activeControl) {
return this.AutoScrollPosition;
}
 
I haven't tried it yet but it looks like it should work fine.
Thanks for your help.
Kind regards,
Phil
0
 
LVL 4

Author Comment

by:philkeene
ID: 33610923
I was wrong it hasn't worked at all. I am using the following code for the inherited class...

Public Class NonAutoscrollingPanel
    Inherits System.Windows.Forms.Panel

        Protected Shadows Function ScrollToControl(ByVal activeControl As System.Windows.Forms.Control) As System.Drawing.Point
        MsgBox("Test")
        Return AutoScrollPosition
    End Function

End Class
 
When clicking on the data grid view it doesn't even trigger the message box.
Let me know if you have any further suggestions or suggested fixes for this code.
Many thanks.
0
 
LVL 17

Expert Comment

by:Zhaolai
ID: 33612338
Please post a screen shot of your form.
0
 
LVL 4

Author Comment

by:philkeene
ID: 33619471
Due to the sensitivity of the project I am unable to post the form, but instead I have recreated a very much simplified version of the form that still has all the components listed above and exhibits the same behaviour.
I have attached 2 screenshots to this post. The first is the form when it first loads up. The second is when the top row of the data grid view is clicked.
Let me know if you need any further information.
 

screenshot1.png
screenshot2.png
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 17

Accepted Solution

by:
Zhaolai earned 500 total points
ID: 33619710
The screen shots confirmed my earlier comments. Like I said in my first post (the second in this thread), you do NOT need the panel at all, because the datagridview has its own scrollbars. It's a property called ScrollBars. You can set it at design time. When you have more data than the displaying area, the scrollbars will appear automatically.

0
 
LVL 4

Author Comment

by:philkeene
ID: 33621794
Yeah I thought that may be the case.
I was hoping for another solution, but I don't think there is one. There are a few reasons why I wanted to keep the panel, but in this case I think I'm going to have to submit and do it that way.
0
 
LVL 17

Expert Comment

by:Zhaolai
ID: 33621829
Well, if you still want to keep the panel, you can. Just set its scrollbars to None and make the datagridview control not going beyond the panel.
0
 
LVL 4

Author Comment

by:philkeene
ID: 33621847
Won't that do the same jumping behaviour, if it goes off the bottom of the screen?
0
 
LVL 17

Expert Comment

by:Zhaolai
ID: 33622003
No it will not, because all the controls are on the screen. You scroll ONLY in the datagridview control. See the sample screenshot below:

Screenshot.PNG
0
 
LVL 4

Author Comment

by:philkeene
ID: 33622062
Ah right yes. That's fine then. I'll take that approach.
Many thanks for your help,
Phil
0
 
LVL 4

Author Comment

by:philkeene
ID: 33624781
Hi Everyone,
New update. The fix is possible after all, the link mentioned above did work, however I was not familiar enough with inheritance in vb.net to do it correctly. I replaced 'shadows' with 'overrides' and it all started working.
 

Public Class NonAutoscrollingPanel
    Inherits System.Windows.Forms.Panel


    Protected Overrides Function ScrollToControl(ByVal activeControl As System.Windows.Forms.Control) As System.Drawing.Point
        Return AutoScrollOffset
    End Function
End Class
 
 Thanks for your help.
Phil
0
 
LVL 4

Author Comment

by:philkeene
ID: 33626085
Slight correction...

Public Class NonAutoscrollingPanel
    Inherits System.Windows.Forms.Panel

    Protected Overrides Function ScrollToControl(ByVal activeControl As System.Windows.Forms.Control) As System.Drawing.Point
        Return AutoScrollPosition
    End Function

End Class
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now