Connecting Tech Pros Worldwide Forums | Help | Site Map

Question abour reading file

Eric Caron
Guest
 
Posts: n/a
#1: Jul 21 '05
Hi

Here's my question, I have to read a CSV file and import data in
DataSet. How I can do this in VB.NET ?

Is it possible to have import method to import file directly in
dataset ?

Thanks

William Ryan
Guest
 
Posts: n/a
#2: Jul 21 '05

re: Question abour reading file


Eric:

This should help, but the short answer is Yes, you can do it.

http://authors.aspalliance.com/ericm...les/textdb.asp

HTH,

Bill
"Eric Caron" <ecaron@pgsystem.com> wrote in message
news:rmcgnvg5gs9c9vf7qifc5do2murai3n08s@4ax.com...[color=blue]
> Hi
>
> Here's my question, I have to read a CSV file and import data in
> DataSet. How I can do this in VB.NET ?
>
> Is it possible to have import method to import file directly in
> dataset ?
>
> Thanks[/color]


Dino Chiesa [Microsoft]
Guest
 
Posts: n/a
#3: Jul 21 '05

re: Question abour reading file


A dataset can slurp in an XML file. If the file is properly formatted.

Also, There are utils and code samples roaming the net that can convert CSV
to XML.

Might be easier to just use a StreamReader to read the CSV file and do your
own population of the DataSet. Probably 35-40 lines of code.

-Dino


"Eric Caron" <ecaron@pgsystem.com> wrote in message
news:rmcgnvg5gs9c9vf7qifc5do2murai3n08s@4ax.com...[color=blue]
> Hi
>
> Here's my question, I have to read a CSV file and import data in
> DataSet. How I can do this in VB.NET ?
>
> Is it possible to have import method to import file directly in
> dataset ?
>
> Thanks[/color]


Closed Thread


Similar .NET Framework bytes