public static void SQLCommand(string CommandText, CommandType CT, ExecuteReaderOrNonQuery Ex)
        {
            MyCOnnection.Open();
            MyCommand = new SqlCommand(CommandText, MyCOnnection);


            switch (CT)
            {
            case CommandType.Text:
                MyCommand.CommandType = CommandType.Text;

                switch (Ex)
                {
                case ExecuteReaderOrNonQuery.executeReader:
                    SqlDataReader DataReader = MyCommand.ExecuteReader();
                    MyDataTable = new DataTable();
                    MyDataTable.Load(DataReader);
                    break;

                case ExecuteReaderOrNonQuery.executeNonQuery:
                    MyCommand.Parameters.AddRange(ParameterList.ToArray());
                    MyCommand.ExecuteNonQuery();
                    break;

                case ExecuteReaderOrNonQuery.executeScalar:
                    MyCommand.Parameters.AddRange(ParameterList.ToArray());
                    MyCommand.ExecuteScalar();
                    break;
                }
                MyCommand.Parameters.Clear();
                ParameterList.Clear();
                break;

            case CommandType.StoredProcedure:
            {
                MyCommand.CommandType = CommandType.StoredProcedure;
                switch (Ex)
                {
                case ExecuteReaderOrNonQuery.executeReader:
                    SqlDataReader DataReader = MyCommand.ExecuteReader();
                    MyDataTable = new DataTable();
                    MyDataTable.Load(DataReader);
                    break;

                case ExecuteReaderOrNonQuery.executeNonQuery:
                    MyCommand.Parameters.AddRange(ParameterList.ToArray());
                    MyCommand.ExecuteNonQuery();
                    break;

                case ExecuteReaderOrNonQuery.executeScalar:
                    MyCommand.Parameters.AddRange(ParameterList.ToArray());
                    MyCommand.ExecuteScalar();
                    break;
                }
                MyCommand.Parameters.Clear();
                ParameterList.Clear();
                break;
            }
            }
            MyCOnnection.Close();
        }
        public static void SQLCommandWithoutParameters(string CommandText, CommandType CT, ExecuteReaderOrNonQuery Ex)
        {
            MyCOnnection.Open();
            SqlCommand MyCommand = new SqlCommand(CommandText, MyCOnnection);

            switch (CT)
            {
            case CommandType.Text:
                MyCommand.CommandType = CommandType.Text;

                switch (Ex)
                {
                case ExecuteReaderOrNonQuery.executeReader:
                    SqlDataReader DataReader = MyCommand.ExecuteReader();
                    MyDataTable = new DataTable();
                    MyDataTable.Load(DataReader);
                    break;

                case ExecuteReaderOrNonQuery.executeNonQuery:
                    MyCommand.ExecuteNonQuery();
                    break;

                case ExecuteReaderOrNonQuery.executeScalar:
                    try
                    {
                        scalarReturn = Convert.ToInt32(MyCommand.ExecuteScalar());
                    }
                    catch { scalarReturn = 0; }
                    break;
                }
                break;

            case CommandType.StoredProcedure:
            {
                MyCommand.CommandType = CommandType.StoredProcedure;
                switch (Ex)
                {
                case ExecuteReaderOrNonQuery.executeReader:
                    SqlDataReader DataReader = MyCommand.ExecuteReader();
                    MyDataTable = new DataTable();
                    MyDataTable.Load(DataReader);
                    break;

                case ExecuteReaderOrNonQuery.executeNonQuery:
                    MyCommand.ExecuteNonQuery();
                    break;

                case ExecuteReaderOrNonQuery.executeScalar:
                    MyCommand.ExecuteScalar();
                    break;
                }
                break;
            }
            }
            MyCOnnection.Close();
        }