• Do not disassociate the CommandBuilder from the DataSet.
• Build the commands yourself, either in code or through Visual Data Tools.

Back to the top

Steps to Reproduce the Behavior

1. Create a new Visual Basic .NET Windows Application project. Form1 is added to the project by default.
2. Add a Button control to Form1.
3. Switch to Code view, and add the following code to the top of the Code window:

   Imports System.Data.OleDb
   Imports System.Data.SqlClient
   					

4. Add the following code to the Click event of the Button:

           Dim con As New SqlConnection("server=myserver;uid=sa;pwd=mypassword;" & _
                                        "database=northwind")
           Dim da As New SqlDataAdapter("Select * From Customers", con)
           Dim cb As New SqlCommandBuilder(da)
           Dim cmdInsert As New SqlCommand( _
                  "Insert Into Customer (CustomerID) Value ('AAAAA')", con)
           da.InsertCommand = cmdInsert
           da.UpdateCommand = cb.GetUpdateCommand
           da.DeleteCommand = cb.GetDeleteCommand
           Debug.WriteLine(da.InsertCommand.CommandText)
           Debug.WriteLine(da.DeleteCommand.CommandText)
           cb.DataAdapter = Nothing ' Comment out this line to avoid the error.
           cb = Nothing
           Debug.WriteLine(da.InsertCommand.CommandText)     
           Debug.WriteLine(da.DeleteCommand.CommandText)  'Error occurs here.
   					

5. Modify your connection string as appropriate for your environment.
6. Press the F5 key to compile and to run the application.

Back to the top