C#

public class GPErrorArgs : EventArgs
{
    private string sAppVerData = "Global Parameters Class";
    private int nErrorCode = 0;
    private int nErrorSection = 0;
    private string sMessage = "";
    private string sRoutine = "";
    private string sSource = "";
    private bool bCritical = false;
    private bool bMustDisplay = false;

    public GPErrorArgs(string ApplicationData, int ErrorCode, int ErrorSection, string ErrorMessage, string RoutineName, string ErrorSource, bool Critical, bool MustDisplay)
    {
        sAppVerData = ApplicationData;
        nErrorCode = ErrorCode;
        nErrorSection = ErrorSection;
        sMessage = ErrorMessage;
        sRoutine = RoutineName;
        sSource = ErrorSource;
        bCritical = Critical;
        bMustDisplay = MustDisplay;
    }

    public string RoutineName
    {
        get
        {
            return sRoutine;
        }
    }
} //End class GPErrorArgs

    public class CGeneralParameters : IDisposable
    {
        private string m_strConnectionString = "";
        private string m_sAppData = "";
        private bool m_bDoneBefore = false;

        public event ClassErrorEventHandler RaiseClassError;

        public CGeneralParameters()
        {
            //   **** Should there be some sort of declaration here to set up the GPErrors instance??  ****** 
            try
            {
                EMCServerParams cConnect = new EMCServerParams();
                m_strConnectionString = cConnect.DBConnectionString;
                cConnect.Dispose();
                m_sAppData = "Global Parameters Class";
            }
            catch (Exception ex)
            {
                // Fill the error arguments
                GPErrorArgs e = new GPErrorArgs(m_sAppData, (int)EnumSets.DeskTopErrorsEnum.dteSQLGeneralConnectionFailure, 1, ex.Message, "General Parameters:Initialisation", ex.Source, true, true);
                OnRaiseClassError(e);
            }
        }

        protected virtual void OnRaiseClassError(GPErrorArgs e)
        {
            RaiseClassError(this, e);
        }

        public object GetParameterByID(EnumSets.UserParameterNumbersEnum ParameterID)
        {
            object ParamReturnValue;
            ParamReturnValue = GetAParameterByID((int)ParameterID);
            return ParamReturnValue;
        }
     }

dtDate = DateTime.Parse(stringDate);

if (dtDate > startDate && dtDate < endDate)
{
	row["NEW_DATE_FIELD"] = stringDate;
	myTable.ImportRow(row);						
}

String sqltext = "Select artext from tbl_ar"; // artext is
   // varchar2(30 char)
DataTable schTable;
OracleDataReader rdr = null;


OracleCommand cmd = new OracleCommand (sqltext, OracleConnection, OracleTransaction);
rdr = cmd.ExecuteReader(CommandBehavior.KeyInfo);
schTable = rdr.GetSchemaTable();  // Here the DataTable is filled with the
    //  information of the columns
DataRow fldDescr = schTable.Rows[0];
int len = (int) fldDescr[2]; 	    // 2 = ColumnSize