سلام
می خوام در asp.net نموداری درست کنم که تاریخ رو در محور x و زمان رو که دقیقه و ثانیه هست در محور y داشته باشم
اما نمیشه در ضمن از ابزار asp:Chart و using System.Web.UI.DataVisualization.Charting; استفاده میکنم
لطفا راهنماییم کنید
مشکل کجاست دوست من ؟
int b = 0; DataTable Time = new DataTable(); DataTable Time1 = new DataTable(); DataTable Time2 = new DataTable(); DataTable Time3 = new DataTable(); Time.Columns.Add("Time", typeof(string)); Time.Columns.Add("Date", typeof(string)); Time1.Columns.Add("Time", typeof(string)); Time1.Columns.Add("Date", typeof(string)); Time2.Columns.Add("Time", typeof(string)); Time2.Columns.Add("Date", typeof(string)); Time3.Columns.Add("Time", typeof(string)); Time3.Columns.Add("Date", typeof(string)); for (DateTime i = start; i <= end.Date; i = i.AddDays(1)) { string date = DE(i); DataTable DailyTime = new DataTable(); DataTable DailyTime1 = new DataTable(); DataTable DailyTime2 = new DataTable(); DataTable DailyTime3 = new DataTable(); SqlDataAdapter cod = new SqlDataAdapter("select DailyTime,DateShamsi from [Results] where DateShamsi ='" + date + "' and Site ='nazdiktarinha.ir'", con); SqlDataAdapter cod1 = new SqlDataAdapter("select DailyTime,DateShamsi from [Results] where DateShamsi ='" + date + "' and Site ='viamond.tech'", con); SqlDataAdapter cod2 = new SqlDataAdapter("select DailyTime,DateShamsi from [Results] where DateShamsi ='" + date + "' and Site ='api24.ir'", con); SqlDataAdapter cod3 = new SqlDataAdapter("select DailyTime,DateShamsi from [Results] where DateShamsi ='" + date + "' and Site ='tech-team.ir'", con); con.Open(); cod.Fill(DailyTime); cod1.Fill(DailyTime1); cod2.Fill(DailyTime2); cod3.Fill(DailyTime3); con.Close(); if (DailyTime.Rows.Count == 0) { DailyTime.Rows.Add(); DailyTime.Rows[0][0] = "0:00"; DailyTime.Rows[0][1] = date; } if (DailyTime1.Rows.Count == 0) { DailyTime1.Rows.Add(); DailyTime1.Rows[0][0] = "0:00"; DailyTime1.Rows[0][1] = date; } if (DailyTime2.Rows.Count == 0) { DailyTime2.Rows.Add(); DailyTime2.Rows[0][0] = "0:00"; DailyTime2.Rows[0][1] = date; } if (DailyTime3.Rows.Count == 0) { DailyTime3.Rows.Add(); DailyTime3.Rows[0][0] = "0:00"; DailyTime3.Rows[0][1] = date; } Time.Rows.Add(); Time.Rows[b]["Time"] = DailyTime.Rows[0][0]; Time.Rows[b]["Date"] = DailyTime.Rows[0][1]; Time1.Rows.Add(); Time1.Rows[b]["Time"] = DailyTime1.Rows[0][0]; Time1.Rows[b]["Date"] = DailyTime1.Rows[0][1]; Time2.Rows.Add(); Time2.Rows[b]["Time"] = DailyTime2.Rows[0][0]; Time2.Rows[b]["Date"] = DailyTime2.Rows[0][1]; Time3.Rows.Add(); Time3.Rows[b]["Time"] = DailyTime3.Rows[0][0]; Time3.Rows[b]["Date"] = DailyTime3.Rows[0][1]; b++; } string[] DailyT = new string[Time.Rows.Count]; string[] Dtime = new string[Time.Rows.Count]; Series Daily = new Series(); Daily.Name = "site4"; Daily.Color = ColorN; Daily.BorderWidth = 2; Daily.ChartType = SeriesChartType.Spline; for (int j = 0; j < Time.Rows.Count; j++) { DailyT[j] = Convert.ToString(Time.Rows[j]["Date"]); Dtime[j] = Convert.ToString(Time.Rows[j]["Time"]); Daily.Points.AddXY(DailyT[j], Dtime[j]); } string[] DailyT1 = new string[Time1.Rows.Count]; string[] Dtime1 = new string[Time1.Rows.Count]; Series Daily1 = new Series(); Daily1.Name = "site3"; Daily1.Color = ColorV; Daily1.BorderWidth = 2; Daily1.ChartType = SeriesChartType.Spline; for (int j = 0; j < Time1.Rows.Count; j++) { DailyT1[j] = Convert.ToString(Time1.Rows[j]["Date"]); Dtime1[j] = Convert.ToString(Time1.Rows[j]["Time"]); Daily1.Points.AddXY(DailyT1[j], Dtime1[j]); } string[] DailyT2 = new string[Time2.Rows.Count]; string[] Dtime2 = new string[Time2.Rows.Count]; Series Daily2 = new Series(); Daily2.Name = "site2"; Daily2.Color = ColorA; Daily2.BorderWidth = 2; Daily2.ChartType = SeriesChartType.Spline; for (int j = 0; j < Time2.Rows.Count; j++) { DailyT2[j] = Convert.ToString(Time2.Rows[j]["Date"]); Dtime2[j] = Convert.ToString(Time2.Rows[j]["Time"]); Daily2.Points.AddXY(DailyT2[j],Dtime2[j]); } string[] DailyT3 = new string[Time3.Rows.Count]; string[] Dtime3 = new string[Time3.Rows.Count]; Series Daily3 = new Series(); Daily3.Name = "site1"; Daily3.Color = ColorT; Daily3.BorderWidth = 2; Daily3.ChartType = SeriesChartType.Spline; for (int j = 0; j < Time3.Rows.Count; j++) { DailyT3[j] = Convert.ToString(Time3.Rows[j]["Date"]); Dtime3[j] = Convert.ToString(Time3.Rows[j]["Time"]); Daily3.Points.AddXY(DailyT3[j], Dtime3[j]); } Title DailyTimeTitle = Chart5.Titles.Add("Daily Time on Site"); DailyTimeTitle.Font = new System.Drawing.Font("Arial", 11, FontStyle.Bold); Legend TitelDailyTime = new Legend(); TitelDailyTime.Font = new System.Drawing.Font("B Nazanin", 12); TitelDailyTime.Docking = Docking.Top; if (Daily.Points.Count > 21) { Daily.Points.Add(1); Daily1.Points.Add(1); Daily2.Points.Add(1); Daily3.Points.Add(1); } Chart5.Legends.Add(TitelDailyTime); Chart5.Width = 600; Chart5.Height = 350; Chart5.Series.Add(Daily); Chart5.Series.Add(Daily1); Chart5.Series.Add(Daily2); Chart5.Series.Add(Daily3); Chart5.Visible = true;
این کد های هست که نوشتم متاسفانه خروجی بهم نمیدم یا بهتره بگم کاملا اشتباه میده
متاسفانه اینگونه نمیشه مشکل رو پیدا کرد
این لینک رو ببینید
هیچ کاربری تا کنون از این پست تشکر نکرده است
با ما تماس بگیرید تا در این مسیر همراهتان باشیم :)