1-) C# RMOS - Grafik Chart Oluşturma Yeni Pratiik

  private void btnOlustur_Click(object sender, EventArgs e)

        {

            try

            {

                chartControl1.Series.Clear();

                string SQL = "select uTeknikArizalar_anaAlan,count(uTeknikArizalar_anaAlan) as toplam from uTeknikArizalar group by uTeknikArizalar_anaAlan";

                DataTable dt = RHVeritabani.MyGetDataTable(SQL);

                Series series1;

                foreach (DataRow item in dt.Rows)

                {

                    series1 = new Series(item["uTeknikArizalar_anaAlan"].ToString() + " " + item["toplam"].ToString(), ViewType.Bar);

                    ((BarSeriesLabel)series1.Label).Visible = true;

                    series1.Points.Add(new SeriesPoint(item["uTeknikArizalar_anaAlan"].ToString(), item["toplam"].ToString()));

                    chartControl1.Series.Add(series1);

                }

  (chartControl1.Diagram as XYDiagram).AxisY.GridSpacingAuto = false; // Y EKSENİNİ İNT E ÇEVİRİR

 (chartControl1.Diagram as XYDiagram).AxisY.GridSpacing = 1;

 (chartControl1.Diagram as XYDiagram).AxisX.GridSpacingAuto = false; // X EKSENİNİ İNT E ÇEVİRİR

 (chartControl1.Diagram as XYDiagram).AxisX.GridSpacing = 1;

            }

            catch (Exception ex)

            {

                RHMesaj.MyMessageError(MyClass, "btnOlustur_Click", "", ex);

            }

        }

DİĞER

    public void chartOlusturDakika()

        {

            try

            {

                List<GrafikResModel.Datum> data24saat = haremAltinApi.getGrafik24saat("ALTIN");

                chartControl1.Series.Clear();

                string SQL = "select uTeknikArizalar_anaAlan,count(uTeknikArizalar_anaAlan) as toplam from uTeknikArizalar group by uTeknikArizalar_anaAlan";

                Series series1;

                foreach (GrafikResModel.Datum item in data24saat)

                {

                    series1 = new Series("ALTIN", ViewType.Bar);

                    ((BarSeriesLabel)series1.Label).Visible = true;

                    series1.Points.Add(new SeriesPoint("ALTIN", item.satis.ToString()));

                    chartControl1.Series.Add(series1);

                }

  (chartControl1.Diagram as XYDiagram).AxisY.GridSpacingAuto = false; // Y EKSENİNİ İNT E ÇEVİRİR

                (chartControl1.Diagram as XYDiagram).AxisY.GridSpacing = 1;

                (chartControl1.Diagram as XYDiagram).AxisX.GridSpacingAuto = false; // X EKSENİNİ İNT E ÇEVİRİR

                (chartControl1.Diagram as XYDiagram).AxisX.GridSpacing = 1;

            }

            catch (Exception ex)

            {

                MessageBox.Show("HATA " + ex.Message);

            }

        }