Solved

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

Posted on 2010-09-04
15
1,504 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
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
 
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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 …
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

809 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