Help importing csv

[MFRASER]

Does anyone have a good way of importing a csv file into an object?

Entity1,123,22,red,blue
Entity2,123,22,red,blue
Entity3,123,22,red,blue
Entity4,123,22,red,blue
Entity5,123,22,red,blue

Currently I am spliting the data and then creating two for loops to loop
through the rows and then each column to assign the corresponding object
property.

[C-Sharper or C-Hasher, one of the two]

What about this option:

Add a new constructor to your object that takes a string in like so:
public void MyObject(string PropertiesCSV)
{
string[] ListOfProperties = PropertiesCSV.Split(",")
for(int i=0;i<ListOfProperties.GetUpperBound(0);i++)
{
this.var1 = ListOfProperties[i];
...
this.var99 = ListOfProperties[i]
}
}

Then all you need is one loop for each line in the CSV. I know this doesn't
exactly change your problem, it just shifts where the inner loop sits.

Hope this has been of some help.

Greg

"MFRASER" <mf*****@henwoodenergy.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Does anyone have a good way of importing a csv file into an object?

Entity1,123,22,red,blue
Entity2,123,22,red,blue
Entity3,123,22,red,blue
Entity4,123,22,red,blue
Entity5,123,22,red,blue

Currently I am spliting the data and then creating two for loops to loop
through the rows and then each column to assign the corresponding object
property.

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

Take a look at http://www.opennetcf.org/Csv.asp
I'm using it and it works great.

Cheers,
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"MFRASER" <mf*****@henwoodenergy.com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Does anyone have a good way of importing a csv file into an object?

Entity1,123,22,red,blue
Entity2,123,22,red,blue
Entity3,123,22,red,blue
Entity4,123,22,red,blue
Entity5,123,22,red,blue

Currently I am spliting the data and then creating two for loops to loop
through the rows and then each column to assign the corresponding object
property.