[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 320
  • 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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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