Solved

Datagrid Row Selections

Posted on 2004-09-08
2
304 Views
Last Modified: 2012-05-05
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
Comment
Question by:malanois
2 Comments
 
LVL 10

Accepted Solution

by:
123654789987 earned 500 total points
ID: 12014643
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
 

Author Comment

by:malanois
ID: 12019997
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

746 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

12 Experts available now in Live!

Get 1:1 Help Now