VB Code:
  1. Public Sub Update(ByVal CommandText As String, ByRef MyData As DataSet)
  2.         Dim Comm As SqlCommand
  3.         If _Transaction Is Nothing Then
  4.             Comm = New SqlCommand(CommandText, Connection)
  5.         Else
  6.             Comm = New SqlCommand(CommandText, Connection, _Transaction)
  7.         End If
  8.         Dim da As New SqlDataAdapter(Comm)
  9.         da.UpdateCommand = Comm
  10.         da.Update(MyData)
  11.     End Sub
That's what I have.
It doesn't error, but it also doesn't update my DB.
I use (and I know * is bad, but it's testing) the following as the CommandText:
Code:
SELECT * FROM Customers
So I fetch a dataset using the above sql, and then I use the above update statement to save it. I know I am doing something REALLY daft.

Woka