master/slave

[jagguy]

this does not update a record and gives no error. the fields exists in Access, there is data in the textfield, and the paramaters names seem ok.

????

  Dim command As OleDbCommand = New OleDbCommand
        Dim myone As Integer

        command.Connection = cn
        command.CommandText = "update departments set dname =@two where deptno =@one"
        ' MsgBox(txtdeptno.Text)
        command.Parameters.Add("@one", txtdeptno.Text)
        command.Parameters.Add("@two", txtDname.Text)
       
        cn.Open()
        command.ExecuteNonQuery()

        ' command2.ExecuteNonQuery()

        cn.Close()