2.0 System.Format Exception on Updates with Email Address

I am trying to talk to a SQL Mobile DB, using the Data Wizards.  I have dragged a table onto a fomr as both Datagrids and Textboxes, and the same error appears in both places.  When I try to call the update, which in turn calls:

Public Overloads Overridable Function Update(ByVal dataTable As taskDataSet.CompanyDataTable) As Integer

Return Me.Adapter.Update(dataTable)

End Function

I get the exception.  It seems to be choking on email addresses.  ANyoine have a solution




Answer this question

2.0 System.Format Exception on Updates with Email Address

  • GilesT

    The exception you get has nothing to do with the email address. There has been fixes made to the code that the wizard generates post beta2. The reason you get the exception is because you attempt to update the database in summary view and this does not work. To update the database you have to be in edit view and this will work as expected. Post Beta2 you will see that you are not able to edit the database when you are in summary view. Summary view is meant to be read only. In other for you to edit an entry in the database, click on the row in the datagrid, the summary view is then displayed (note: even though this view is editable in Beta2 - it should not be - this has been fixed post Beta2) to make changes/updates to the database when you are in summary view, click edit to get to the editview and make all neccessary changes. This changes will then be updated in the database.

    HTH,

  • ejunkie2005

    Can you explain this further.  I am having the same issue, but cannot find any reference to "edit" in regards to the datagrid.

    What do you mean by post Beta 2  

    Is there an update to the software

  • 2.0 System.Format Exception on Updates with Email Address