How to insert many rows of data from arrays/lists to SQL Server (DataSet, DataTable)
- by Kamil
I need little help with transferring data from variables, arrays, lists to my SQL Server.
Im not bad in SQL, but im not familiar with DataSet, DataTable objects.
My data is now stored in list of strings (List). Every string in that list looks similar to this:
QWERTY,19920604,0.91,0.35,0.34,0.35,343840
There are about 900000 rows like this.
Target datatypes in SQL Server:
BIGINT (primary key, im not inserting it, its identity(1,1))
VARCHAR(10),
DATE,
DECIMAL(10,2),
DECIMAL(10,2),
DECIMAL(10,2),
DECIMAL(10,2),
INT
How to convert that data to SQL Server data types?
How to insert that data into SQL Server? Also i need some progress bar updates between inserts.
I could do this using old-fashion SQL command, but i have learn more modern way :)
