I'm importing data from a CSV file. I am reading the file in using TextFieldParser and while I read it in I am building an INSERT sql statement on the fly. Here is what the SQL statement looks like:



INSERT INTO STITagsImport (TagNumber)

SELECT tbl.Expr1 FROM (

SELECT 'ATV0E0' AS Expr1 UNION ALL

SELECT 'ATV0E0' AS Expr1 UNION ALL

SELECT '1180849' AS Expr1 UNION ALL

SELECT 'END' AS Expr1

) AS tbl



The reason I am doing this is because I dont want to make four separate round trips to the database with four separate INSERT statements. I was just wondering if there was a better way.

Not without specifying the parameters explicitly.  And building the command dynamically.  You might also look at the SQL bulk update functionality... especially if you're updating more than just 4 rows.  System.Data.SqlClient.SqlBulkCopy is the object, I think.

Thanks for the suggestion Ben. I thought my way was pretty clever I just was curious if there was a better way.

It is very clever.  And bulk updates might not be for you