4
Answers

Read CSV text file

Hello,
         I am new to asp.net c# were i need to develop a website which accept the text file by file upload ,were the text file will be looking like this


eg:

one,two,three,four,five,six,seven,eight,nine,ten
one,two,three,four,five,six,seven,eight,nine,ten
one,two,three,four,five,six,seven,eight,nine,ten
one,two,three,four,five,six,seven,eight,nine,ten
one,two,three,four,five,six,seven,eight,nine,ten
which has 5 rows and 10 column which is separate  by comma delimiter and i need to read the string into the mysql database but before that i need to read those value into string array and .
now the problem is i need only certain values for example

eg:

one,four,seven,ten
one,four,seven,ten
one,four,seven,ten
one,four,seven,ten
one,four,seven,ten

in here i only need one four seven and ten column value or string from every row.
I need coding to do this process.

thank you in advance.
Answers (4)