As the subject states, I am looking for a way to store database items/records inside variables. I am not pulling one value, but 9 fields and hundreds of rows. Thus, I cannot use ExecuteScalar or the like.
What I am doing is pulling the multiple rows of these 9 fields (there are more fields in the DB, these are just the ones I have filtered out as needed) and want to output the data as a CSV. I have no problem with text manipulation nor binding data to a control on a form. I am writing a function in VB.net for someone else to call from their ASP.net page. In this particular situation, I do not need to retain or modify the data just take the data, manipulate it into CSV format, and output.
So far the whole program is written save for assigning a variable to the field values i.e.:
Dim sFName As String
Dim sLName As String
Dim sUID As String
sFName = <enter code>
sLName = <enter code>
sUID = <enter code>
As I said, I have no problem with the manipulation, nor with binding data fields to controls... but I cannot use controls in this particular situation.
Any suggestions?
What I am doing is pulling the multiple rows of these 9 fields (there are more fields in the DB, these are just the ones I have filtered out as needed) and want to output the data as a CSV. I have no problem with text manipulation nor binding data to a control on a form. I am writing a function in VB.net for someone else to call from their ASP.net page. In this particular situation, I do not need to retain or modify the data just take the data, manipulate it into CSV format, and output.
So far the whole program is written save for assigning a variable to the field values i.e.:
Dim sFName As String
Dim sLName As String
Dim sUID As String
sFName = <enter code>
sLName = <enter code>
sUID = <enter code>
As I said, I have no problem with the manipulation, nor with binding data fields to controls... but I cannot use controls in this particular situation.
Any suggestions?