Hi Expert,
I use the code to fetch the oracle sample data as below:
using (OracleConnection _connection = new OracleConnection(_oradbConnectionString))
{
_connection.Open();
OracleCommand _cmd = new OracleCommand();
_cmd.Connection = _connection;
_cmd.CommandText = _oradbSelectStatement +
" where OUT_JOB between TO_DATE('" + _beginDate + "', 'MM/DD/YYYY') and TO_DATE('" + _endDate + "', 'MM/DD/YYYY')";
_cmd.CommandType = System.Data.CommandType.Text;
using (OracleDataReader _reader = _cmd.ExecuteReader())
{
if (_reader.HasRows)
{
while (_reader.Read())
{
ListItemCollection _sPListItemCollection = GetItemsCol(args[0], _reader.GetString(0).ToString());
But I perform the code again and again every time I got the same value of the date ... even I change the value from oracle ...
I don't know why??
VS .NET Instant Watch
Oracle View
Hi there, if you found my comment very helpful then please | Propose as answer | . Thanks and Regards.