• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

Datagrid Row Selections

This has been bothering me for a while now.  I am using OLEDbAdapter to fill a dataset.  The dataset is filling a data grid.  I have a Column that is not visible in the normal Datagrid.  When a user selects a given row in the datagrid I need to fill 2 seperate items.  1 being a picture box, the other being a txt box.

The select statement has PN, TR_Desc, Desc, Pic, Vendor

Desc is not being shown in the main datagrid.

I need Pic to show in the Picture Box (pbx1)
and
Desc to fill in another Text Box (txtbx2)

Any suggestions will help

MJ
0
malanois
Asked:
malanois
1 Solution
 
123654789987Commented:
Private Sub datagridClick(ByVal sender As System.Object, _
    ByVal e As MouseEventArgs) Handles datagrid.MouseDown
        Dim mouseClick As DataGrid.HitTestInfo
        Dim descIndex As Integer
        dim picIndex as integer

        If e.Button = MouseButtons.Left Then
            dgObservation = CType(sender, DataGrid)
            mouseClick = datagrid.HitTest(e.X, e.Y)
            gridRow = mouseClick.Row
         
                descIndex = datagrid.Columns.IndexOf("Desc")
                picIndex  =  datagrid.Columns.IndexOf("Pic")

               
                If gridRow >= 0 Then
                    textbox1.Text = datagrid.Rows(gridRow)(descIndex ).ToString
                     pictureBox.Image =    datagrid.Rows(gridRow)(picIndex) // Set the picture to the box
                End If
            End If
End Sub
0
 
malanoisAuthor Commented:
Thank You,

it worked 99%.

I had to throw a loop in there if the pic value was null not to load.  However I still cannot get an image to show in my pic box.

The database has the image file name in the image column.  1234.jpg, I have also tried \\1234.jpg, \\trdb\image\1234.jpg

And it still wont load the image.  however i dont get and error on those though....

MJ
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now