public static string Updatecommand = "UPDATE tblFilm SET titel=@titel, beschrijving=@beschrijving" +
                                "duur=@duur, prijs=@prijs,supplement=@supplement" +
                                "WHERE ID=@ID";
        public static string Insertcommand = "INSERT INTO tblFilm (titel, beschrijving,duur,prijs,supplement) VALUES (@titel,@beschrijving,@duur,@prijs,@supplement)";
        public static string getNieuwID = "SELECT ID FROM * DESC";
        public static string selectCommand = "SELECT * FROM tblFilm";
        public static string deleteCommand = "DELETE * FROM tblFilm WHERE ID=@ID";