Read only first line in CSV

[David]

I need to read only the first row in the CSV (Header Row), then I can
use the column headers to build a create table SQL statement to create
the table in my database.

How can I read only the first line and display it on my web
application?

[shriop]

You just construct the CsvReader instance and either call ReadRecord
or ReadHeaders once. You can then access all the values in the row
through the corresponding properties depending on which method you
called. When you're done, just close the CsvReader instance. Reading
just the first row should be the same as reading the whole file, other
than you might have used CsvDataReader if you were bulk inserting the
file, but you'd want to use CsvReader to just read a single line.

Bruce Dunwiddie