public void displayChart() { //bind data with chart DataTable dt1 = new DataTable(); dt1.Columns.Add("Status"); dt1.Columns.Add("Days"); int pending = 0; int scheduled = 0; int consumed = 0; int remained = 0; for (int i = 0; i < GridView1.Rows.Count; i++) { pending = pending + Convert.ToInt32(GridView1.Rows[i].Cells[2].Text); scheduled = scheduled + Convert.ToInt32(GridView1.Rows[i].Cells[3].Text); consumed = consumed + Convert.ToInt32(GridView1.Rows[i].Cells[4].Text); remained = remained + Convert.ToInt32(GridView1.Rows[i].Cells[5].Text); } List <string> status = new List <string>(); status.Add("Pending Leave"); status.Add("Scheduled Leave"); status.Add("Consumed Leave"); status.Add("Remained Leave"); List <int> days = new List <int>(); days.Add(pending); days.Add(scheduled); days.Add(consumed); days.Add(remained); for (int i = 0; i < 4; i++) { DataRow row = dt1.NewRow(); row["Status"] = status[i]; row["Days"] = days[i]; dt1.Rows.Add(row); } Chart2.DataSource = dt1; Chart2.DataBind(); }
private void LoadChart2() { try { //get data from SQL var tb = from data in _db.tblJobs select new { col1 = data.Month, col2 = data.AspNet, col3 = data.PHP }; //Set chart data source Chart2.DataSource = tb; //Set series members names for the X and Y values Chart2.Series["aspnet"].XValueMember = "col1"; Chart2.Series["aspnet"].YValueMembers = "col2"; Chart2.Series["php"].XValueMember = "col1"; Chart2.Series["php"].YValueMembers = "col3"; //Data bind to the selected data source Chart2.DataBind(); //name x,y Chart2.ChartAreas["ChartArea2"].AxisX.Title = "Tháng"; Chart2.ChartAreas["ChartArea2"].AxisY.Title = "Số lượng tuyển dụng"; } catch (Exception ms) { Response.Write(ms.Message); } }
void ShowChart2() { var data = new ArrayList(); data.Add(new { Product = "衬衫", Sale = 5, Inc = 20 }); data.Add(new { Product = "羊毛衫", Sale = 50, Inc = 60 }); data.Add(new { Product = "裤子", Sale = 15, Inc = 80 }); data.Add(new { Product = "高跟鞋", Sale = 25, Inc = 120 }); data.Add(new { Product = "袜子", Sale = 20, Inc = 300 }); var series = new List <Serie>(); series.Add(new Serie { Name = "销量", DataField = "Sale", Type = SerieType.Bar }); series.Add(new Serie { Name = "增速", DataField = "Inc", Type = SerieType.Line }); var yAxis = new List <YAxis>(); yAxis.Add(new YAxis() { Name = "销量" }); yAxis.Add(new YAxis() { Name = "增速" }); Chart2.Show(data, "Product", series, "销售情况", yAxis); }
private void setGrph(DataTable idtSet) { DundasCharts.DundasChartBase(Chart1, ChartImageType.Flash, 300, 290 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); DundasCharts.DundasChartBase(Chart2, ChartImageType.Flash, 500, 290 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); Series series1 = DundasCharts.CreateSeries(Chart1, "Series1", "Default", "매출비중", null, SeriesChartType.Pie, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series series2 = DundasCharts.CreateSeries(Chart2, "Series2", "Default", "계획", null, SeriesChartType.Column, 1, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); series1.FontColor = Color.White; Chart1.DataSource = idtSet.DefaultView; Chart1.Series[series1.Name].ValueMemberX = "COL_RNAME"; Chart1.Series[series1.Name].ValueMembersY = "COL_RATE"; Chart1.DataBind(); Chart2.DataSource = idtSet.DefaultView; Chart2.Series[series2.Name].ValueMemberX = "COL_CNAME"; Chart2.Series[series2.Name].ValueMembersY = "COL_COUNT"; Chart2.DataBind(); }
private void ImageToPdf(Document myDocument, out System.IO.MemoryStream stream, out iTextSharp.text.Image gif, int chart) { stream = new System.IO.MemoryStream(); switch (chart) { case 1: Chart1.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg); break; case 2: Chart2.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg); break; case 3: Chart3.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg); break; case 4: Chart4.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg); break; case 5: Chart5.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg); break; } Chart1.SaveImage(stream, System.Drawing.Imaging.ImageFormat.Jpeg); gif = iTextSharp.text.Image.GetInstance(stream.ToArray()); gif.Alignment = Element.ALIGN_CENTER; //gif.ScaleAbsolute(10, 10); }
protected void CargaChart() { Chart.DataSource = null; Chart.DataBind(); Chart2.DataSource = null; Chart2.DataBind(); DataTable Dt = new DataTable(); Dt.Columns.Add("Lenguaje"); Dt.Columns.Add("Porcentaje"); foreach (var item in list) { Dt.Rows.Add(item.Nombre, item.Valor); } Chart.DataSource = Dt; Chart.Series["Series1"].XValueMember = "Lenguaje"; Chart.Series["Series1"].YValueMembers = "Porcentaje"; Chart.DataBind(); Chart2.DataSource = Dt; Chart2.Series["Series1"].XValueMember = "Lenguaje"; Chart2.Series["Series1"].YValueMembers = "Porcentaje"; Chart2.DataBind(); }
protected override void Dispose(bool disposing) { Chart.Dispose(); Chart2.Dispose(); Chart3.Dispose(); LogarithmicChart.Dispose(); base.Dispose(disposing); }
public void View3_bind() { if (!DropDownList3.SelectedValue.Equals("-1") && !DropDownList4.SelectedValue.Equals("-1") && !DropDownList5.SelectedValue.Equals("-1")) { Label6.Text = string.Format(DropDownList4.SelectedItem.Text.ToString() + ": " + DropDownList4.SelectedValue.ToString()); GridView2.DataBind(); Chart2.DataBind(); } }
public void InitializeChart() { try { ds = obj.LoadMovieList("2", movieName); Chart1.DataSource = ds.Tables[0]; Chart1.Series["pieChart"].XValueMember = "polarity"; Chart1.Series["pieChart"].YValueMembers = "count"; Chart1.DataBind(); Chart2.DataSource = ds.Tables[0]; Chart2.Series["barChart"].XValueMember = "polarity"; Chart2.Series["barChart"].YValueMembers = "count"; //Chart3.ChartAreas["ChartArea1"].AxisX. Chart2.DataBind(); colorChart(Chart1, "pieChart"); colorChart(Chart2, "barChart"); SqlDataReader dr = obj.DataForHistogram(movieName, "pos"); Chart3.Series["Series1"].Points.DataBind(dr, "timeField", "polCount", "Label="); dr = obj.DataForHistogram(movieName, "neg"); Chart3.Series["Series2"].Points.DataBind(dr, "timeField", "polCount", "Label="); dr = obj.DataForHistogram(movieName, "neu"); Chart3.Series["Series3"].Points.DataBind(dr, "timeField", "polCount", "Label="); //dr = obj.DataForHistogram(movieName, "irr"); //Chart3.Series["Series4"].Points.DataBind(dr, "timeField", "polCount", "Label="); colorChart(Chart3, "Series1"); colorChart(Chart3, "Series2"); colorChart(Chart3, "Series3"); Chart3.Series["Series1"]["PointWidth"] = "0.3"; Chart3.Series["Series2"]["PointWidth"] = "0.3"; Chart3.Series["Series3"]["PointWidth"] = "0.3"; Chart3.ChartAreas["ChartArea1"].AxisX.IsMarginVisible = true; Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = true; } catch (Exception e) { } }
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e) { cd2 = new SqlCommand("getModuleFromProject", con); cd2.CommandType = CommandType.StoredProcedure; cd2.Parameters.AddWithValue("@ProjectID", DropDownList3.SelectedItem.Value); da2 = new SqlDataAdapter(cd2); dt2 = new DataTable(); da2.Fill(dt2); DataTable mydt = new DataTable(); mydt.Columns.Add("modulname", typeof(System.String)); mydt.Columns.Add("prg", typeof(System.Int16)); foreach (DataRow item in dt2.Rows) { DataRow dr = mydt.NewRow(); dr[0] = item[0].ToString(); cd = new SqlCommand("getmoduleprogress", con); cd.Parameters.AddWithValue("@mid", Convert.ToInt16(item[1])); cd.CommandType = CommandType.StoredProcedure; da = new SqlDataAdapter(cd); DataTable newdt = new DataTable(); da.Fill(newdt); foreach (DataRow item1 in newdt.Rows) { dr[1] = Convert.ToInt16(item1[0]); } mydt.Rows.Add(dr); Chart2.DataSource = mydt; Chart2.DataBind(); } bindchart(); cd = new SqlCommand("counttask", con); cd.Parameters.AddWithValue("@mid", DropDownList2.SelectedItem.Value); cd.CommandType = CommandType.StoredProcedure; da = new SqlDataAdapter(cd); dt = new DataTable(); da.Fill(dt); Chart1.DataSource = dt; Chart1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable fd = cs.select("select distinct a.Appname, avg(rating) as rating from Rating d join AddApp a on d.apid=a.apid where d.status !='fraud' group by a.Appname"); Chart2.DataSource = fd; Chart2.Series[0].ChartType = SeriesChartType.RangeColumn; //Chart2.Legends[0].Enabled = true; Chart2.Series[0].XValueMember = "Appname"; Chart2.Series[0].YValueMembers = "rating"; Chart2.DataBind(); } }
void initChart2() { SqlDataReader rdr = c.DiagnosisPerCity(Convert.ToInt32(DropDownList1.SelectedItem.Text), DropDownList2.SelectedItem.Text); if (rdr != null) { Chart2.Visible = true; Label2.Text = ""; Chart2.DataBindTable(rdr, "illness"); } else { Label2.Text = "There is No Enough Data "; Chart2.Visible = false; } }
void initChart2() { SqlDataReader rdr = c.Get_Surgeries(DropDownList3.SelectedItem.Text); if (rdr != null) { Chart2.Visible = true; Label2.Text = ""; Chart2.DataBindTable(rdr, "Type"); } else { Label2.Text = "There is No Enough Data "; Chart2.Visible = false; } }
private void loadChart2() { //chart 2 //This is for pitch type string sqlQuery2 = (@"SELECT * FROM ( SELECT[pitchno], [pitcher], [pitchtype] FROM[dbo].[pitchData] --ORDER BY pitcher ASC ) AS SourceTable PIVOT(COUNT([pitchno]) FOR[pitchtype] IN([Splitter], [Fastball], [Sinker], [ChangeUp], [Cutter], [Curveball], [Slider])) AS PivotTable ORDER BY pitcher ASC;" ); DataTable ChartData2 = SqlQueryExecute(sqlQuery2); DataView dv = new DataView(ChartData2); Chart2.DataSource = dv; Chart2.DataBind(); foreach (Series cs in Chart2.Series) { cs.Enabled = false; Debug.WriteLine(cs.Name); cs.ChartType = SeriesChartType.StackedColumn; foreach (DataPoint point in cs.Points) { if ((double)point.YValues.GetValue(0) != 0) { Debug.WriteLine("not empty"); cs.Enabled = true; } } } //Setting width of line Chart2.Series[0].BorderWidth = 10; }
private void LoadChartData4() { Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false; Chart2.ChartAreas[0].AxisY.MajorGrid.Enabled = false; string query = "SELECT comment_type,Ccount from tbl_cat_wise_comment "; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable table = new DataTable(); da.Fill(table); DataView dv = table.DefaultView; Chart2.DataBind(); Chart2.Series["Series1"].Points.DataBindXY(dv, "comment_type", dv, "Ccount"); getdata1(); }
private void LoadChartData2() { Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false; Chart2.ChartAreas[0].AxisY.MajorGrid.Enabled = false; string query = "SELECT Category,catcount from tbl_city_wise_graph "; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable table = new DataTable(); da.Fill(table); DataView dv = table.DefaultView; Chart2.DataBind(); Chart2.Series["Series1"].Points.DataBindXY(dv, "Category", dv, "catcount"); getdata(); }
protected void Page_Load(object sender, EventArgs e) { //userID = Convert.ToInt32(Request.Cookies.Get(0).Value); //userID = 1012;//kc testing userID = Convert.ToInt32(Request.QueryString["userID"]); int count = Request.Cookies.Count; fifthInjury.Text = "test" + userID + "-" + count; Chart.Series["Series1"].YValueMembers = "# of Activities"; Chart.Series["Series1"].XValueMember = "# of Weeks"; Chart1.Series["Series1"].YValueMembers = "# of Activities"; Chart1.Series["Series1"].XValueMember = "# of Weeks"; Chart2.Series["Series1"].YValueMembers = "# of Activities"; Chart2.Series["Series1"].XValueMember = "# of Weeks"; Chart3.Series["Series1"].YValueMembers = "# of Activities"; Chart3.Series["Series1"].XValueMember = "# of Weeks"; try { Chart.DataSource = dbObject.GetActivityData(userID, 1, "strength"); Chart1.DataSource = dbObject.GetActivityData(userID, 1, "cardio"); Chart2.DataSource = dbObject.GetActivityData(userID, 1, "health"); Chart3.DataSource = dbObject.GetActivityData(userID, 1, "sleep"); } catch (NullReferenceException ex) { System.Diagnostics.Debug.WriteLine(ex.Message); Response.Redirect("Login.aspx"); } Chart.DataBind(); Chart1.DataBind(); Chart2.DataBind(); Chart3.DataBind(); showInjuries(); showWorkout(); foreach (string name in HealthInputSessionVariables.Activity.Keys) { foreach (float value in HealthInputSessionVariables.Activity.Values) { Label myLabel = new Label(); myLabel.ID = "lbl" + name; myLabel.Text = value.ToString(); } } }
private void LoadChartData2() { Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false; Chart2.ChartAreas[0].AxisY.MajorGrid.Enabled = false; string query = "SELECT City_nm,Count from tbl_stat_datewise_cnt"; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable table = new DataTable(); da.Fill(table); DataView dv = table.DefaultView; Chart2.DataBind(); Chart2.Series["Series1"].Points.DataBindXY(dv, "City_nm", dv, "Count"); gv_data.DataMember = "tbl_stat_datewise_cnt"; gv_data.DataSource = table; gv_data.DataBind(); }
private void LoadChartData2() { Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false; Chart2.ChartAreas[0].AxisY.MajorGrid.Enabled = false; string query = "SELECT City_nm,Count from tbl_stat_datewise_cnt"; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable table = new DataTable(); da.Fill(table); DataView dv = table.DefaultView; Chart2.DataBind(); //s Chart2.Series["Series1"]["PieLabelStyle"] = "Outside"; Chart2.Series["Series1"].Points.DataBindXY(dv, "City_nm", dv, "Count"); getdata3(); }
private void FillData_BarChart() { DataTable dt = CM_Main.GetData("COLUMNCHART1"); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { Chart2.DataSource = dt; Chart2.Series["Series1"].XValueMember = "FULL_NAME"; Chart2.Series["Series1"].YValueMembers = "NUMBEROFJOBS"; Chart2.DataBind(); Chart2.Series["Series1"].ChartType = SeriesChartType.Column; // Chart2.Series["Series1"]["DrawingStyle"] = "Emboss"; // Chart2.ChartAreas["ChartArea2"].Area3DStyle.Enable3D = true; // Chart2.ChartAreas["ChartArea2"].AxisX.Interval = 1; // Chart2.Series["Series1"].Points[i].Color = Color.FromArgb(48, 54, 65); Chart2.ChartAreas["ChartArea2"].AxisX.MajorGrid.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisY.MajorGrid.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisX.LineWidth = 0; Chart2.ChartAreas["ChartArea2"].AxisY.LineWidth = 0; Chart2.ChartAreas["ChartArea2"].AxisX.LabelStyle.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisY.LabelStyle.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisY.MajorTickMark.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisY.MinorTickMark.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisX.MajorTickMark.Enabled = false; Chart2.ChartAreas["ChartArea2"].AxisX.MinorTickMark.Enabled = false; Chart2.Series["Series1"].IsValueShownAsLabel = false; } Chart2.Series["Series1"].ToolTip = "#VALX : #VALY";//new } }
protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { switch (DropDownList1.SelectedIndex) { case 0: Chart2.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Bar; break; case 1: Chart2.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Pie; break; case 2: Chart2.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Area; break; default: Chart2.Series[0].ChartType = System.Web.UI.DataVisualization.Charting.SeriesChartType.Column; break; } switch (DropDownList2.SelectedIndex) { case 0: SqlDataSource2.SelectCommand = $"SELECT [ZipCode], count([id]) as count FROM [Donation] WHERE Veg = 'True' GROUP BY [ZipCode]"; break; case 1: SqlDataSource2.SelectCommand = $"SELECT [ZipCode], count([id]) as count FROM [Donation] WHERE Cooked = 'True' GROUP BY [ZipCode]"; break; case 2: SqlDataSource2.SelectCommand = $"SELECT [ZipCode], sum([Weight]) as count FROM [Donation] GROUP BY [ZipCode]"; break; case 3: SqlDataSource2.SelectCommand = $"SELECT [ZipCode], count([id]) as count FROM [Donation] WHERE Price IS NOT NULL GROUP BY [ZipCode]"; break; default: break; } Chart2.DataBind(); }
protected void medchart_SelectedIndexChanged(object sender, EventArgs e) { //SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["medDb"].ConnectionString); //con.Open(); //SqlCommand command = new SqlCommand("Select Sales.Purchase_Date, SUM() from MedicineMaster", con); //SqlDataReader reader = command.ExecuteReader(); if (medchart.SelectedValue != "Month" && medchart.SelectedValue != "Select") { SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["medDb"].ConnectionString); con.Open(); SqlCommand command = new SqlCommand("Select Sales.Purchase_Date,SUM(SalesInfo.Quantity) as whatis from Sales,SalesInfo where SalesInfo.Sales_ID = Sales.Sales_ID AND SalesInfo.Med_ID=@id and Sales.Purchase_Date > @temp group by Sales.Purchase_Date ", con); command.Parameters.AddWithValue("@temp", DateTime.Now.AddDays(-30)); command.Parameters.AddWithValue("@id", medchart.SelectedValue); SqlDataReader reader = command.ExecuteReader(); if(!reader.Read()) { er.Text = "No Value Found For the MedID"; } reader.Close(); SqlDataReader reader2 = command.ExecuteReader(); Chart2.DataSource = reader2; Chart2.Series["Series1"].XValueMember = "Purchase_Date"; Chart2.Series["Series1"].YValueMembers = "whatis"; Chart2.ChartAreas[0].AxisX.LabelStyle.Format = "MM-dd"; Chart2.DataBind(); reader2.Close(); } else if(medchart.SelectedValue != "Select") { SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["medDb"].ConnectionString); con.Open(); SqlCommand command = new SqlCommand("Select Sales.Purchase_Date,SUM(SalesInfo.Quantity) as whatis from Sales,SalesInfo where SalesInfo.Sales_ID = Sales.Sales_ID and Sales.Purchase_Date > @temp group by Sales.Purchase_Date ", con); command.Parameters.AddWithValue("@temp", DateTime.Now.AddDays(-30)); SqlDataReader reader = command.ExecuteReader(); Chart2.DataSource = reader; Chart2.Series["Series1"].XValueMember = "Purchase_Date"; Chart2.Series["Series1"].YValueMembers = "whatis"; Chart2.ChartAreas[0].AxisX.LabelStyle.Format = "MM-dd"; Chart2.DataBind(); reader.Close(); } }
public void DataBindChart2() { if (job2Result != null && job2Result.Count > 0) { Dictionary <string, float> selected = new Dictionary <string, float>(); job2Result.Where(t => t.Key.Split('-')[0].Equals(DropDownList1.SelectedValue)) .OrderBy(t => t.Value) .ToList() .ForEach(t => { selected.Add(t.Key.Split('-')[1], t.Value); }); Chart2.DataSource = selected; Chart2.Series["Series1"].XValueMember = "Key"; Chart2.Series["Series1"].YValueMembers = "Value"; Chart2.DataBind(); } }
private void _setGraphFual(DataSet iDsSet) { DundasCharts.DundasChartBase(Chart2, ChartImageType.Flash, 300, 300 , BorderSkinStyle.None, Color.FromArgb(181, 64, 1), 0 , Color.FromArgb(247, 243, 247) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , Dundas.Charting.WebControl.ChartHatchStyle.None, Dundas.Charting.WebControl.GradientType.None, Dundas.Charting.WebControl.AntiAliasing.Graphics); Series series1 = DundasCharts.CreateSeries(Chart2, "Series1", "Default", "", null, SeriesChartType.Funnel, 0, Color.FromArgb(0x5A, 0x7D, 0xDE), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Chart2.Series["Series1"].Type = SeriesChartType.Funnel; // Set funnel Y values style Chart2.Series["Series1"]["FunnelStyle"] = "YIsHeight"; // Set funnel data point labels style Chart2.Series["Series1"]["FunnelLabelStyle"] = "Outside"; // Place labels on the left side Chart2.Series["Series1"]["FunnelOutsideLabelPlacement"] = "Left"; // Set gap between points Chart2.Series["Series1"]["FunnelPointGap"] = "2"; // Set minimum point height Chart2.Series["Series1"]["FunnelMinPointHeight"] = "1"; // Set 3D mode Chart2.ChartAreas["Default"].Area3DStyle.Enable3D = true; // Set 3D angle Chart2.Series["Series1"]["Funnel3DRotationAngle"] = "7"; // Set 3D drawing style Chart2.Series["Series1"]["Funnel3DDrawingStyle"] = "CircularBase"; Chart2.DataSource = iDsSet; Chart2.Series[series1.Name].ValueMembersY = "PRICE"; Chart2.Series[series1.Name].ValueMemberX = "CODE"; Chart2.DataBind(); }
private void getRevenueChart() { using (SqlConnection conn = new SqlConnection(connStr)) { SqlCommand cmd2 = new SqlCommand ("SELECT SUM(Payment.TotalPayed) AS Revenue, MONTH(Payment.DateOfPurchase) AS Monthly FROM Payment Group BY MONTH(Payment.DateOfPurchase)", conn); conn.Open(); SqlDataReader rdr2 = cmd2.ExecuteReader(); // Specify the column name that contains values for X-Axis Chart2.Series["Series2"].XValueMember = "Monthly"; // Specify the column name that contains values for Y-Axis Chart2.Series["Series2"].YValueMembers = "Revenue"; // Set the datasource Chart2.DataSource = rdr2; // Finally call DataBind() Chart2.DataBind(); } }
private void LoadChartData() { Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false; Chart2.ChartAreas[0].AxisY.MajorGrid.Enabled = false; string query = "SELECT * from tbl_cat_comp_graph "; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable table = new DataTable(); da.Fill(table); DataView dv = table.DefaultView; Chart2.DataBind(); Chart2.Series["Sony"].Points.DataBindXY(dv, "Ddate", dv, "cat1"); Chart2.Series["Canon"].Points.DataBindXY(dv, "Ddate", dv, "cat2"); Chart2.Series["Nikon"].Points.DataBindXY(dv, "Ddate", dv, "cat3"); getdata(); }
private void LoadChartData2() { string from = ddl_frommonth.Text + "/" + ddl_fromdate.Text + "/" + ddl_fromyear.Text; string to = ddl_tomonth.Text + "/" + ddl_todate.Text + "/" + ddl_toyear.Text; Chart2.ChartAreas[0].AxisX.MajorGrid.Enabled = false; Chart2.ChartAreas[0].AxisY.MajorGrid.Enabled = false; string query = "SELECT Ddate,Vcount from tbl_show_all_graph where Ddate between '" + from + "' AND '" + to + "'"; SqlDataAdapter da = new SqlDataAdapter(query, con); DataTable table = new DataTable(); da.Fill(table); DataView dv = table.DefaultView; Chart2.DataBind(); Chart2.Series["Series1"].Points.DataBindXY(dv, "Ddate", dv, "VCount"); getdata(); }
protected void Page_Load(object sender, EventArgs e) { DataTable dt1 = CreateDataTable("旷课", ""); Chart1.DataSource = dt1; Chart1.Series[0].YValueMembers = "number"; Chart1.Series[0].XValueMember = "department"; Chart1.DataBind(); DataTable dt2 = CreateDataTable("迟到", ""); Chart2.DataSource = dt2; Chart2.Series[0].YValueMembers = "number"; Chart2.Series[0].XValueMember = "department"; Chart2.DataBind(); }
public void loadchart2() { try { SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder(); builder.ConnectionString = ConfigurationManager.AppSettings["connsr"]; using (SqlConnection connection = new SqlConnection(builder.ConnectionString)) { connection.Open(); StringBuilder sb = new StringBuilder(); //sb.Append("SELECT TOP 1 label, confidence, ConnectionDeviceGenerationId, EnqueuedTime, inserttime FROM visionkitinputs order by EnqueuedTime desc"); sb.Append("select max(EnqueuedTime) as EnqueuedTime, Avg(confidence) as confidence "); sb.Append("from visionkitinputs "); sb.Append("where EnqueuedTime between dateadd(dd,-1,getUTCdate()) and getUTCdate() "); sb.Append("group by DATEPART(hour, EnqueuedTime) "); sb.Append("order by EnqueuedTime desc"); String sql = sb.ToString(); using (SqlCommand command = new SqlCommand(sql, connection)) { using (SqlDataReader reader = command.ExecuteReader()) { Chart2.DataSource = reader; Chart2.Series[0].YValueMembers = "confidence"; Chart2.Series[0].XValueMember = "EnqueuedTime"; Chart2.DataBind(); } } } } catch (Exception ex) { errortxt.Text = "Error: " + ex.Message.ToString() + System.Environment.NewLine; errortxt.Text += "Error: " + ex.StackTrace.ToString() + System.Environment.NewLine; //throw ex; } }
protected void Button1_Click(object sender, EventArgs e) { Chart1.DataSource = sv.DemLuot(int.Parse(DropDownList1.SelectedValue)); Chart1.Legends.Add("average_marks").Title = "Biểu đồ lượt thuê xe"; Chart1.ChartAreas["ChartArea1"].AxisY.Title = " Số Lượt Thuê"; Chart1.ChartAreas["ChartArea1"].AxisX.Title = "Xe"; Chart1.Series["SoLuot"].XValueMember = "Xe"; Chart1.Series["SoLuot"].YValueMembers = "SoLuot"; Chart1.DataBind(); Chart2.DataSource = sv.ThongKeTienTam(int.Parse(DropDownList1.SelectedValue)); Chart2.Legends.Add("average_marks").Title = "Biểu đồ doanh thu xe"; Chart2.ChartAreas["ChartArea1"].AxisY.Title = "Tiền doanh thu"; Chart2.ChartAreas["ChartArea1"].AxisX.Title = "Xe"; Chart2.Series["VND"].XValueMember = "BangSo"; Chart2.Series["VND"].YValueMembers = "ThanhTien"; Chart2.DataBind(); Literal1.Text = "Doanh Thu trong tháng : " + sv.ThongKeTienThang(int.Parse(DropDownList1.SelectedValue)) + " VND";; }