Code: Select all
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Devart.Data.Oracle;
using System.Data;
namespace ConsoleApplication2
{
class Program
{
static string connString = "user id=yx_trunk_central;server=dev;Unicode=true;password=1122;";
static void Main(string[] args)
{
OracleDataReader _reader;
OracleCommand _cmd = new OracleCommand();
//clear table
Excute("delete from MYTABLE");
////insert
Excute("insert into MYTABLE(ID,FLG,ID1,ID2,time,name,time1,X,act,ks,kst,time2,time3,ex,lst,lst1,user2,psid,time4,sts,spsid,status,time5) values('5806C1FF6F02A04AAA9D2AD2260703BB',0,'54DF494826B3A0458A24F65B3FA428D8',2,to_date('2013-06-03','yyyy-mm-dd'),'XXX',to_date('2013-06-03','yyyy-mm-dd'),'63446F95376F3F49BAAC911060210F43','DE3577BEF4A4AC4DBF9DFAC0BADA9F8F','EFCD53F162326B4D87FB0939A1C21D31','81492B95AD6E244BA7ACA80440F5D35C',to_date('2013-06-03','yyyy-mm-dd'),to_date('2013-06-03','yyyy-mm-dd'),null,null,null,null,'F19DB655CBA30F4984F9B4E38DAC8174',to_date('2013-06-03','yyyy-mm-dd'),3,null,null,to_date('2013-06-03','yyyy-mm-dd'))");
#region select returned false ** it is not right
_cmd = new OracleCommand();
_cmd.CommandText = "select t0.time1,t0.act,t0.time5,t0.user2,t0.ex,t0.sts,t0.status,t0.ks,t0.ID,t0.X,t0.psid,t0.spsid,t0.lst1,t0.time3,t0.lst,t0.time4,t0.ID1,t0.time2,t0.ID2 from MYTABLE t0";
Console.WriteLine(_cmd.CommandText);
_cmd.Connection = new OracleConnection();
_cmd.Connection.ConnectionString = connString;
_cmd.Connection.Open();
_reader = _cmd.ExecuteReader(CommandBehavior.Default);
if (_reader.Read())
{
bool isNull = _reader.IsDBNull(3);
Console.WriteLine(isNull);
if (!isNull)
Console.WriteLine("result:"+_reader.GetString(3));
}
_cmd.Connection.Close();
#endregion
Console.WriteLine("\n********************************************************************\n");
#region select returned true ** it is right
_cmd = new OracleCommand();
_cmd.CommandText = "select t0.time1,t0.time5,t0.act,t0.user2,t0.ex,t0.sts,t0.status,t0.ks,t0.ID,t0.X,t0.psid,t0.spsid,t0.lst1,t0.time3,t0.lst,t0.time4,t0.ID1,t0.time2,t0.ID2 from MYTABLE t0";
Console.WriteLine(_cmd.CommandText);
_cmd.Connection = new OracleConnection();
_cmd.Connection.ConnectionString = connString;
_cmd.Connection.Open();
_reader = _cmd.ExecuteReader(CommandBehavior.Default);
if (_reader.Read())
{
bool isNull = _reader.IsDBNull(3);
Console.WriteLine(isNull);
if (!isNull)
Console.WriteLine("result:" + _reader.GetString(3));
}
_cmd.Connection.Close();
#endregion
}
static void Excute(string sql)
{
OracleCommand _cmd = new OracleCommand();
_cmd.CommandText = sql;
_cmd.Connection = new OracleConnection();
_cmd.Connection.ConnectionString = connString;
_cmd.Connection.Open();
_cmd.ExecuteNonQuery();
_cmd.Connection.Close();
}
}
}