http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/SQL 2008 & Occasionally Connected Client Support in Visual Studio SP1http://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/en-usMon, 22 Sep 2008 20:51:37 GMTMon, 22 Sep 2008 20:51:37 GMTEvNet (EvNet, Version=1.0.3599.6114, Culture=neutral, PublicKeyToken=null)Javascript error on page, cannot see videohttp://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=429011Mon, 22 Sep 2008 20:51:37 GMThttp://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=4290110http://channel9.msdn.com/429011/WebViewBug.aspx?EVT=0Javascript error on page, cannot see videomichael10470http://channel9.msdn.com/429011/Trackback.aspx&gt;&gt;btw does the syncing stuff work other databases as well?<BR>Unfortunately, no. The Sync Services runtime does not support non-SQL Server databases.http://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=421288Wed, 13 Aug 2008 16:48:39 GMThttp://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=4212880http://channel9.msdn.com/421288/WebViewBug.aspx?EVT=0&gt;&gt;btw does the syncing stuff work other databases as well?Unfortunately, no. The Sync Services runtime does not support non-SQL Server databases.MilindL0http://channel9.msdn.com/421288/Trackback.aspx&gt;&gt; The moment the tables are synchronized (13:21) the order data changes<BR>Indeed. :-)<BR><BR>This is because after the sync I did a fill for the datasets. This clears and refills that dataset.<BR>A better approach is to use merge.<BR> <P>Me.NorthwindDataSet.Shippers.Merge(Me.ShippersTableAdapter.GetData())<BR><BR></P>http://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=421286Wed, 13 Aug 2008 16:46:37 GMThttp://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=4212860http://channel9.msdn.com/421286/WebViewBug.aspx?EVT=0&gt;&gt; The moment the tables are synchronized (13:21) the order data changesIndeed. :-)This is because after the sync I did a fill for the datasets. This clears and refills that dataset.A better approach is to use merge. Me.NorthwindDataSet.Shippers.Merge(Me.ShippersTableAdapter.GetData())MilindL0http://channel9.msdn.com/421286/Trackback.aspx<a href="http://channel9.msdn.com../../../Niners/Gregory />@Gregory:</a><br> <br> Its possible that when the dataset got repopulated, the current record was reset to the first record.http://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=421034Tue, 12 Aug 2008 08:38:50 GMThttp://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=4210340http://channel9.msdn.com/421034/WebViewBug.aspx?EVT=0@Gregory: Its possible that when the dataset got repopulated, the current record was reset to the first record.Murtaza0http://channel9.msdn.com/421034/Trackback.aspxbtw does the syncing stuff work other databases as well? the sql server spesific stuff dosnt work of course, but there was some mention of another technique with tables that vs generated? that would be awsome :)http://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=420771Mon, 11 Aug 2008 07:15:59 GMThttp://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=4207710http://channel9.msdn.com/420771/WebViewBug.aspx?EVT=0btw does the syncing stuff work other databases as well? the sql server spesific stuff dosnt work of course, but there was some mention of another technique with tables that vs generated? that would be awsome :)Allan Lindqvist0http://channel9.msdn.com/420771/Trackback.aspxagain with the letterboxing.. :/ <BR><BR>the small pip of the interview during on screen demos are awsome though :) <BR>http://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=420730Sun, 10 Aug 2008 22:00:36 GMThttp://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=4207300http://channel9.msdn.com/420730/WebViewBug.aspx?EVT=0again with the letterboxing.. :/ the small pip of the interview during on screen demos are awsome though :) Allan Lindqvist0http://channel9.msdn.com/420730/Trackback.aspxI really enjoyed the first video on sync, but this does make things so much easier.Having an employees table, suppliers etc. on a local machine does reduce the amount of hits on a server significantly. This is another reason why (for me at least) using the Linq to SQL ORM instead of datasets is a no brainer. Even the Entity framework will not have this level of support and I predict it will be some time before it does.<br><br>Keep up the great work!<br>http://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=420706Sun, 10 Aug 2008 18:05:53 GMThttp://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=4207060http://channel9.msdn.com/420706/WebViewBug.aspx?EVT=0I really enjoyed the first video on sync, but this does make things so much easier.Having an employees table, suppliers etc. on a local machine does reduce the amount of hits on a server significantly. This is another reason why (for me at least) using the Linq to SQL ORM instead of datasets is a no&#8230;vesuvius0http://channel9.msdn.com/420706/Trackback.aspx<P>The moment the tables are synchronized (13:21) the order data changes! The customer jumps from "Vins et alcools Chevalier"&nbsp;to "Alfreds Futterkiste", employee from "Buchanari" to "Davolio.", and shipper from&nbsp;"Federal Shipping" to "Speedy Express"... But I guess we didn't change that after our sync... How come?</P> <P>Sincerely, Greg.</P>http://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=420658Sat, 09 Aug 2008 22:45:47 GMThttp://channel9.msdn.com/posts/funkyonex/SQL-2008--Occasionally-Connected-Client-Support-in-Visual-Studio-SP1/?CommentID=4206580http://channel9.msdn.com/420658/WebViewBug.aspx?EVT=0The moment the tables are synchronized (13:21) the order data changes! The customer jumps from "Vins et alcools Chevalier"&nbsp;to "Alfreds Futterkiste", employee from "Buchanari" to "Davolio.", and shipper from&nbsp;"Federal Shipping" to "Speedy Express"... But I guess we didn't change that after&#8230;Gregory0http://channel9.msdn.com/420658/Trackback.aspx