display picture(url) from db into a picturebox in datagrid?

keyvan

Hi
I have a datGridView on my from which gets the data from my dataset
i have changed the photo field to a pictureBox
but i do not know how to disolay the photo
It will be a hyperlink like this:http://www.mysite.com/ + photoField
in which Event of datagrid should i get the info?
i need code pls

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

13y ago
Accepted answer
Please try the below code.
If may not be 100% efficient, but you will get the desired output.

DataTable dt = new DataTable();
DataColumn dc = new DataColumn() { ColumnName = "URL", DataType = typeof(System.String) };
DataColumn dc1 = new DataColumn() { ColumnName = "Image", DataType = typeof(Byte[]) };
dt.Columns.Add(dc);
dt.Columns.Add(dc1);

DataRow firstRow = dt.NewRow();
firstRow["URL"] = "https://www.google.co.in/images/srpr/logo6w.png";

dt.Rows.Add(firstRow);
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = dt;

foreach (DataRow row in dt.Rows)
{
System.Net.WebRequest request = HttpWebRequest.Create("https://www.google.co.in/images/srpr/logo6w.png");
System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(request.GetResponse().GetResponseStream());
ImageConverter converter = new ImageConverter();
row["Image"] = (byte[])converter.ConvertTo(bmp, typeof(byte[]));
}

Please modify it as per your wish.
keyvan13y ago
ok now i am a little bit confused since i have a dataGridView and each row in that datagridview has got some photos which i want to populate by the id of that row in the bindingsource_position changed event of that datagridview! how should i modify the table!

    Private Sub Auto_AutosBindingSource_PositionChanged(sender As Object, e As System.EventArgs) Handles Auto_AutosBindingSource.PositionChanged
        If Me.Auto_AutosBindingSource.Position > -1 Then
            For Each row3 As DataRowView In Auto_autoPhotosBindingSource.List
                Dim row2 As AutosDataSet.auto_autoPhotosRow
                row2 = CType(CType(Me.Auto_autoPhotosBindingSource.Current, DataRowView).Row, AutosDataSet.auto_autoPhotosRow)
                ' Dim ImageURL As String = "http://www.site.com/auto/pictures/autoImages/" & row2.Folder & "/" & common.getPicThumb(row2.Photo.ToString())
                ' Me.PhotoPictureBox.ImageLocation = ImageURL
            Next
        End If
    End Sub
keyvan13y ago
in my dataset i have a data field which is a simple text field the image is on my filesystem on the remote host
13y ago
In your dataset do you have URL or binary value of image data?