using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace App_19127650_DragonCompany
{
    public partial class Form1 : Form
    {
        String sConnString = "";//parameter to connect to db server
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

        }

        private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void fileToolStripMenuItem_Click(object sender, EventArgs e)
        {

        }

        private void exitToolStripMenuItem_Click(object sender, EventArgs e)
        {
            DialogResult dr=MessageBox.Show("Do you want to exit?","Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (dr == System.Windows.Forms.DialogResult.Yes)
            {
                MessageBox.Show("Are you sure?");
                Application.Exit();
            }

        }

        private void getQuery()
        {
           //1. Connect to DB
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = sConnString;
            conn.Open();

           //2. SQL Query
            string query="select nv.manv,honv+' '+tenlot+' '+tennv,luong from nhanvien nv"

           //3. Execute Query
           //

            //SqlCommand command=new SqlCommand();
            //command.Connection=conn;
            //command.CommandText=query;
            //command.CommandType= CommandType.Text;
            //command.ExecuteNonQuery();
            DataSet results=new DataSet();
            SqlDataAdapter dataAdapt=new SqlDataAdapter(query,conn);
            dataAdapt.Fill(results);


           //4. Data Processing
           //5. Close connection


        }
    }
}