raghuraman_ace
07-05-2005, 07:10 PM
Hi
Am in the pocket pc development.I am told to use the data from the xml file.This xml file comes from the web service.It is assumed that, totally there would be 10 xml files.Each may contain 1000 to 5000 records.
So,we decided to use sqlce as the database on the device.I could use sqlce objects
dataset.readxml('xmlfile.xml') & and then using the insert statement inerted some thousands records.
** Reading the xml file seems time consuming.
** Getting the data from the dataset and using insert statement again seems time consuming.
Please tell me the efficiant way of transfering the xml data into sqlserver ce.
Regards
Raghu
Am in the pocket pc development.I am told to use the data from the xml file.This xml file comes from the web service.It is assumed that, totally there would be 10 xml files.Each may contain 1000 to 5000 records.
So,we decided to use sqlce as the database on the device.I could use sqlce objects
dataset.readxml('xmlfile.xml') & and then using the insert statement inerted some thousands records.
** Reading the xml file seems time consuming.
** Getting the data from the dataset and using insert statement again seems time consuming.
Please tell me the efficiant way of transfering the xml data into sqlserver ce.
Regards
Raghu