Saving Data to a Database (VB2005, SQL Server2005)

[EDN Admin]

Hi,

When using the code<table border="0" cellspacing="0" width="100% <tr><td width="15 </td><td bgcolor="lightgrey" width="15 </td><td bgcolor="lightgrey
<font face="Lucida Console" size="2 <span style="COLOR: blue <font color= "blue Try</font>
<span style="COLOR: blue <font color= "blue Me</font>.Validate()
<span style="COLOR: blue <font color= "blue Me</font>.CustomersBindingSource.EndEdit()
<span style="COLOR: blue <font color= "blue Me</font>.CustomersTableAdapter.Update(<span style="COLOR: blue <font color= "blue Me</font>.NorthwindDataSet.Customers)
MsgBox("Update successful")

<span style="COLOR: blue <font color= "blue Catch</font> ex <span style="COLOR: blue <font color= "blue As</font> Exception
MsgBox("Update failed")
<span style="COLOR: blue <font color= "blue End</font> <font color= "blue Try</font></font>
</td></tr></table>in the walkthrough given in http://msdn2.microsoft.com/en-us/library/0f92s97z.aspx http://msdn2.microsoft.com/en-us/library/0f92s97z.aspx http://msdn2.microsoft.com/en-us/library/0f92s97z.aspx , changes were not saved to the <font color="#ff0000" size="2 NORTHWND.MDF</font> file in the project folder or bin folder <font color="#ff0000" size="2 (not updated)</font>. Does any one know why?

Thanks.

View the full article