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

------------------------------------------------------------
We're hiring! B-Line Medical is seeking .NET
Developers for exciting positions in medical product
development in MD/DC. Work with a variety of technologies
in a relaxed team environment. See ads on Dice.com.

On Wed, 13 Jun 2007 21:52:36 -0700, archana
<tr**************@yahoo.comwrote:

>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.

[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

aHi all,
a>
aI want to read csv file into datatable. Is there any csv reader and
awriter available for freeware.
a>
aI am reading csv file using schema.ini file. I don't want this
adependency. The problem while reading csv is that datatype depend on
afirst 8 or 16 rows depend in value set in registry.
a>
aIs there any option provided in framework 2.0 to read content of csv
afile into datatable properly means without truncation or without data
atype conversion?
a>
aPlease help me asap.
a>
athanks 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.