Solved

Hit Test returns -1 coordinates VB.net datagridview

Posted on 2009-04-12
7
786 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

752 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