Import a Comma separated txt file to SQL table
I need to read from disk a TXT file, comma separated, then to populate to SQL table.
By default I was thinking into use streamreader.readline(), parsing every record in order to split each field, then execute INSERT command in order to write a new record into SQL table.
Because I can not forget my days of C (K&R code) I would like to ask if somebody can give some ideas, in order to use all features of C#.
Perhaps some functions, something at help, etc.