Solved

Hit Test returns -1 coordinates VB.net datagridview

Posted on 2009-04-12
7
772 Views
Last Modified: 2012-05-06
Hi

The code bellow returns -1 on both row and col index

any ideas why ? The X and Y coordinates show positive numbers
Dim hitTest As DataGridView.HitTestInfo
 

        hitTest = Me.DataGridView13.HitTest(e.X, e.Y)
 

        If hitTest.RowIndex <> -1 AndAlso hitTest.ColumnIndex <> -1 Then

            Dim cell As DataGridViewCell = Me.DataGridView13(hitTest.ColumnIndex, hitTest.RowIndex)

            cell.Value = e.Data.GetData(DataFormats.Text)

        End If

Open in new window

0
Comment
Question by:MichMat
  • 4
  • 3
7 Comments
 
LVL 48

Expert Comment

by:jpaulino
ID: 24124911
What you want to do and in what event are you using that code ?
0
 

Author Comment

by:MichMat
ID: 24124916
Im trying to draging and dropping item from a listbox into a datagridview cell
 Private Sub DataGridView13_DragDrop(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles DataGridView13.DragDrop
 
 
 

        Dim hitTest As DataGridView.HitTestInfo
 

        hitTest = Me.DataGridView13.HitTest(e.X, e.Y)
 

        If hitTest.RowIndex <> -1 AndAlso hitTest.ColumnIndex <> -1 Then

            Dim cell As DataGridViewCell = Me.DataGridView13(hitTest.ColumnIndex, hitTest.RowIndex)

            cell.Value = e.Data.GetData(DataFormats.Text)

        End If
 

       
 
 
 

    End Sub

Open in new window

0
 
LVL 48

Accepted Solution

by:
jpaulino earned 500 total points
ID: 24124941
Sorry e.Data.GetData should be for DragDrop:)
The e.X gives you the point on the screen and not in the datagridview. You cannot use that way and you have to first know where that point belong in the grid. Then you use the HitTestInfo.
 Try this way:

    Private Sub DataGridView1_DragDrop(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles DataGridView1.DragDrop
 

        Dim p As Point = Me.DataGridView1.PointToClient(New Point(e.X, e.Y))

        Dim hitTest As DataGridView.HitTestInfo = DataGridView1.HitTest(p.X, p.Y)
 

        If hitTest.RowIndex <> -1 AndAlso hitTest.ColumnIndex <> -1 Then

            Dim cell As DataGridViewCell = Me.DataGridView1(hitTest.ColumnIndex, hitTest.RowIndex)

            cell.Value = e.Data.GetData(DataFormats.Text)

        End If
 
 

    End Sub

Open in new window

0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:MichMat
ID: 24125287
Im getting an error when running your code, its comes up as a Mesage Box and says that my string isnt recognised as a valid bolleon Im including all the code that Im using to do this drag and drop may be you could spot the error thank you
the only otherthing is that the datagid has dragdrop enabeled
Private Sub ListBox1_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles ListBox1.MouseMove

        If e.Button = Windows.Forms.MouseButtons.Left Then

            Dim index As Integer = ListBox1.SelectedIndex

            If index <> -1 Then

                LBvalue = ListBox1.Items(index)

                ListBox1.DoDragDrop(LBvalue, DragDropEffects.All)

            End If

        End If

    End Sub
 

    Private Sub DataGridView13_DragDrop(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles DataGridView13.DragDrop
 
 

        

        Dim p As Point = Me.DataGridView13.PointToClient(New Point(e.X, e.Y))

        Dim hitTest As DataGridView.HitTestInfo = DataGridView13.HitTest(p.X, p.Y)
 

        If hitTest.RowIndex <> -1 AndAlso hitTest.ColumnIndex <> -1 Then

            Dim cell As DataGridViewCell = Me.DataGridView13(hitTest.ColumnIndex, hitTest.RowIndex)

            cell.Value = e.Data.GetData(DataFormats.Text)

        End If
 

    End Sub
 
 

    Private Sub DataGridView13_DragEnter(ByVal sender As Object, ByVal e As System.Windows.Forms.DragEventArgs) Handles DataGridView13.DragEnter

        If e.Data.GetDataPresent(DataFormats.Text) Then

            e.Effect = DragDropEffects.All

        End If

    End Sub

Open in new window

0
 

Author Comment

by:MichMat
ID: 24125303
Just figgured it out I had the grid column formated at checkbox type ??????

Your code now works perfectly
0
 

Author Closing Comment

by:MichMat
ID: 31569289
As always A1 work, Im always happy when JP takes my questions as I know I will get a great result. Thank You
0
 
LVL 48

Expert Comment

by:jpaulino
ID: 24125817
Glad I could help MichMat!
jpaulino
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

920 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

17 Experts available now in Live!

Get 1:1 Help Now