[C#/Mysql] 데이터 연결하기

oracle과 연동하는 코드↓

https://j-passionote.tistory.com/12

[C#/Oracle] 데이터 삽입하기

 

 

 

-emp_info 테이블의 데이터를 datagridview 표에 띄우는 부분

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 MySql.Data.MySqlClient;


namespace TestForm
{
    public partial class Man_Page : Form
    {

        public string strConn = "Server=192.168.0.31;" +
                                 "Database=test;" +
                                 "Uid=유저아이디;" +
                                 "Pwd=비밀번호;" +
                                 "charset=utf8;";


        public MySqlConnection conn;
        public MySqlCommand cmd;
        public MySqlDataReader rdr;


        private void Man_Page_Load(object sender, EventArgs e)
        {
            conn = new MySqlConnection(strConn);
            cmd = new MySqlCommand();
            conn.Open();
            cmd.Connection = conn;


            cmd.CommandText = ("select * from emp_info order by emp_id");
            rdr = cmd.ExecuteReader();
            StringBuilder sb = new StringBuilder();


            

            while (rdr.Read())
            {
                string Emp_id = rdr["emp_id"] as string;

                string Emp_name = rdr["emp_name"] as string;

                string Emp_email = rdr["emp_email"] as string;

                string Emp_tel = rdr["emp_tel"] as string;

                string Emp_addr = rdr["emp_addr"] as string;

                string Emp_emer_tel = rdr["emp_emer_tel"] as string;

                string Blood_type = rdr["blood_type"] as string;

                string dept_id = rdr["dept_id"] as string;


                string[] emp_info = new string[] { Emp_id, Emp_name, Emp_email, Emp_tel, Emp_addr, Emp_emer_tel, Blood_type, dept_id };

                dataGridView1.Rows.Add(emp_info);


            }

        }
 

            conn.Close();
        }

    }
}