best way to get csv file data into sql table

[dissfigured]

I am importing a csv file from a public website, and loading it into a listview control.

There are about 30 columns on the display. I was about to create a stored procedure, and loop through the list view passing in all the columns as parameters and inserting 1 by 1.

It feels like a lousy solution.

Can someone sort of step by step explain how I can get the list view into the table using a cleaner solution. Maybe there is a way to build a data table in memory and bind it to the table in the SQL Server database and do an update r something?

Thanks for any help you can offer.

 

[MattP]

I would look into SQL Server's BULK INSERT.

How do I load text or csv file data into SQL Server?

Another option would be SqlBulkCopy. OpenRowSet on the csv would be a good way of getting the csv into a datatable.

SqlBulkCopy Class (System.Data.SqlClient)