# 33) [C#] Winform 3 (VS2017에서 Oracle11g로 데이터 연동)

[insert 예제]

using System;
using System.Data;
using System.Drawing;
using System.Windows.Forms;
using Oracle.ManagedDataAccess;
using Oracle.ManagedDataAccess.Client;

//ProgressBar TrackBar
// TreeView
namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {        
        Random random = new Random(100);
        public Form1()
        {
            InitializeComponent();

            listView1.BeginUpdate();

            listView1.View = View.Details;
            listView1.Columns.Add("이름", 200, HorizontalAlignment.Left); // 컬럼의 크기 200
            listView1.Columns.Add("나이", 200, HorizontalAlignment.Right);
            listView1.Columns.Add("급여", 200, HorizontalAlignment.Center);

            listView1.EndUpdate();
        }
        private string DB_Server_Info = "Data Source=localhost:1521/xe;" +
            "User ID = system;Password = 1234;";
        private void button5_Click(object sender, EventArgs e)
        {
            //연결
            Oracle.ManagedDataAccess.Client.OracleConnection conn = new Oracle.ManagedDataAccess.Client.OracleConnection(DB_Server_Info);
            conn.Open();
            //Console.WriteLine("연결");
            Oracle.ManagedDataAccess.Client.OracleDataAdapter oda = new Oracle.ManagedDataAccess.Client.OracleDataAdapter();
            oda.SelectCommand = new Oracle.ManagedDataAccess.Client.OracleCommand("SELECT name, age, sal FROM tab01", conn);
            DataTable dt1 = new DataTable();
            oda.Fill(dt1);
            conn.Close();
            Console.WriteLine(dt1.Rows.Count);
            foreach (DataRow item in dt1.Rows)
            {
                ListViewItem lv = new ListViewItem();
                lv.Text = item[0].ToString();
                for (int i = 1; i < dt1.Columns.Count; i++)
                {
                    lv.SubItems.Add(item[i].ToString());
                    Console.WriteLine(i);
                }
                listView1.Items.Add(lv);
            }
        }

        private void button6_Click(object sender, EventArgs e)
        {
            // 오라클 접속 객체 생성.
            Oracle.ManagedDataAccess.Client.OracleConnection oracleConnection = new Oracle.ManagedDataAccess.Client.OracleConnection(DB_Server_Info);
            // DB open.
            oracleConnection.Open();
            // 명령 객체 생성.
            Oracle.ManagedDataAccess.Client.OracleCommand cmd = new Oracle.ManagedDataAccess.Client.OracleCommand();
            cmd.Connection = oracleConnection;
            // 추가할 데이터.
            string str = "'김길동', 70, 800";
            // 쿼리문 작성.
            cmd.CommandText = $"INSERT INTO tab01 values({str})";
            cmd.ExecuteNonQuery();
            // DB close.
            oracleConnection.Close();
            // 작업 완료 확인 메시지.
            MessageBox.Show("데이터 삽입 완료.");
        }

        private void button4_Click(object sender, EventArgs e)
        {
            string name = "호랑이" + random.Next();
            listView1.Items.Add(new ListViewItem(
                new string[] {name, "코끼리", "독수리"}
                ));
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // MessageBox.Show("Form1_Load");
            var Fonts = FontFamily.Families;
            foreach(FontFamily item in Fonts)
            {
                comboBox1.Items.Add(item);
            }
        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            //MessageBox.Show("콤보 클릭");
            ChangeFont();
        }

        private void checkBox2_CheckedChanged(object sender, EventArgs e)
        {
            ChangeFont();
        }
        void ChangeFont()
        {
            if (comboBox1.SelectedIndex < 0)
            {
                return;
            }

            // 폰트 스타일의 객체 초기화
            FontStyle style = FontStyle.Regular;
            if(checkBox1.Checked)
            {
                style |= FontStyle.Bold;
            }

            if (checkBox2.Checked)
            {
                style |= FontStyle.Italic;
            }

            textBox1.Font = new Font(
                (FontFamily)comboBox1.SelectedItem, 10, style);
            
        }

        private void button3_Click(object sender, EventArgs e)
        {
            MessageBox.Show("1", "2", MessageBoxButtons.OKCancel);
        }

        private void button1_Click(object sender, EventArgs e)
        {
            Form form = new Form();
            form.Text = "모달 폼";
            form.Width = 300;
            form.Height = 100;
            form.BackColor = Color.Red;
            form.ShowDialog();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            Form form = new Form();
            form.Text = "모달리스 폼";
            form.Width = 300;
            form.Height = 300;
            form.BackColor = Color.Green;
            form.Show();
        }   
    }
}