Re: How can I convert text file to DataTable?

From: Ginny Caughey [MVP] (ginny.caughey.online_at_wasteworks.com)
Date: 04/30/04 

Date: Fri, 30 Apr 2004 16:37:52 -0400

Apparently I wasn't very clear. You have to read in the entire text file one
time. If you then write the data out to a SqlCe database, you can delete the
text file and only read/write the data you need from SqlCe. 

-- 
Ginny Caughey
.Net Compact Framework MVP
"tiger79" <poli@freemail.nl> wrote in message
news:%23UN3eWoLEHA.3904@TK2MSFTNGP09.phx.gbl...
>
> Hi Ginny,
> I am doing kinda what Kimo is doing. I want to read data from an txt file
> into an sql databse. Though u are mentioning it is possible to get only
the
> needed data out of the txt file ? How would I manage to do so ?
> Thanks...
>
>
> "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in
message
> news:%235%23IjEILEHA.3332@TK2MSFTNGP10.phx.gbl...
> > Kimo,
> >
> > You could use a SqlCe database to store the data. Accessing just the
data
> > you need from it might be faster than reading in the entire text file,
> > although you will still have the initial time to create and fill the
> > database.
> > -- 
> > Ginny Caughey
> > .Net Compact Framework MVP
> >
> > "Kimo" <anonymous@discussions.microsoft.com> wrote in message
> > news:D4799EE9-C1BF-4558-82F9-B4045B4EA935@microsoft.com...
> > > Thanks Ginny,
> > >
> > > The CSV class  enhances the performance of my app.
> > >
> > > But I would like to ask about another matter:
> > > I convert the text file containing data to temporary DataSet each time
I
> > run the app, and that causes time losses. So how can I build static
> database
> > on pocket pc to contain data stored in the text file. I want to build it
> in
> > the first time I run the app and then access it after that instead of
> > conversion operation each time.
> > >
> > > Thanks,
> > > Kimo
> >
> >
>
>

Relevant Pages

  • Re: Data Transfer using ActiveSync
    ... > a sqlce database to a collect.txt file for export to the PC. ... So this is what I did for my ppc app. ... > with a database now as this is to talk with an aged legacy system. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Data Transfer using ActiveSync
    ... >> I've built my first ppc app using CF VB.net 2003. ... >> a sqlce database to a collect.txt file for export to the PC. ... >> with a database now as this is to talk with an aged legacy system. ... and then provide to them this xml file customized for their ...
    (microsoft.public.dotnet.framework.compactframework)
  • Data Transfer using ActiveSync
    ... I've built my first ppc app using CF VB.net 2003. ... with a database now as this is to talk with an aged legacy system. ... Currently I'm saving all data in a sqlce database. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: How can I convert text file to DataTable?
    ... You could use a SqlCe database to store the data. ... Ginny Caughey ... "Kimo" wrote in message ... > The CSV class enhances the performance of my app. ...
    (microsoft.public.pocketpc.developer)