I've got a similar issue to the question posed on EE here; http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_23022296.html
but the resolution doesn't work with mine.
Basically I have a MSSQLCE database with a number of tables, which has been added to my vb 2005 project as a datasource, and I have created a standard form which has had the fields bound to the datasource by dragging and dropping from the datasource tab onto the form. There is also a 'New' and a 'Save' button.
Clicking the 'New' button does the following:
I can then enter data onto the form and click the 'Save' button' to save the data, which does the following:
(There are actually more fields than specified in the Insert)
Now this works, but I would have thought one of the advantages of databinding was that I shouldn't have to specify every field that needs to be inserted and the code in the link above seems to back this up.
Any help would be appreciated.