Last post May 23, 2017 08:47 PM by mgebhard
May 23, 2017 07:48 PM|StrangerMike|LINK
I have a stored procedure that returns 48 records with 3 Columns.
What I would like to do is: read the result of the stored procedure into an Array (48,3).
Then this would allow me to loop through the array and format each line the way I am going to need it (for an HTML form).
And it gives me the ability to address the columns as needed for the formatting. I can't seem to find code to loop through the query read while loading up an Array.
How can I do this? Thanks
May 23, 2017 08:46 PM|StrangerMike|LINK
not as an array but as a list box
Dim list1 As New ListBox
Dim list2 As New ListBox
objDR1 = objCmd.ExecuteReader
Response.Write("<P>" & list1.Items(0).ToString & "</>")
Response.Write("<P>" & list2.Items(0).ToString & "</>")
May 23, 2017 08:47 PM|mgebhard|LINK
Why don't you just put the result set in a DataTable? A DataTable is just a big array...