SqlCeConnection con = new SqlCeConnection(WpfRestoran.Properties.Settings.Default.DatabaseRConnectionString);
con.Open();
SqlCeCommand scom = new SqlCeCommand("UPDATE PLASES SET ZAKAZID = 1", con);
MessageBox.Show(scom.ExecuteNonQuery().ToString());
con.Close();

                con.Open();
                SqlCeTransaction trans = con.BeginTransaction();
                SqlCeCommand scom = new SqlCeCommand("UPDATE PLASES SET ZAKAZID = 1", con);
                scom.Parameters.Clear();
                MessageBox.Show(scom.ExecuteNonQuery().ToString());
                trans.Commit();
                con.Close();

                scom = new SqlCeCommand("SELECT * FROM PLASES", con);
                con.Open();
                SqlCeDataReader myReader = scom.ExecuteReader();
                while (myReader.Read())
                {
                    MessageBox.Show(myReader["ZAKAZID"].ToString());
                }
                con.Close();