I'm trying to configure some parameters for a data adapter that will connect to a MySQL data source. I'm unfamiliar with how to do this using DBCommand. I've included my sql query below. The idea is query Table1 and then update STATUS and STATUSDATE as needed.
cmd.CommandText = "SELECT UserID, CheckListID, Status, STATUSDATE FROM Table1 WHERE UserID = @UserID AND CheckListID = @CheckListID"