Save button for SQL Server in vb.net
<p>I have created a Save button for SQL Server in vb.net. I'm using Visual Studio 2012. I get this error:</p>

<blockquote>
  <p>This SqlTransaction has completed; it is no longer usable.</p>
</blockquote>

<p>as soon as I click on the button.</p>

<p>My code Looks like this.</p>

<pre><code>Private Sub BtnSave_Click(sender As Object, e As EventArgs) Handles BtnSave.Click
    Me.Validate()
    Me.AnimalDetailsBindingSource.EndEdit()
    Me.TableAdapterManager.UpdateAll(Me.Animal_RecordsDataSet)
End Sub
</code></pre>

<p>It worked fine but not anymore.</p>

<p>The error comes up at:</p>

<pre><code>Me.TableAdapterManager.UpdateAll(Me.Animal_RecordsDataSet)
</code></pre>

<p>I am new to working with databases in software. Can anybody please let me know where I went wrong or what I should do different?</p>