Database

string strFilter = "date >= '1/1/2003' AND date <= '12/31/2003'; <br />
DataRow[] rows = ds.Tables[0].Select(strFilter);

string strFilter = "date >= '1/1/2003' AND date <= '1/1/2004'; <br />
DataRow[] rows = ds.Tables[0].Select(strFilter);

		try
		{
			m_ReturnRate				=	-1.0;

			m_FXConn				=	new OracleConnection();
			m_FXConn.ConnectionString		=	"Server=XXXXXX;User ID=XXXXXX; Password=XXXXXX";

			m_FXCommand				=	m_FXConn.CreateCommand();
			m_FXCommand.CommandType			=	CommandType.StoredProcedure;
			m_FXCommand.CommandText			=	"get_currency_forward_rate( :TRADECURRENCY, :SETTLECURRENCY, :VALDATE, :SETTLEDATE, :STATUS, :CALCRATE )";

			m_parmTradeCurrency			=	m_FXCommand.CreateParameter();
			m_parmTradeCurrency.ParameterName	=	"TRADECURRENCY";
			m_parmTradeCurrency.OracleType		=	OracleType.VarChar;
			m_parmTradeCurrency.Direction		=	ParameterDirection.Input;

			m_parmSettlementCurrency		=	m_FXCommand.CreateParameter();
			m_parmSettlementCurrency.ParameterName	=	"SETTLECURRENCY";
			m_parmSettlementCurrency.OracleType	=	OracleType.VarChar;
			m_parmSettlementCurrency.Direction	=	ParameterDirection.Input;

			m_parmValuationDate			=	m_FXCommand.CreateParameter();
			m_parmValuationDate.ParameterName	=	"VALDATE";
			m_parmValuationDate.OracleType		=	OracleType.DateTime;
			m_parmValuationDate.Direction		=	ParameterDirection.Input;

			m_parmSettlementDate			=	m_FXCommand.CreateParameter();
			m_parmSettlementDate.ParameterName	=	"SETTLEDATE";
			m_parmSettlementDate.OracleType		=	OracleType.DateTime;
			m_parmSettlementDate.Direction		=	ParameterDirection.Input;

			m_parmStatus				=	m_FXCommand.CreateParameter();
			m_parmStatus.ParameterName		=	"STATUS";
			m_parmStatus.OracleType			=	OracleType.Int32;
			m_parmStatus.Direction			=	ParameterDirection.Output;

			m_parmCalculatedRate			=	m_FXCommand.CreateParameter();
			m_parmCalculatedRate.ParameterName	=	"CALCRATE";
			m_parmCalculatedRate.OracleType		=	OracleType.Double;
			m_parmCalculatedRate.Direction		=	ParameterDirection.Output;

			m_FXConn.Open();
			Console.WriteLine( "OPENED" );
			m_FXCommand.Prepare();
			Console.WriteLine( "PREPARED" );
		}
...
...
...
		try
		{
			m_parmTradeCurrency.Value	=	CurrencyTrade;
			m_parmSettlementCurrency.Value	=	CurrencySettle;
			m_parmValuationDate.Value	=	ValuationDate;
			m_parmSettlementDate.Value	=	SettlementDate;
			m_parmCalculatedRate.Value	=	-1.0;
			m_parmStatus.Value		=	-1;

			m_FXCommand.ExecuteNonQuery();
			Console.WriteLine( "EXECUTED" );

			if ( m_parmStatus.Value.Equals(0) )
			{
				m_ReturnRate			=	(double)m_parmCalculatedRate.Value;
			}
		}