private void button2_Click(object sender, EventArgs e) { using (SqlConnection con = new SqlConnection(conn)) { con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = "Select * from dbo.RouteTable"; var re = cmd.ExecuteReader(); while (re.Read()) { Highway highway = new Highway() { UnitCode = re["unitCode"].ToString(), UnitName = re["unitName"].ToString(), RouteNo = re["routeNo"].ToString(), RouteName = re["routeName"].ToString(), XValue = re["xValue"].ToString(), YValue = re["yValue"].ToString() }; highways.Add(highway); } this.dataGridView1.DataSource = highways; con.Close(); } }
private void button1_Click(object sender, EventArgs e) { highways.Clear(); string key = "xHuTDf0%2FQp0HDzRAEV4eJFw%2F8hAJu7mZ8oFyqowX7jn6I56Au1cimmwHtweVDfYznMmcv6cXg%2BnXwmnOtHQ%2FOw%3D%3D"; // 인증키 //"http://data.ex.co.kr/exopenapi/locationinfo/locationinfoRest?serviceKey="+key+"&type=json&numOfRows="+ numOfRow + "&pageNo="+ pageNo var serVal = "http://data.ex.co.kr/exopenapi/locationinfo/locationinfoRest?serviceKey=" + key + "&type=json&numOfRows=" + numOfRow + "&pageNo=" + pageNo; RequestResponse(serVal); var jObj = JObject.Parse(RequestResponse(serVal)); if (Int32.Parse(jObj["count"].ToString()) == 0) { button1_Click(null, null); } count = Int32.Parse(jObj["count"].ToString()); //전체 데이터 개수 for (int i = 0; i < Int32.Parse(jObj["pageSize"].ToString()); i++) { var itemsArr = JArray.Parse(jObj["list"].ToString()); foreach (JObject item in itemsArr) { Highway highway = new Highway() { UnitName = item["unitName"].ToString(), UnitCode = item["unitCode"].ToString(), RouteNo = item["routeNo"].ToString(), RouteName = item["routeName"].ToString(), XValue = item["xValue"].ToString(), YValue = item["yValue"].ToString() }; highways.Add(highway); } pageNo++; IDbConnection(highways); highways.Clear(); serVal = "http://data.ex.co.kr/exopenapi/locationinfo/locationinfoRest?serviceKey=" + key + "&type=json&numOfRows=" + numOfRow + "&pageNo=" + pageNo; jObj = JObject.Parse(RequestResponse(serVal)); if (Int32.Parse(jObj["count"].ToString()) == 0) { button1_Click(null, null); } } }