Storing bulk data from dataset to sql mobile 2005 using c#

hi,

I have developed an application in c#.net 2.0 for Pocket PC. And even i developed a webservice to communicate between sql server 2005 and sql mobile 2005. Webservice returns the data in a dataset format from sql server 2005, but while inserting the data row by row from dataset, it is taking a huge amount of time. I would like to know, is there any way where i can copy the bulk data from dataset into the sql mobile 2005 using c#.And how this can be achieved.

Thank you

[497 byte] By [prashantmulay] at [2007-12-19]
# 2

look at using the SqlCeResultSet to apply the rows in your dataset to the underlying SQL Mobile table.

Darren

DarrenShaffer at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Compact Edition...

SQL Server

Site Classified