Hi
I am trying to create an application that creates reports. All data is stored in an sql database.
It will be possible to add/attach an unknown number of photos to each report and a picture box and listbox has been added to the application.
Problem
I need to store the list of image filenames to a field in the reports data table. i.e. the list box should retrieve and update a list of images to the sql table.
I have thought about using an array to hold the image filenames but have not figured out how to bind this array to the table.
Is it possible to store such a list in a table - if so what sql data type should be used and if possible if you could give me some idea of where to start.
The following code will create the list and does insert but not update the table
Dim photos(image_list.Items.Count) As String
For i As Integer = 0 To (image_list.Items.Count - 1)
photos(i) = image_list.Items(i)
Next
Dim rpt_third_party As String
rpt_third_party = photos.ToString
Thanks in advance
I am trying to create an application that creates reports. All data is stored in an sql database.
It will be possible to add/attach an unknown number of photos to each report and a picture box and listbox has been added to the application.
Problem
I need to store the list of image filenames to a field in the reports data table. i.e. the list box should retrieve and update a list of images to the sql table.
I have thought about using an array to hold the image filenames but have not figured out how to bind this array to the table.
Is it possible to store such a list in a table - if so what sql data type should be used and if possible if you could give me some idea of where to start.
The following code will create the list and does insert but not update the table
Dim photos(image_list.Items.Count) As String
For i As Integer = 0 To (image_list.Items.Count - 1)
photos(i) = image_list.Items(i)
Next
Dim rpt_third_party As String
rpt_third_party = photos.ToString
Thanks in advance
