using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Drawing.Imaging;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApp1
{
    public partial class Form5 : Form
    {

        public static string strProvider = "server=localhost;Database=testDB;User IF=root;Password=";
        public Form5()
        {
            InitializeComponent();
        }

        private void label1_Click(object sender, EventArgs e)
        {

        }

        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                if(textBox1.Text =="" || textBox2.Text =="")
                {
                    MessageBox.Show("Null Data");
                } else
                {
                    string strProvider = "server=localhost;Database=testDB;User ID=root;Password=";
                    string Query = "INSERT INTO majorTbl(majorID,majorName) VALUE(" + textBox1.Text + "," + textBox2.Text + ")";
                    MySqlConnection MyConn2 = new MySqlConnection(strProvider);
                    MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);

                    MySqlDataReader MyReader2;
                    MyConn2.Open();
                    MyReader2 = MyCommand2.ExecuteReader();
                    MessageBox.Show("Save Data");
                    MyConn2.Close();
                    showdata();
                }

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

        }

        private void showdata()
        {

            try
            {
                string strProvider = "server=localhost;Database=testDB;User ID=root;Password=";
                string Query = "SELECT * FROM majorTbl";
                MySqlConnection MyConn2 = new MySqlConnection(strProvider);
                MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2);
                MySqlDataAdapter MyAdapter = new MySqlDataAdapter();
                MyAdapter.SelectCommand = MyCommand2;
                DataTable dTable = new DataTable();
                MyAdapter.Fill(dTable);
                dataGridView1.DataSource = dTable;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void Form5_Load(object sender, EventArgs e)
        {
            showdata();
        }
    }


}