Reading csv file into datatable.

[archana]

Hi all,

I want to read csv file into datatable. Is there any csv reader and
writer available for freeware.

I am reading csv file using schema.ini file. I don't want this
dependency. The problem while reading csv is that datatype depend on
first 8 or 16 rows depend in value set in registry.

Is there any option provided in framework 2.0 to read content of csv
file into datatable properly means without truncation or without data
type conversion?

Please help me asap.

thanks in advance.

 

[Samuel R. Neff]

This is a really wonderful CSV reader. Download project even includes
500+ unit tests.

http://www.codeproject.com/cs/database/CsvReader.asp

Provides both a custom api and an IDataReader implementation.

HTH,

Sam

 

[Marc Gravell]

Seconded; I use that reader; very effective.

Marc

 

[Michael Nemtsev]

Hello archana,

Alternative solution is to use SQL DTS

---
WBR, Michael Nemtsev [.NET/C# MVP].
My blog: http://spaces.live.com/laflour
Team blog: http://devkids.blogspot.com/

"The greatest danger for most of us is not that our aim is too high and we
miss it, but that it is too low and we reach it" (c) Michelangelo

a> Hi all,
a>
a> I want to read csv file into datatable. Is there any csv reader and
a> writer available for freeware.
a>
a> I am reading csv file using schema.ini file. I don't want this
a> dependency. The problem while reading csv is that datatype depend on
a> first 8 or 16 rows depend in value set in registry.
a>
a> Is there any option provided in framework 2.0 to read content of csv
a> file into datatable properly means without truncation or without data
a> type conversion?
a>
a> Please help me asap.
a>
a> thanks in advance.
a>

 

[archana]

Hi all,

thanks for replies.

I want to do some validation on that csv file and also wants to update
that csv file. So my preference is to use it in code in service.

I am facing 2 major problem one is of datatype conversion and other is
if file name contains dot then its not working.

Can you tell me how to solve both this problem.

I am expecting some way to remove this limitation. Is there any
solution in framework 2.0 for this.

thanks in advance.