private void button3_Click(object sender, EventArgs e)
        {
            String _connstring = "Data Source=localhost/NEWDB;User Id=EDZEHOO;Password=PASS123;";

            try
            {
                OracleConnection _connObj = new OracleConnection();
                _connObj.ConnectionString = _connstring;
                _connObj.Open();
                OracleGlobalization info = OracleGlobalization.GetClientInfo();
                info.Language = "ITALIAN";
                _connObj.SetSessionInfo(info);
                OracleCommand _cmdObj = _connObj.CreateCommand();
                _cmdObj.CommandText = "SELECT NonExistentField FROM Products";
                OracleDataReader _reader = _cmdObj.ExecuteReader();
                _reader.Dispose();
                _cmdObj.Dispose();
                _connObj.Dispose();
                _reader.Close();
                _connObj.Close();
                _reader  = null;
                _connObj = null;
                _cmdObj  = null;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
        }
        private void button9_Click(object sender, EventArgs e)
        {
            string _connstring = "Data Source=localhost/NEWDB;User Id=EDZEHOO;Password=PASS123;";
            string _result;

            try
            {
                OracleConnection _connObj = new OracleConnection();
                _connObj.ConnectionString = _connstring;
                _connObj.Open();
                OracleGlobalization info = OracleGlobalization.GetClientInfo();
                info.Territory = "Sweden";
                info.Language  = "Swedish";
                OracleGlobalization.SetThreadInfo(info);
                _connObj.SetSessionInfo(info);
                OracleCommand _cmdObj = _connObj.CreateCommand();
                _cmdObj.CommandText = "SELECT TO_CHAR(Price,'L99G999D99') PriceDefCurrency, TO_CHAR(Price,'U99G999D99') PriceDualCurrency, TO_CHAR(ExpiryDate,'DL') ExpiryDate FROM Products WHERE ID='E1'";
                OracleDataReader _reader = _cmdObj.ExecuteReader();
                if (_reader.HasRows)
                {
                    if (_reader.Read())
                    {
                        String _priceDefCurrency  = _reader.GetString(_reader.GetOrdinal("PriceDefCurrency"));
                        String _priceDualCurrency = _reader.GetString(_reader.GetOrdinal("PriceDualCurrency"));
                        String _expiryDate        = _reader.GetString(_reader.GetOrdinal("ExpiryDate"));
                        _result = _priceDefCurrency + "\n" + _priceDualCurrency + "\n" + _expiryDate;
                        MessageBox.Show(_result);
                    }
                }
                _reader.Dispose();
                _cmdObj.Dispose();
                _connObj.Dispose();
                _reader.Close();
                _connObj.Close();
                _reader  = null;
                _connObj = null;
                _cmdObj  = null;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
        private void button4_Click(object sender, EventArgs e)
        {
            string _connstring = "Data Source=localhost/NEWDB;User Id=EDZEHOO;Password=PASS123;";
            string _result;

            try
            {
                OracleConnection _connObj = new OracleConnection();
                _connObj.ConnectionString = _connstring;
                _connObj.Open();
                OracleGlobalization info = OracleGlobalization.GetClientInfo();
                info.DateLanguage = "FINNISH";
                info.DateFormat   = "DD-MON-YYYY";
                OracleGlobalization.SetThreadInfo(info);
                OracleCommand _cmdObj = _connObj.CreateCommand();
                _cmdObj.CommandText = "SELECT ExpiryDate FROM Products ORDER BY ExpiryDate ASC";
                OracleDataReader _reader = _cmdObj.ExecuteReader();
                _result = "Results:";
                if (_reader.HasRows)
                {
                    while (_reader.Read())
                    {
                        OracleDate _odate =
                            _reader.GetOracleDate(_reader.GetOrdinal("ExpiryDate"));
                        _result = _result + "\n" + _odate.ToString();
                    }
                }
                MessageBox.Show(_result);
                _reader.Dispose();
                _cmdObj.Dispose();
                _connObj.Dispose();
                _reader.Close();
                _connObj.Close();
                _reader  = null;
                _connObj = null;
                _cmdObj  = null;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
        private void button8_Click(object sender, EventArgs e)
        {
            String _connstring = "Data Source=localhost/NEWDB;User Id=EDZEHOO;Password=PASS123;";
            string _result;

            try
            {
                OracleConnection _connObj = new OracleConnection();
                _connObj.ConnectionString = _connstring;
                _connObj.Open();
                OracleCommand _cmdObj = _connObj.CreateCommand();
                _cmdObj.CommandText = "SELECT Name FROM Products ORDER BY Name ASC";
                OracleGlobalization info = OracleGlobalization.GetClientInfo();
                info.Sort = "SPANISH_M";
                _connObj.SetSessionInfo(info);
                OracleDataReader _reader = _cmdObj.ExecuteReader();
                _result = "Results:";
                if (_reader.HasRows)
                {
                    while (_reader.Read())
                    {
                        String _Name = _reader.GetString
                                           (_reader.GetOrdinal("Name"));
                        _result = _result + "\n" + _Name.ToString();
                    }
                }
                MessageBox.Show(_result);
                _reader.Dispose();
                _cmdObj.Dispose();
                _connObj.Dispose();
                _reader.Close();
                _connObj.Close();
                _reader  = null;
                _connObj = null;
                _cmdObj  = null;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
        private void button6_Click(object sender, EventArgs e)
        {
            string _connstring = "Data Source=localhost/NEWDB;User Id=EDZEHOO;Password=PASS123;";
            string _result;

            try
            {
                OracleConnection _connObj = new OracleConnection();
                _connObj.ConnectionString = _connstring;
                _connObj.Open();
                OracleGlobalization info = OracleGlobalization.GetClientInfo();
                info.ISOCurrency = "AUSTRALIA";
                _connObj.SetSessionInfo(info);
                OracleCommand _cmdObj = _connObj.CreateCommand();
                _cmdObj.CommandText = "SELECT TO_CHAR(Price,'C99G999D99') Price FROM Products";
                OracleDataReader _reader = _cmdObj.ExecuteReader();
                _result = "Results:";
                if (_reader.HasRows)
                {
                    while (_reader.Read())
                    {
                        String _price = _reader.GetString
                                            (_reader.GetOrdinal("Price"));
                        _result = _result + "\n" + _price.ToString();
                    }
                }
                MessageBox.Show(_result);
                _reader.Dispose();
                _cmdObj.Dispose();
                _connObj.Dispose();
                _reader.Close();
                _connObj.Close();
                _reader  = null;
                _connObj = null;
                _cmdObj  = null;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
        private void button7_Click(object sender, EventArgs e)
        {
            string _connstring = "Data Source=localhost/NEWDB;User Id=EDZEHOO;Password=PASS123;";

            try
            {
                OracleConnection _connObj = new OracleConnection();
                _connObj.ConnectionString = _connstring;
                _connObj.Open();
                OracleGlobalization info = OracleGlobalization.GetClientInfo();
                info.Territory = "Hong Kong";
                info.TimeZone  = "Asia/Hong_Kong";
                OracleGlobalization.SetThreadInfo(info);
                _connObj.SetSessionInfo(info);
                OracleCommand _cmdObj = _connObj.CreateCommand();
                _cmdObj.CommandText = "SELECT LaunchDate AT LOCAL LaunchDateLocal FROM Products";
                OracleDataReader _reader = _cmdObj.ExecuteReader();
                if (_reader.HasRows)
                {
                    if (_reader.Read())
                    {
                        OracleTimeStampTZ _launchDate = _reader.GetOracleTimeStampTZ
                                                            (_reader.GetOrdinal("LaunchDateLocal"));
                        MessageBox.Show(_launchDate.ToString());
                    }
                }
                _reader.Dispose();
                _cmdObj.Dispose();
                _connObj.Dispose();
                _reader.Close();
                _connObj.Close();
                _reader  = null;
                _connObj = null;
                _cmdObj  = null;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }