首页 新闻 赞助 找找看

oracle关联查询在ps/sql中正常,但是在C#中fill后值为空

0
悬赏园豆:10 [待解决问题]

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得出来是个空的,找了好久不知道是什么原因。请教,谢谢!

幻逸云的主页 幻逸云 | 初学一级 | 园豆:194
提问于:2019-09-05 16:55
< >
分享
所有回答(1)
0

数据库链接有问题

幻逸云 | 园豆:194 (初学一级) | 2020-12-05 09:58
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册