sqlce insert works, but...
i wrote first time app combine sqlce database(VS2008 c#): 

                    SqlCeCommand identChange = con.CreateCommand();
                    identChange.CommandText = "SET IDENTITY_INSERT contacts ON";
                    SqlCeCommand cmd = con.CreateCommand();
                    cmd.CommandText = "INSERT INTO contacts (contactID, firstName, cellularNumber) VALUES (1000, @name1 , @number)";
                    try
                    {
                        con.Open();
                        cmd.Parameters.AddWithValue("@name1", name1);
                        cmd.Parameters.AddWithValue("@number", number);
                        identChange.ExecuteNonQuery();
                        cmd.ExecuteNonQuery();
                        con.Close();
                    }
    
                    catch (SqlCeException ex)
                    {
                        //log ex
                    }
    
                    using (SqlCeCommand com = new SqlCeCommand("SELECT firstName FROM contacts", con))
                    {
                            con.Open();
                            SqlCeDataReader reader = com.ExecuteReader();
                            while (reader.Read())
                            {
                                string name = reader.GetString(0);
                                Console.WriteLine("there is " + name);
                            }
                            con.Close();
                    }

my problem is, when i read the table values its seems that the new row inserted properly,
but after it finish, when i look at the table data in the Server Explorer window, the new row doesn't exists

i would like to know what im missing...
sqlce insert works, but...
===

i wrote first time app combine sqlce database(VS2008 c#): 

                    SqlCeCommand identChange = con.CreateCommand();
                    identChange.CommandText = "SET IDENTITY_INSERT contacts ON";
                    SqlCeCommand cmd = con.CreateCommand();
                    cmd.CommandText = "INSERT INTO contacts (contactID, firstName, cellularNumber) VALUES (1000, @name1 , @number)";
                    try
                    {
                        con.Open();
                        cmd.Parameters.AddWithValue("@name1", name1);
                        cmd.Parameters.AddWithValue("@number", number);
                        identChange.ExecuteNonQuery();
                        cmd.ExecuteNonQuery();
                        con.Close();
                    }
    
                    catch (SqlCeException ex)
                    {
                        //log ex
                    }
    
                    using (SqlCeCommand com = new SqlCeCommand("SELECT firstName FROM contacts", con))
                    {
                            con.Open();
                            SqlCeDataReader reader = com.ExecuteReader();
                            while (reader.Read())
                            {
                                string name = reader.GetString(0);
                                Console.WriteLine("there is " + name);
                            }
                            con.Close();
                    }

my problem is, when i read the table values its seems that the new row inserted properly,
but after it finish, when i look at the table data in the Server Explorer window, the new row doesn't exists

i would like to know what im missing...