WindowsForms Application DataGridView

각각 버튼과 데이터그리드를 추가한뒤 버튼 클릭 이벤트에 아래와 같이 추가해줍니다..

            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = "server=xxx.xxx.xxx.xxx;database=DB명;uid=아이디;pwd=패스워드;";
 
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = "SELECT cityCd,cityEnm from tblcity  ";
 
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
  
            da.Fill(ds, "tblcity");  

            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "tblcity";