Mobile Apps - Import txt file to sqlce table

Asked By Fergest

21-Jul-08 10:12 AM

Hii
said that are brand new environment VST 2005
I'm trying to implement an application for pocket
when would the need to import data into a table
(Articles)
with three fields ID Code, Description
an archive. sdf on the pocket, from a txt file, the data are on txt
delimited;

I do not know the best idea how to do that.

Thank you all for any answers possibly with a
small example

sorry for my English

21-Jul-08 10:30 AM

Please see my reply to you on the Sqlserver.ce newsgroup.

--

Ginny Caughey
Device Application Development MVP

21-Jul-08 11:00 AM

Thanks for your answer mahh ...
I can not see the answer on news grop indicated thanks
F.Rino

21-Jul-08 02:09 PM

I don't see it either, so here's the reply again:

The easiest way is to use a 3rd party product like this:
http://www.primeworks-mobile.com/Products/DataPortConsole.html

Or just write your own code to read the text file and write the data out to
the SQL CE sdf file.

--

Ginny Caughey
Device Application Development MVP

22-Jul-08 01:57 AM

I want to learn how to write code, to read the text file and write data in
sql ce sdf how to do?
you can help me?
small example code.

thank you

excuse for my English

Ferrari Rino (Italy)

22-Jul-08 08:07 AM

Another method that has worked well for me and might work for you, is to
create a text file consisting of Sql statements.  Inserts, Updates, and or
Deletes.  Then write some code that reads the file line by line and executes
each sql statement.  It's a low tech, and flexible way to get new data into
you Pocket PC.  Once you have it working, you do not have to revisit the
code when the database design changes.  Just modify your SQL statements to
account for the new schema.

RDub