The phrase "to be sweet" means to be kind, pleasant or agreeable. It can also refer to something that is enjoyable or delightful.