class DBConnect
    {
        public static string server = "127.0.0.1";
        public static string database = "guest";
        public static string user = "root";
         public static string password = "";
        public static string connectionString = "server=" + server + ";" + "database=" +
            database + ";" + "user=" + user + ";" + "password=" + password + ";";
        static MySqlConnection connection = new MySqlConnection(connectionString);
        // адаптер для выполнений запросов
        public static string SqlQuery = "";
        public static MySqlDataAdapter adapter = new MySqlDataAdapter(SqlQuery, connectionString);
        public static DataSet DS = new DataSet();
        public static MySqlCommandBuilder cb = new MySqlCommandBuilder();

        static public void SQLSelect(string SqlQuery = "select * from vcguests ORDER BY id DESC;")
            {
            try
            {
                MySqlDataAdapter adapter = new MySqlDataAdapter(SqlQuery, connectionString);
                adapter.Fill(DS,"vcguests");

            }
            catch (MySqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
            }

        //open connection to database
        static public bool OpenConnection()
        {
            try
            {
                connection.Open();
                return true;
            }
            catch (MySqlException ex)
            {
               switch (ex.Number)
                {
                    case 0:
                        MessageBox.Show("Нет соединения с сервером. Обратитесь к администратору");
                        break;

                    case 1045:
                        MessageBox.Show("Неверный логин/пароль для подключения к СУБД. Обратитесь к администратору");
                        break;
                }
                return false;
            }
        }

        //Update statement
        static public void SQLUpdate()
        {
           try
            {
                 adapter.Update(DS, "vcguests"); //
            }
            catch (MySqlException ex)
            {
                MessageBox.Show(ex.Message);

            }

        }

    }

public partial class MainWindow : Window
    {

public MainWindow()
        {
            InitializeComponent();
            DBConnect.OpenConnection();
            DBConnect.SQLSelect();
            //dataGuests.DataContext = DBConnect.DS.Tables["vcguests"];
            dataGuests.ItemsSource = DBConnect.DS.Tables["vcguests"].DefaultView;
        }


        private void dataGuests_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
        {
            DBConnect.SQLUpdate();
        }