Avatar of adoliv
adoliv
Flag for South Africa

asked on 

Storing Data from a Column in a Variable

Hi Experts

Okay I am creating a ZIP File containing multiple images files, but the filepaths that I require are results from a SQL Query that populate a Gridview.

Process Flow: User Provides A Start Date And End Date > Button 1 Click > SQL Query > Populate Gridview With Results > If User is happy with results > 2nd Button Click > Download ZIP File.

I need to know how I can store all the data in numerous records in one column of the Gridview into a String Variable(Please supply the example code required because I have searched the net for examples for a while and come out with nothing)

Example
Id      FileName      Extension
1      image1      jpg
2      image2      gif
3      image3      jpg

Basically I want to be able to store all the values under the FileName column in a String Variable called "items" (Please view attached Code Snippet or Attached File).
Line 3 = New String() {"", "c:\test\Copy of one.txt", "c:\test\one.txt", "c:\test\o-fone.txt"}

I think is needs to look like this
New String() {"", + items}
code.txt
Web ApplicationsProgramming Languages-OtherMicrosoft Legacy OS

Avatar of undefined
Last Comment
Nasir Razzaq

8/22/2022 - Mon