Re: How can I convert text file to DataTable?
From: Ginny Caughey [MVP] (ginny.caughey.online_at_wasteworks.com)
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" <email@example.com> 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]" <firstname.lastname@example.org> 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" <email@example.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 > > > > > >