I hope you can help me as I have been searching Google all over to try and get some definitive answers.
I'm using Visual Studio Enterprise 2015, Visual Basic, Windows Forms Applications.
This is what I have so far:
Code:
Dim dsPODs As DataSet
Dim daTransport As SqlDataAdapter
Dim conTransport As New SqlConnection("...")
Dim PITSGetPODDetail As New SqlCommand()
PITSGetPODDetail.Connection = conTransport
PITSGetPODDetail.CommandText = "ssp_PITSGetPODDetail"
PITSGetPODDetail.CommandType = CommandType.StoredProcedure
PITSGetPODDetail.Parameters.AddWithValue("@JobNumber", Int16.Parse(JobNumber))
dsPODs = New DataSet()
conTransport.Open()
daTransport = New SqlDataAdapter(PITSGetPODDetail)
daTransport.Fill(dsPODs, "PODDetail")
conTransport.Close()
Dim bytBLOBData() As Byte = dsPODs.Tables(0).Rows(0)("ImageData")
Dim stmBLOBData As New MemoryStream(bytBLOBData)
picPODViewer.Image = Image.FromStream(stmBLOBData)
daTransport.Dispose()
daTransport = Nothing
dsPODs.Dispose()
dsPODs = Nothing
The ssp_PITSGetPODDetail stored procedure simply returns any images which matches the Job Number passed to it. The field which is returned is a SQL Image field.
So, the above works to a fashion but needs further work which I am unable to fathom out.
What I would like to happen is a dataset is populated with a number of "images" and then use the Binding Navigator to move the Picture Box through the dataset.
Any help would be greatly appreciated.
Thank you