private string QueryString = "SELECT [Qty], [Hour], [ObjectifTotal] FROM [TRGCharts]"; SqlConnection conn = new SqlConnection(ConnectionString); SqlCommand cmd = new SqlCommand(QueryString, conn); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; DataTable dt = new DataTable(); da.Fill(dt); Chart1.DataSource = dt; Chart1.Series["Series1"].XValueMember = dt.Columns["Hour"].ToString(); Chart1.Series["Series1"].YValueMembers = dt.Columns["Qty"].ToString(); Chart1.Series["Series2"].XValueMember = dt.Columns["Hour"].ToString(); Chart1.Series["Series2"].YValueMembers = dt.Columns["ObjectifTotal"].ToString(); Chart1.DataSource = dt; this.Chart1.Series["Series1"].Points.AddXY(dt.Columns["Hour"].ToString(), dt.Columns["Qty"].ToString()); this.Chart1.DataBind(); this.Chart1.Series["Series2"].Points.AddXY(dt.Columns["Hour"].ToString(), dt.Columns["ObjectifTotal"].ToString()); this.Chart1.DataBind();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)