Oracle查询在C#中不起作用 [英] Oracle query is not working in C#

问题描述

当我运行此代码时，它总是返回零，而当我在oracle sql客户端中运行此查询时，它返回1.

When I run this code it always returning zero while when i run this query in oracle sql client it returns 1.

 var strSQL = string.Format("SELECT COUNT(*) FROM GANTNER.GAT_REASONS WHERE CODE ='{0}'", StatusCode);    
 objCmd = new OracleCommand(strSQL, objConn);
 objCmd.CommandType = CommandType.Text;
 int val = int.Parse(objCmd.ExecuteScalar().ToString());

尝试删除列名CODE上的条件，它起作用，但是当我将列名CODE放到那时，我不尝试将"CODE" 'CODE'都放不下，总​​是返回零，而应该返回1，因为存在行.

For try I remove condition on column name CODE and it works but when I put column name CODE it does not then I tried to put "CODE" 'CODE' all not working always returning zero while it should return 1 because row exist.

推荐答案

可能是字母 case 问题.请尝试使用UPPER/UCASE函数进行比较.

May be letter case problem.Try UPPER/UCASE function to compare.

var strSQL = string.Format("SELECT COUNT(*) FROM GANTNER.GAT_REASONS
              WHERE UCASE(CODE) ='{0}'", StatusCode.ToUpper());    

或

var strSQL ="SELECT COUNT(*) FROM GANTNER.GAT_REASONS WHERE CODE =:code";
objCmd = new OracleCommand(strSQL, objConn);
objCmd.Parameters.AddWithValue("code",StatusCode.ToUpper());

这篇关于Oracle查询在C#中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！