Error in Adding New Record

• Ariel Sison

  SSC Enthusiast

  Points: 119

  More actions

  May 31, 2005 at 8:25 pm

  #109722

  Hello Everyone,

  Im new user of VB.net and I have a problem. I tried to append new record in the author's database but an error always occured in the sqldataadapter1.update. The error is something like

  An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll

  Additional information: System error.

  If I modified certain records there's no error and the database is being updated with the new one. Pls help me fix my problem:

  Private Sub UpdateDataSet()

      Dim s As DataSet = New DataSet

      Me.BindingContext(DataSet11, "authors").EndCurrentEdit()

      s =

  CType(DataSet11.GetChanges, DataSet)

      If (Not (s) Is Nothing) Then

           Me.UpdateDataSource(s)

           DataSet11.Merge(s)

           DataSet11.AcceptChanges()

      End If

  End Sub

  Private Sub UpdateDataSource(ByVal c As DataSet)

       If (Not (c) Is Nothing) Then

           Me.SqlConnection2.Open()

           SqlDataAdapter1.Update(c)

           Me.SqlConnection2.Close()

       End If

  End Sub

• philcart

  SSC-Forever

  Points: 47797

  More actions

  May 31, 2005 at 9:27 pm

  #562066

  Please do not cross post.

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=186423

  Also, this has nothing to do with Notification Services so it shouldn't be posted here anyway

   

  --------------------
  Colt 45 - the original point and click interface