Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pocket PC Application
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Visual FoxPro et .NET
Divers
Thread ID:
00891724
Message ID:
00892962
Vues:
25
>Thanks - I hope you'll manage to make this work, and will share the secret with me...

Hi Doru,
I have just finished some tests with xml and it works (didn't have dubt on this).
I have exported a VFP7 table with
=CURSORTOXML("thetable", "thefile.xml" ,3,512,0,"")
then copied (manually with pocketpc File Explorer and a shared folder on the PC) the XML file to the emulator, then read the file and inserted the records into a SQLCE database.
the snipped code for load the xml is:
Dim dataset2 As New DataSet
Dim oconn As New SqlServerCe.SqlCeConnection("the connection string to sqlce")
Dim lcpath As String = System.IO.Path.Combine(goapp.wrkdir, "thefile.xml")

dataset2.ReadXml(lcpath)

Dim da As New SqlServerCe.SqlCeDataAdapter("select * from the_table_in_the_xml_file", oconn)
Dim cb As New SqlServerCe.SqlCeCommandBuilder(da)

da.Update(dataset2.Tables("thetable"))
you are done!
HTH

Franco
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform