Comments by Member 12805826 (Top 1 by date)

This a windows form and this form has an
1. where a user can attach multiple files (any type of file) and these files attached has to go to the Table A and have to be saved as Attachment1, attachments2,--(we can limit the number of attachments to 5 with different extensions) in different columns respectively for the same ID)
example: if ID from Table A is 1234. I have to get the attachments in different columns like the
Attachment 1 ID – 1234
Attachment 2 ID -1234 in different columns
And these files has to be displayed in the data grid view
I am able to get one file working the correct way as I wanted I can even see the content of the files in the data grid view.
Problem:
I am not able to get the same ID for all the files attached in the secondary table because the primary table ID column is a unique identifier.
II need to write a sql query to get the different attachments with same ID like this
Attachment 1 ID – 1234
Attachment 2 ID -1234

Thanks In advance