Hi,
I would like to include multiple attachment columns in a RadGrid that is built dynamically.
All the attachments are comming from the same SQL table (ID, FileName, document).
Therefore my RadGrid data contains several columns generated by a stored procedure:
I am using SQL Server stored procedures, and specifically a proc called "getDocument" that has a single parameter: "@ID" declared as an "int" and returning "document" (the file data; varbinary). This procedure is delcared in an SqlDataSource (SqlDataSourceAttachment), with a single parameter "ID".
The problem is that in order to manage the attachment columns with several GridAttachmentColumn using that SqlDataSourceAttachment, I would have to map the @ID parameter of the SqlDataSourceAttachment with the RadGrid data columns i.e. ID1, ID2, ID3... and not just ID.
Any suggestions on how I can do that ?
François
I would like to include multiple attachment columns in a RadGrid that is built dynamically.
All the attachments are comming from the same SQL table (ID, FileName, document).
Therefore my RadGrid data contains several columns generated by a stored procedure:
- ID1, FileName1
- ID2, Filename2
- ID3, Filename3
- ...
I am using SQL Server stored procedures, and specifically a proc called "getDocument" that has a single parameter: "@ID" declared as an "int" and returning "document" (the file data; varbinary). This procedure is delcared in an SqlDataSource (SqlDataSourceAttachment), with a single parameter "ID".
The problem is that in order to manage the attachment columns with several GridAttachmentColumn using that SqlDataSourceAttachment, I would have to map the @ID parameter of the SqlDataSourceAttachment with the RadGrid data columns i.e. ID1, ID2, ID3... and not just ID.
Any suggestions on how I can do that ?
François