After you fix the other issues already mentioned, you'll want to read the DBI docs on 'do', 'prepare', and 'execute'. Because 'do' does not return a statement handle, 'prepare' does. Then you can 'execute' it with arguments. Something like:

my $sth =
  $dbh->prepare('insert into tblfilm (name, price) values (?,?)';
$sth->execute($FilmName, $Price);

#Update: I forgot, 'do' also accepts placeholder arguments like this..
$dbh->do('insert into tblfilm (name, price) values (?,?)',
 undef, $FilmName, $Price);
[download]

Warning: I am not doing any error checking, but you might want to look at the RaiseError attribute for the connect statement, and the 'Transactions' section of the DBI docs for idiomatic error handling.