C#

public partial class Form1 : Form
    {
        private static int clickCount = 0;
        //
        private LineItem myCurve;
        //
        public Form1()
        {
            InitializeComponent();
        }

        #region Graph Test

        // Call this method from the Form_Load method, passing your ZedGraphControl instance
        public void CreateChart(ZedGraphControl zgc)
        {

            // Get a reference to the GraphPane
            GraphPane myPane = zgc.GraphPane;

            // Set the titles and axis labels
            myPane.Title.Text = "Demonstration of Multi Y Graph";
            myPane.XAxis.Title.Text = "Time, s";
            myPane.YAxis.Title.Text = "Velocity, m/s";
            myPane.Y2Axis.Title.Text = "Acceleration, m/s2";

            // Make up some data points based on the Sine function
            PointPairList vList = new PointPairList();
            PointPairList aList = new PointPairList();
            PointPairList dList = new PointPairList();
            PointPairList eList = new PointPairList();

            // Fabricate some data values
            for (int i = 0; i < 30; i++)
            {
                double time = (double)i;
                double acceleration = 2.0;
                double velocity = acceleration * time;
                double distance = acceleration * time * time / 2.0;
                double energy = 100.0 * velocity * velocity / 2.0;
                aList.Add(time, acceleration);
                vList.Add(time, velocity);
                eList.Add(time, energy);
                dList.Add(time, distance);
            }
            if (clickCount == 1)
            {
                // Generate a red curve with diamond symbols, and "Velocity" in the legend
                LineItem myCurve = myPane.AddCurve("Velocity",
                   vList, Color.Red, SymbolType.Diamond);
                // Fill the symbols with white
                myCurve.Symbol.Fill = new Fill(Color.White);
                //
                // Make the Y axis scale red
                myPane.YAxis.Scale.FontSpec.FontColor = Color.Red;
                myPane.YAxis.Title.FontSpec.FontColor = Color.Red;
                // turn off the opposite tics so the Y tics don't show up on the Y2 axis
                myPane.YAxis.MajorTic.IsOpposite = false;
                myPane.YAxis.MinorTic.IsOpposite = false;
                // Don't display the Y zero line
                myPane.YAxis.MajorGrid.IsZeroLine = false;
                // Align the Y axis labels so they are flush to the axis
                myPane.YAxis.Scale.Align = AlignP.Inside;
                myPane.YAxis.Scale.Max = 100;
            }
            if (clickCount == 2)
            {
                // Generate a blue curve with circle symbols, and "Acceleration" in the legend
                myCurve = myPane.AddCurve("Acceleration",
                   aList, Color.Blue, SymbolType.Circle);
                // Fill the symbols with white
                myCurve.Symbol.Fill = new Fill(Color.White);
                // Associate this curve with the Y2 axis
                myCurve.IsY2Axis = true;
                //
                // Enable the Y2 axis display
                myPane.Y2Axis.IsVisible = true;
                // Make the Y2 axis scale blue
                myPane.Y2Axis.Scale.FontSpec.FontColor = Color.Blue;
                myPane.Y2Axis.Title.FontSpec.FontColor = Color.Blue;
                // turn off the opposite tics so the Y2 tics don't show up on the Y axis
                myPane.Y2Axis.MajorTic.IsOpposite = false;
                myPane.Y2Axis.MinorTic.IsOpposite = false;
                // Display the Y2 axis grid lines
                myPane.Y2Axis.MajorGrid.IsVisible = true;
                // Align the Y2 axis labels so they are flush to the axis
                myPane.Y2Axis.Scale.Align = AlignP.Inside;
                myPane.Y2Axis.Scale.Min = 1.5;
                myPane.Y2Axis.Scale.Max = 3;
            }
            if (clickCount == 3)
            {
                // Generate a green curve with square symbols, and "Distance" in the legend
                myCurve = myPane.AddCurve("Distance",
                   dList, Color.Green, SymbolType.Square);
                // Fill the symbols with white
                myCurve.Symbol.Fill = new Fill(Color.White);
                // Associate this curve with the second Y axis
                myCurve.YAxisIndex = 1;
                //
                // Create a second Y Axis, green
                YAxis yAxis3 = new YAxis("Distance, m");
                myPane.YAxisList.Add(yAxis3);
                yAxis3.Scale.FontSpec.FontColor = Color.Green;
                yAxis3.Title.FontSpec.FontColor = Color.Green;
                yAxis3.Color = Color.Green;
                // turn off the opposite tics so the Y2 tics don't show up on the Y axis
                yAxis3.MajorTic.IsInside = false;
                yAxis3.MinorTic.IsInside = false;
                yAxis3.MajorTic.IsOpposite = false;
                yAxis3.MinorTic.IsOpposite = false;
                // Align the Y2 axis labels so they are flush to the axis
                yAxis3.Scale.Align = AlignP.Inside;
            }
            if (clickCount == 4)
            {
                // Generate a Black curve with triangle symbols, and "Energy" in the legend
                myCurve = myPane.AddCurve("Energy",
                   eList, Color.Black, SymbolType.Triangle);
                // Fill the symbols with white
                myCurve.Symbol.Fill = new Fill(Color.White);
                // Associate this curve with the Y2 axis
                myCurve.IsY2Axis = true;
                // Associate this curve with the second Y2 axis
                myCurve.YAxisIndex = 1;
                //
                Y2Axis yAxis4 = new Y2Axis("Energy");
                yAxis4.IsVisible = true;
                myPane.Y2AxisList.Add(yAxis4);
                // turn off the opposite tics so the Y2 tics don't show up on the Y axis
                yAxis4.MajorTic.IsInside = false;
                yAxis4.MinorTic.IsInside = false;
                yAxis4.MajorTic.IsOpposite = false;
                yAxis4.MinorTic.IsOpposite = false;
                // Align the Y2 axis labels so they are flush to the axis
                yAxis4.Scale.Align = AlignP.Inside;
                yAxis4.Type = AxisType.Log;
                yAxis4.Scale.Min = 100;
            }
            // Show the x axis grid
            myPane.XAxis.MajorGrid.IsVisible = true;

            // Fill the axis background with a gradient
            myPane.Chart.Fill = new Fill(Color.White, Color.LightGoldenrodYellow, 45.0f);

            zgc.AxisChange();
            zgc.Invalidate();

        }

        #endregion

        private void toolStripButton1_Click(object sender, EventArgs e)
        {

            if (clickCount > 4 || clickCount == 4)
            {
                clickCount = 1;
            }
            else
            {
                clickCount = clickCount + 1;
            }
            CreateChart(zgc);

        }
    }

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Runtime.InteropServices;
using System.Configuration;
using System.Threading;

namespace Cure_Server
{
    public partial class frmMain : DevExpress.XtraEditors.XtraForm
    {
        MySqlConnection sql_connection = null;
        MySqlCommand sql_command = null;
        MySqlDataAdapter sql_adapter;
        DataTable data_table = null;
        MySqlDataReader sql_reader = null;
        DataSet data_set = null;

        public public_class public_var = new public_class();

        const int MF_BYPOSITION = 0x400;

        [DllImport("User32.dll")]
        private static extern int RemoveMenu(IntPtr hMenu, int nPosition, int wFlagS);

        [DllImport("User32.dll")]
        private static extern IntPtr GetSystemMenu(IntPtr hWnd, bool bRevert);

        [DllImport("User32.dll")]
        private static extern int GetMenuItemCount(IntPtr hWnd);

        public int result_rows;

        public frmMain()
        {
            InitializeComponent();
        }

        private void perform()
        {
            get_statistics_summary();
            send_sms();
        }

        private void get_statistics_summary()
        {
            progressRunning.Visible = true;

            try
            {
                // sql_connection = new SqlConnection("Data Source=.\\SQLEXPRESS;initial catalog=shefa;integrated security=true");
                sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
                sql_connection.Open();
                sql_command = new MySqlCommand("SELECT COUNT(*) AS total_files FROM persons", sql_connection);
                sql_command.CommandType = CommandType.Text;
                sql_reader = sql_command.ExecuteReader();

                if (sql_reader.Read())
                {
                    lblTotalFiles.Text = sql_reader["total_files"].ToString();
                }

                sql_reader.Close();

                sql_command = new MySqlCommand("SELECT COUNT(*) AS total_appointments FROM appointments", sql_connection);
                sql_command.CommandType = CommandType.Text;
                sql_reader = sql_command.ExecuteReader();

                if (sql_reader.Read())
                {
                    lblTotalAppointments.Text = sql_reader["total_appointments"].ToString();
                }
            }
            catch (Exception exp)
            {
                return;
            }
            finally
            {
                if (sql_reader != null) sql_reader.Close();
                if (sql_connection != null)
                {
                    if (sql_connection.State == ConnectionState.Open)
                        sql_connection.Close();
                }
            }

            progressRunning.Visible = false;
        }

        private void send_sms()
        {
            progressRunning.Visible = true;

            try
            {
                sql_connection = new MySqlConnection(ConfigurationManager.ConnectionStrings["SQLdb"].ConnectionString);
                sql_connection.Open();
                sql_command = new MySqlCommand("sp_send_pending_sms", sql_connection);
                sql_command.CommandType = CommandType.StoredProcedure;
                sql_reader = sql_command.ExecuteReader();

                while (sql_reader.Read())
                {
                    lblTimer.Text = sql_reader["sms_queue_id"].ToString();
                }
            }
            catch (Exception exp)
            {
                return;
            }
            finally
            {
                if (sql_reader != null) sql_reader.Close();
                if (sql_connection != null)
                {
                    if (sql_connection.State == ConnectionState.Open)
                        sql_connection.Close();
                }
            }

            progressRunning.Visible = false;
        }

        private void frmMain_Load(object sender, EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;

            IntPtr hMenu = GetSystemMenu(this.Handle, false);
            int menuItemCount = GetMenuItemCount(hMenu);
            RemoveMenu(hMenu, menuItemCount - 1, MF_BYPOSITION);

            timerMain.Interval = Convert.ToInt32(ConfigurationManager.AppSettings["ServerTimerInterval"]);

            // public_var.get_system_properties();
        }

        private void btnEmailTemplates_Click(object sender, EventArgs e)
        {
            frmEmailTemplates EmailTemplatesForm = new frmEmailTemplates(public_var);
            EmailTemplatesForm.ShowDialog();
        }

        private void frmMain_Shown(object sender, EventArgs e)
        {
            this.Cursor = Cursors.WaitCursor;

            timerMain.Start();

            this.Cursor = Cursors.Default;
        }

        private void btnConnectonFile_Click(object sender, EventArgs e)
        {

        }

        private void timerMain_Elapsed(object sender, System.Timers.ElapsedEventArgs e)
        {
            // lblTimer.Text = DateTime.Now.ToString();
            backgroundWorkerSMS.RunWorkerAsync();

            // send_sms();
        }

        private void btnOptions_Click(object sender, EventArgs e)
        {
            timerMain.Stop();

            frmOptions OptionsForm = new frmOptions();
            DialogResult options_form = OptionsForm.ShowDialog();

            if (options_form == DialogResult.OK)
            {
                timerMain.Interval = Convert.ToInt32(ConfigurationManager.AppSettings["ServerTimerInterval"]);
            }

            timerMain.Start();
        }

        private void backgroundWorkerSMS_DoWork(object sender, DoWorkEventArgs e)
        {
            timerMain.Stop();

            perform();
        }

        private void backgroundWorkerSMS_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
        {
            backgroundWorkerSMS.Dispose();
            timerMain.Start();
        }
    }
}

cmd = new SqlCommand("sp_Deneme", conn);
            cmd.CommandType = System.Data.CommandType.StoredProcedure;
            conn.Open();
            
            cmd.ExecuteReader();
            dt = new DataTable();
            DataRow row = dt.NewRow();

            for (int i = 0; i < reader.FieldCount; i++)
            {
                dt.Columns.Add(i.ToString(), Type.GetType("System.String"));
                dt.Rows[0][i] = reader[i].ToString();
            }
            label1.Text = dt.Rows[0][1].ToString();
            label2.Text = dt.Rows[0][2].ToString();
            label3.Text = dt.Rows[0][3].ToString();