How do you update automatically created strongly-typed datasets? [modified]
-
This one is driving me mad - hope someone can help. I have a VB.Net app in VS2005 and I wanted to bind it to a SQL Server 2005 table so I dragged a DataGridView control onto a form and defined the datasource to come from the table I want to use and VS2005 went ahead and generated the XSD and the screeds of code which is great. I then refined my table (using SQL Server Studio, not VS2005), adding a new column and changing a couple of column types in the DB table but I can't see ANY way to get VS2005 to get the updated table except to trash the generated Dataset, BindingSource and TableAdapter objects and do the whole binding exercise all over again! I've tried right-clicking and doing a refesh wherever I can that option but it never updates the code behind or the XSD. Now, I seem to remember in VS2003 there was a "Regenerate" command (or something like that) so where the heck is the equivalent in VS2005? Right-clicking on the XSD file in solution explorer has an option "Run custom tool" which I think runs "MSDataSetGenerator" but it doesn't seem to refresh or regenerate anything! I've searched high and low and looked everywhere but I can't see any way to keep the VS2005 table concurrent with the underlying DB table - surely with the integration of SQL Server and .Net 2.0 I'm not expecting the impossible? Can someone help me out here and tell me what I'm missing? TIA... Mike -- modified at 18:00 Saturday 4th November, 2006