Improve company productivity with a Business Account.Sign Up

x
?
Solved

Datagrid Row Selections

Posted on 2004-09-08
2
Medium Priority
?
323 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 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
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 …
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
In the video, one can understand the process of resizing images in single or bulk. Kernel Bulk Image Resizer is an easy to use tool for resizing large number of images. One can add and resize multiple images with this tool in single go. The video sh…

601 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