TextFieldParser into DataTable

Question

I have a csv file read into a TextFieldParser. Before I place the data rows into a DataTable, I want to add a couple of extra fields that are not in the csv.

This line writes all the csv data into the table ok -

        tempTable.Rows.Add(parser.ReadFields())

If I do something like this -

        tempTable.Rows.Add(parser.ReadFields(), stationID, sMaxSpeedDecimal, sqlFormattedDate)

the Row.Add seems to treat all the Parser data as one field and then appends the new columns. Basically the parser data is lost to the database. How can I add additional columns so the tempTable.Rows.Add includes all the parser data plus new column data in one write?

Answer 1

You must either pass one array containing all the field values or else pass all the field values individually. Because you are passing multiple arguments, it is assumed to be the latter and the array is treated as one field value. You must either break up the array and pass each field individually, e.g.

Dim fields = parser.ReadFields()

tempTable.Rows.Add(fields(0), fields(1), stationID, sMaxSpeedDecimal, sqlFormattedDate)

or else combine the extra field values with the original array to create a new array, e.g.

Dim fields = parser.ReadFields().Concat({stationID, sMaxSpeedDecimal, sqlFormattedDate})

tempTable.Rows.Add(fields)