loading data from csv file

[=?Utf-8?B?QVZM?=]

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

Re: loading data from csv file

"AVL" <AVL@discussion s.microsoft.com wrote in message
news:97A647BD-194D-4568-B205-4CCA99EF26CD@mi crosoft.com...

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


--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[=?Utf-8?B?QVZM?=]

Re: loading data from csv file

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

"Mark Rae [MVP]" wrote:

"AVL" <AVL@discussion s.microsoft.com wrote in message
news:97A647BD-194D-4568-B205-4CCA99EF26CD@mi crosoft.com...
>

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...
>
>
--
Mark Rae
ASP.NET MVP

http://www.markrae.net

>
>