Class QueryExecutor is in charge of queries.

QueryExecutor.cs

 class QueryExecutor {
        string strQuery;
        CreateConnection c;
        public QueryExecutor(string query) {
            strQuery = query;
            c = new CreateConnection();
        }
 
        public QueryExecutor(string query, string strConnection) {
            strQuery = query;
            c = new CreateConnection(strConnection);
        }
 
 
        public void ExecuteQuery() {
            if (c.EstablishConnection()) {
                SqlCommand cmd = new SqlCommand(strQuery, c.sqlConnection);
                try {
                    cmd.ExecuteNonQuery();
                    MessageBox.Show("Successfully Command Executed", "Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    c.CloseConnection();
                }
                catch (Exception e) {
                    MessageBox.Show("Query Executor Error: " + e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    c.CloseConnection();
                }
            }
            else {
                MessageBox.Show("Error Establishing Connection.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
                c.CloseConnection();
            }
        }
    }