ADO.NET :: Sql Insert Into Database Visual Studio 2010

I am having an issue with my Windows forms application. I am trying to insert a record into a table. It says the rows affected is 1 however the row is not in the database. Here is my code:

<code>
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("AddSong",new System.Data.SqlClient.SqlConnection(Properties.Settings.Default.Database1ConnectionString));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@length", dict["Total Time"]);
cmd.Parameters.AddWithValue("@genre", dict["Genre"]);
cmd.Parameters.AddWithValue("@name", dict["Name"]);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
</code>