"tiger79" <poli@freemail.nl> wrote in message
news:eumlwIrLEHA.2612@TK2MSFTNGP10.phx.gbl...
> Hi,
> i'd like to read data out of a text file directly into an SqlCe database.
> The textfile is something like this :
>
> 1;0;parent1;
> 2;0;parent2;
> 3;0;parent3;
> 4;1;child1parent1;
> 5;1;child2parent1;
> 6;2;child1parent2;
>
> so first number would be like an ID, second would be a parent_ID, and the
> last one some description.
> I don't know which charatcer is best used to separate data, I accept tips
> on
> that :)
>
> How do I manage to read it directly into the SQLCe database ? What is best
> used, the Streamreader class ?
> thanks
>
>

"Peter Foot [MVP]" <feedback@nospam-inthehand.com> wrote in message
news:Ort4mwrLEHA.3216@tk2msftngp13.phx.gbl...
> A common format for text file data is comma delimited (.csv). OpenNETCF's
> Smart Device Framework contains a DataAdaptor which will load your csv
file
> into a DataSet, you can then load this into your database.
> www.opennetcf.org/sdf/
>
> Peter
>
> --
> Peter Foot
> Windows Embedded MVP
> OpenNETCF.org Senior Advisor
> www.inthehand.com | www.opennetcf.org
>
> "tiger79" <poli@freemail.nl> wrote in message
> news:eumlwIrLEHA.2612@TK2MSFTNGP10.phx.gbl...
> > Hi,
> > i'd like to read data out of a text file directly into an SqlCe
database.
> > The textfile is something like this :
> >
> > 1;0;parent1;
> > 2;0;parent2;
> > 3;0;parent3;
> > 4;1;child1parent1;
> > 5;1;child2parent1;
> > 6;2;child1parent2;
> >
> > so first number would be like an ID, second would be a parent_ID, and
the
> > last one some description.
> > I don't know which charatcer is best used to separate data, I accept
tips
> > on
> > that :)
> >
> > How do I manage to read it directly into the SQLCe database ? What is
best
> > used, the Streamreader class ?
> > thanks
> >
> >
>
>