Hello, I'm using this:
VB Code:
  1. Private dacustomers As New SqlClient.SqlDataAdapter
  2.     Private selectcom As New SqlClient.SqlCommand("SELECT * FROM Customers")
  3.     Private ds As New DataSet("Northwind")
  4.     Private SQLCount As String = "SELECT Count(CustomerID) FROM Customers"
  5.     Private RecordCount As Integer
  6.     Private bmCustomers As BindingManagerBase
  7.     Private InsBuilder As New StringBuilder
  8.     Private EDBuilder As New StringBuilder
  9.  
  10.    Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
  11.  
  12.         If btnAdd.Text = "ADD" Then
  13.             btnAdd.Text = "Finish"
  14.             TextBox1.Text = ""
  15.             TextBox2.Text = ""
  16.             TextBox3.Text = ""
  17.         Else
  18.             btnAdd.Text = "ADD"
  19.             'SqlConnection1.Open()
  20.  
  21.             InsBuilder.Append("INSERT INTO Customers (CompanyName,CustomerID,ContactName) ")
  22.             InsBuilder.Append("VALUES (")
  23.             InsBuilder.Append(TextBox1.Text)
  24.             InsBuilder.Append(",")
  25.             InsBuilder.Append(TextBox2.Text)
  26.             InsBuilder.Append(",")
  27.             InsBuilder.Append(TextBox3.Text)
  28.             InsBuilder.Append(")")
  29.             Dim InsComm As New SqlClient.SqlCommand("InsBuilder")
  30.             dacustomers.InsertCommand = InsComm
  31.             dacustomers.InsertCommand.ExecuteNonQuery()
  32.         End If
  33.     End Sub
  34.  
  35.     Private Sub btnEdit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnEdit.Click
  36.         If btnEdit.Text = "EDIT" Then
  37.             btnAdd.Text = "Update"
  38.             TextBox1.Text = ""
  39.             TextBox2.Text = ""
  40.             TextBox3.Text = ""
  41.         Else
  42.             btnAdd.Text = "EDIT"
  43.             EDBuilder.Append("UPDATE Customers SET ")
  44.             EDBuilder.Append("CompanyName = ")
  45.             EDBuilder.Append(TextBox1.Text)
  46.             EDBuilder.Append(",")
  47.             EDBuilder.Append("CustomerID = ")
  48.             EDBuilder.Append(TextBox2.Text)
  49.             EDBuilder.Append(",")
  50.             EDBuilder.Append("ContactName = ")
  51.             EDBuilder.Append(TextBox3.Text)
  52.  
  53.             dacustomers.SelectCommand.ExecuteNonQuery()
  54.         End If
  55.     End Sub

to try add and edit records, but The compiler keeps throwing me out, complaining about a table not specified

How can I fix this, to add and edit records at run time?