1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
|
Const string DB_CONN_STR = "SERVER=127.0.0.1; DATABASE=test7100; UID=root; PASSWORD=";
MySqlConnection cn = new MySqlConnection(DB_CONN_STR);
DataSet ds = new DataSet();
DataTable dt = new DataTable();
string sqlCmd = "SELECT `PR4`, `DHT`, `DHR` FROM `table 4` WHERE 1";
// PR4= lieux/ville et DHT= heure sous format string
MySqlDataAdapter adr = new MySqlDataAdapter(sqlCmd, cn);
adr.SelectCommand.CommandType = CommandType.Text;
adr.Fill(dt);
string[] x = new string[dt.Rows.Count];
string[] y = new string[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
y[i] = dt.Rows[i][0].ToString();
x[i] = dt.Rows[i][1].ToString();
}
// grapheSillon.Series[0].YValueType = System.Windows.Forms.DataVisualization.Charting.ChartValueType.String;
for (int i = 0; i < dt.Rows.Count; i++)
{
// grapheSillon.Series[0].YValueMembers = y[i];
// grapheSillon.Series[0].XValueMember = x[i];
grapheSillon.Series[0].Points.AddXY(x[i], y[i]);
} |
Partager