C#

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();