I'm writing an app in VB.Net 2008 that needs to transpose a list of values in a database.
I found that the Join command will just do that. Only works on arrays though.
The dataset only has one column. So I'm trying to find an elegant way of converting it to an array. I've got 18000 rows or so so I'd like to avoid looping through columns if at all possible.
My data more or less looks like this:
user_name
user_birthday
user_flavour
and I'd like to convert it to this:
user_name, user_birthday, user_flavour
Thanks in advance,
M
I found that the Join command will just do that. Only works on arrays though.
The dataset only has one column. So I'm trying to find an elegant way of converting it to an array. I've got 18000 rows or so so I'd like to avoid looping through columns if at all possible.
My data more or less looks like this:
user_name
user_birthday
user_flavour
and I'd like to convert it to this:
user_name, user_birthday, user_flavour
Thanks in advance,
M
Last edited: