Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
Download data onto Windows Phone 7 from a web service (SQL Server Database)
Jason Nesbitt
May 27 2011 8:58 AM
4.5k
Reply
Hi.
I currently have a Windows Mobile 6/6.5 app that connects to a SQL Server and downloads a dataset from a webservice - This works fine because I add the reference of the class that contains the dataset/dataTable objects to the webservice and the project, so the data can be sent from the webservice and read on the phone.
I now need to make a lite version (using less of the database) on Windows Phone 7 but as I'm sure most are aware, the dataset object doesn't exist.
I've got SQLite working fine on Windows Phone 7 but I can't find a decent way of downloading the datasets/database tables from the webservice to put into the SQLite tables.
I've tried returning insert statements as string from the webservice so the phone can insert them straight into the SQLite database but it takes too long to loop through each row in the tables on the webservice.
I've also tried doing toXML() on all of the tables and sending it to the phone as a string but this also takes an extremely long time.
I can't think of any other ways to send the data - It would be brilliant if I could connect SQLite directly to the SQL Server Database and directly run statements to extract the data from it and populate the SQLite database.
Below gives an idea of the size of the database:
Table 1: 17,000 rows
Table 2: 9,000 rows
Table 3: 4,000 rows
The rest of the tables are < 4,000 rows
Any help would be greatly appreciated.
Kind regards,
Jason
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
A language supported in this XAP conflicts with a language that is already supported by another app instance for this app.
how to show .gif images in wp7