[C#] MySQL 레코드 불러오기

MySQL과 C# DataGrideView를 연동 예제 소스입니다.

이제 이틀배워서... 소스가 구린데.. 피드백 해주실분~ 리플좀 달아주세요~

아 그리고 컬럼명 신경쓰지마세요 ㅋㅋ 그냥 막 하다보니... 안바꿨네...

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; /* MYSQL */ using MySql.Data; using MySql.Data.MySqlClient; namespace mysql_connec { public partial class Form1 : Form { DataColumn col; DataRow row; DataTable tblPeople; public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { tblPeople = new DataTable("tblPeople"); //열 등록 col = new DataColumn("No", typeof(String)); col.AllowDBNull = false; col.Unique = true; tblPeople.Columns.Add(col); tblPeople.PrimaryKey = new DataColumn[] { col }; col = new DataColumn("Name", typeof(String)); col.AllowDBNull = false; tblPeople.Columns.Add(col); col = new DataColumn("Birth", typeof(String)); col.AllowDBNull = false; tblPeople.Columns.Add(col); tblPeople = MakePeopleTable(); dataGridView1.DataSource = tblPeople; } private void button1_Click(object sender, EventArgs e) { } private DataTable MakePeopleTable() { string connStr = string.Format(@"server=localhost; user=root; password=apmsetup; database=leader"); string query = "select * from teams"; MySqlConnection conn = new MySqlConnection(connStr); MySqlCommand cmd = new MySqlCommand(query); cmd.Connection = conn; conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); try { while (reader.Read()) { //행 삽입 row = tblPeople.NewRow(); row["No"] = reader.GetString(0); row["Name"] = reader.GetString(1); row["Birth"] = reader.GetString(2); tblPeople.Rows.Add(row); } } catch { } conn.Close(); tblPeople.AcceptChanges(); return tblPeople; } } }