loading data from csv file

[AVL]

Hi,
I've a requirement to load the data froma csv file to sql server table
programaticlly..
I'm working with .net 1.1..so i can't use sqlbulkcopy concept..

which is the best approach to load the daat wrt performance...

as of now, i'm planning to populate into a dataset and loop through the
dataset
record by record and update into the db..is there any other alternative?

 

[Mark Rae [MVP]]

I've a requirement to load the data froma csv file to sql server table
programaticlly..
I'm working with .net 1.1..so i can't use sqlbulkcopy concept..

which is the best approach to load the daat wrt performance...
as of now, i'm planning to populate into a dataset and loop through the
dataset
record by record and update into the db..is there any other alternative?

You asked this question on 8th February - it has already been answered...

 

[AVL]

But the solution specified is wrt to .Net 2.0..i'm working on .net 1.1.
Thats why I've posted againg