CodeLiftsleep
Member
- Joined
- Mar 11, 2016
- Messages
- 20
- Programming Experience
- 3-5
Ok, I have a very specific situation that this would be useful for.
I have a DataTable with a large number of columns(200+) that I am doing a bulk insert for in SQLite, since it does not support Update Table like SQL Server does.
I want to know if there is a way after I iterate over all the columns in a row and stick their values into a list(list of 200+ items---some integers, some floats, some strings) if there is a way to take those list values and put them all into an SQL statement such as:
"INSERT INTO TableName VALUES(List values each separated by a comma)"
I know I can iterate over the list again and then stick each item into a string or object but that is extra processing to be done. In python you can just get the values from the list by returning the list, but that doesn't work in VB. I was wondering(I am thinking there would have to be) if there is a way to do this without having to create a separate object to then hold all the values from the list after iterating over them and getting them out.
I have a DataTable with a large number of columns(200+) that I am doing a bulk insert for in SQLite, since it does not support Update Table like SQL Server does.
I want to know if there is a way after I iterate over all the columns in a row and stick their values into a list(list of 200+ items---some integers, some floats, some strings) if there is a way to take those list values and put them all into an SQL statement such as:
"INSERT INTO TableName VALUES(List values each separated by a comma)"
I know I can iterate over the list again and then stick each item into a string or object but that is extra processing to be done. In python you can just get the values from the list by returning the list, but that doesn't work in VB. I was wondering(I am thinking there would have to be) if there is a way to do this without having to create a separate object to then hold all the values from the list after iterating over them and getting them out.