Create MySQL Trigger manually using VB.NET Application (Systax Error)

Question

I'm new with MySQL Triggers. I would like to create MySQL Triggers programmatically using my VB.NET Application so first I create a query using MySQL Workbench test it and it was a success but when I copied the query to my VB.NET Application and put it on string variable and tried to execute it. the error pops up that I have a Syntax error.

DELIMITER $$
CREATE TRIGGER `updateProductPrice`
BEFORE UPDATE ON `list_events`
FOR EACH ROW
BEGIN
  IF NEW.caption <> OLD.caption
    THEN
      SET NEW.caption = 1;
  END IF ;
END$$
DELIMITER ;

Answer 1

As P.Salmon said don't use DELIMITER

Use only

CREATE TRIGGER `updateProductPrice`
BEFORE UPDATE ON `list_events`
FOR EACH ROW
BEGIN
  IF NEW.caption <> OLD.caption
    THEN
      SET NEW.caption = 1;
  END IF ;
END

as content for your string variable.