问题描述

c# ora oracle sql 查询

SELECT * from V_DEPXIAOSGONG where CITYNAME like '%北京%'
在 navicat 里面查询有个4条数据

string sumData = "SELECT * from V_DEPXIAOSGONG where CITYNAME like '%北京%'";

OracleCommand cmd = new OracleCommand();
PrepareCommand(cmd, connection, null, sumData, cmdParms);
using (OracleDataAdapter da = new OracleDataAdapter(cmd))
{
DataSet ds = new DataSet();
try
{
da.Fill(ds, "ds");
cmd.Parameters.Clear();
}
catch (OracleException ex)
{
throw new Exception(ex.Message);
}
return ds;
}

是不是字符集有问题