StrataFrame Forum » .NET Forums » General .NET Discussion » Inserting records into a table....

Inserting records into a table....

StarkMike — Mon, 15 Jan 2007 12:34:30 GMT

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.

RE: Inserting records into a table....

StrataFrame Team — Mon, 15 Jan 2007 12:34:30 GMT

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

RE: Inserting records into a table....

StarkMike — Mon, 15 Jan 2007 11:49:24 GMT

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

RE: Inserting records into a table....

StrataFrame Team — Mon, 15 Jan 2007 11:06:00 GMT

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.