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

Question

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

Muralidharan Deenathayalan · 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.

keyvan · Answer

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

keyvan · Answer

in my dataset i have a data field which is a simple text field the image is on my filesystem on the remote host

Muralidharan Deenathayalan · Answer

In your dataset do you have URL or binary value of image data?