Can't add data to database using SQL CRUD?

See more:

C#

SQL

database

Hi, so i'm making a database which is for a film system. I've made the database in SQL and i've used ado.net to display information from the database in a console application. I've been using SQL CRUD to add data from the console app into the database, but im having trouble adding text to the database. I've used the parameters to do this but it comes up with error saying "Failed to convet parameter value from a String to Int32". I changed the cm.Parameters["@FilmName"].Value into cm.Parameters["@FilmName"].ToString since obviously it couldnt add text using value, but it still comes up with an error.

Heres my code, the SQL Insert command part of the code is the part that needs changing.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace Database
{
    class Program
    {
        static void Main(string[] args)
        {
            try
            {
                // set up data connection
                string cs = "Data Source=MASTER\\MASTER;Initial Catalog=FilmDB;Integrated Security=True;Pooling=False";
                SqlConnection cn = new SqlConnection(cs);
                // Set up SQL command
                SqlCommand cm = cn.CreateCommand();
                ///
                ///Sql Select Command (Read table and return data)
                ///
                cm.CommandText = "SELECT FilmName, FilmGenre FROM [dbo].[Film];";
                // Set up adapter manager
                SqlDataAdapter da = new SqlDataAdapter();
                da.SelectCommand = cm;
                //Set dataset for results
                DataSet ds = new DataSet();
                ds.Clear();
                //Open Connection to database
                cn.Open();
                //Ask adapter to transfer data from table to dataset
                da.Fill(ds, "Film");
                //Set up data table
                DataTable dt = ds.Tables["Film"];
                //Read data from table rows
                foreach (DataRow dr in dt.Rows)
                {
                    Console.WriteLine(dr["FilmName"].ToString() + "\t\t\t\t" + dr["FilmGenre"].ToString());
                }
                ///
                /// SQL INSERT command
                /// 
                cs = "INSERT INTO [dbo].[Film] ( FilmID, FilmName, FilmGenre ) VALUES ( @FilmID, @FilmName, @FilmGenre );";
                cm.CommandText = cs;
                cm.Parameters.Add("@FilmID", SqlDbType.Int);
                cm.Parameters.Add("@FilmName", SqlDbType.Text);
                cm.Parameters.Add("@FilmGenre", SqlDbType.Text);
                cm.Parameters["@FilmID"].Value = 34;
                cm.Parameters["@FilmName"].Value = "Inception";
                cm.Parameters["@FilmID"].Value = "Action/Thriller";
                
                cm.ExecuteNonQuery();
                cn.Close();

            }
            catch (Exception ex)
            {
                Console.WriteLine("Error: " + ex.Message);
            }
            finally
            {
                //cn.close();
            }
        }
    }
}