使用ORCALE数据库,VS2003开发工具SQL语句: select * from A 表 使用ORCALE工具查询返回三条结果,数据正常。使用VS2003工具写代码查询,绑定到DataGrid,也返回三条结果,可是数据内容全为空!!!将代码部署到服务器上,在服务器打开运行,数据一切正常。最后发现本机执行select都是返回空值,执行INSERT,UPDATE,DELETE 没有问题。跟踪过了,程序在执行以下代码时,返回记录三条,具体到每一列时都为空,FP_ID列,FP_state列不为空。
string strsql=" SELECT rownum as FP_ID,FP_ID as FP_YID,FP_ADDRESS,FP_DESCRIBE,FP_MODEL,FP_PARAMETER,FP_EOMM,FP_FACTORY,FP_ADDRESS_,FP_DESCRIBE_,FP_MODEL_,FP_PARAMETER_,FP_EOMM_,FP_FACTORY_,'ADMIN' as FP_state from NYPM.DPT_V_FUNCPARTS where 1=1";DataTable seltable = conn.GetData(strsql);public DataTable GetData(string theSql)
{
OracleDataAdapter adpt = new OracleDataAdapter(theSql,dbconn);
DataSet ds = new DataSet();
adpt.Fill(ds);
dbconn.Close();
return ds.Tables[0];
}不知道各位有没有遇到类例事况,求高手解答!!!
string strsql=" SELECT rownum as FP_ID,FP_ID as FP_YID,FP_ADDRESS,FP_DESCRIBE,FP_MODEL,FP_PARAMETER,FP_EOMM,FP_FACTORY,FP_ADDRESS_,FP_DESCRIBE_,FP_MODEL_,FP_PARAMETER_,FP_EOMM_,FP_FACTORY_,'ADMIN' as FP_state from NYPM.DPT_V_FUNCPARTS where 1=1";DataTable seltable = conn.GetData(strsql);public DataTable GetData(string theSql)
{
OracleDataAdapter adpt = new OracleDataAdapter(theSql,dbconn);
DataSet ds = new DataSet();
adpt.Fill(ds);
dbconn.Close();
return ds.Tables[0];
}不知道各位有没有遇到类例事况,求高手解答!!!
你调试下,将VS 中的thesql的SQL代码贴出来看看.是否和你在ORACLE写的SQL语句一样呢?