[問題] c# 取得sql資料後畫圖
大家好 目前是想從db裡面取完資料來畫趨勢圖
欄位大概是
日期(X軸) 價格(Y軸)
這邊我應該要怎樣處理呢?
日期 價格
2015/07 4100
2015/09 5100
我目前的CODE是長這樣
private void button2_Click(object sender, EventArgs e)
{
string sql_string = "select Post_Day, 價格 From
test_db.dbo.BarCharData";
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=RX-0\SQLEXPRESS;Initial
Catalog=test_db;Integrated Security=True";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(sql_string, con);
DataTable dt = new DataTable();
sda.Fill(dt); //把select出來的東西丟進去 dt
dataGridView1.DataSource = dt;
}
我希望按下按鈕才開始畫圖
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 106.1.129.194
※ 文章網址: https://www.ptt.cc/bbs/C_Sharp/M.1458189393.A.EFD.html
→
03/17 13:55, , 1F
03/17 13:55, 1F
→
03/17 14:58, , 2F
03/17 14:58, 2F
→
03/17 15:05, , 3F
03/17 15:05, 3F
推
03/17 15:50, , 4F
03/17 15:50, 4F
→
03/17 15:51, , 5F
03/17 15:51, 5F
→
03/17 15:51, , 6F
03/17 15:51, 6F
→
03/17 16:24, , 7F
03/17 16:24, 7F
string sql_string = "select Post_Day, 價格 From test_db.dbo.BarCharData";
SqlConnection con = new SqlConnection();
con.ConnectionString = @"Data Source=RX-0\SQLEXPRESS;Initial
Catalog=test_db;Integrated Security=True";
con.Open();
SqlDataAdapter sda = new SqlDataAdapter(sql_string, con);
DataTable dt = new DataTable();
sda.Fill(dt); //把select出來的東西丟進去 dt
chart1.DataSource = dt;
chart1.Series["價格"].XValueMember = "Post_Day";
chart1.Series["價格"].YValueMembers = "價格";
chart1.DataBind();
※ 編輯: MOONY135 (106.1.129.194), 03/17/2016 16:25:17