SQL代码如下
with t1 as(
select b.is_import,b.active_flag,b.last_upd,b.row_id,b.dsig_date,b.vicont_code,b.vendor_id,b.cust_id,b.vcurr_id,b.namt,b.created_by,b.created,b.registdate,b.audit_status,b.prtypedesc
from UKING_ZHONGFU.BU_INCONT b
)
select t2.row_id from t1 left join org_approval_main t2 on t1.row_id=t2.business_id
C#代码如下
oc.Open();
//OracleCommand 被标注为已过时
OracleCommand cmd = oc.CreateCommand();
cmd.CommandText = @"
with t1 as(
select b.is_import,b.active_flag,b.last_upd,b.row_id,b.dsig_date,b.vicont_code,b.vendor_id,b.cust_id,b.vcurr_id,b.namt,b.created_by,b.created,b.registdate,b.audit_status,b.prtypedesc
from UKING_ZHONGFU.BU_INCONT b
)
select t2.row_id from t1 left join org_approval_main t2 on t1.row_id=t2.business_id
";
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds,"Table");在C#中ds得出来是个空的，找了好久不知道是什么原因。请教，谢谢！
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/887/viewspace-3121792/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
