Since you are posting in the SQL Mobile Forum, I'll assume you intend to store the data on device in SQL Server 2005 Mobile Edition. In this case, you can synchronize data from a SQL Server to your device using merge replication, remote data access, or web services. The SQL Mobile Books OnLine in combination with MSDN are the best place to start getting familiar with these concepts.
There are also some excellent books available on developing Compact Framework applications which all include the topic of synchronizing data between a server and device (using SQL CE, which is directly pertinent to SQL Mobile as well). My favorite among them is Paul Yao's ".NET Compact Framework Programming with C#" - a VB.NET version is also available.
Wireless synchronisation
Andy Kwok
Since you are posting in the SQL Mobile Forum, I'll assume you intend to store the data on device in SQL Server 2005 Mobile Edition. In this case, you can synchronize data from a SQL Server to your device using merge replication, remote data access, or web services. The SQL Mobile Books OnLine in combination with MSDN are the best place to start getting familiar with these concepts.
http://msdn.microsoft.com/mobility/sqlmobile/default.aspx
There are also some excellent books available on developing Compact Framework applications which all include the topic of synchronizing data between a server and device (using SQL CE, which is directly pertinent to SQL Mobile as well). My favorite among them is Paul Yao's ".NET Compact Framework Programming with C#" - a VB.NET version is also available.
-Darren