CODEWITHSUNDEEP
c#-4.0oracle11g
SOF User
SOF User

Reputation: 7840

Oracle query is not working in C#

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());

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.

Upvotes: 2

Views: 2181

Answers (2)

KV Prajapati
KV Prajapati

Reputation: 94653

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());

Or

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

Upvotes: 3

ipavlic
ipavlic

Reputation: 4966

Try this:

OracleCommand cmd = conn.createCommand();
// parametrized sql query
cmd.CommandText = "SELECT COUNT(*) FROM GANTNER.GAT_REASONS WHERE CODE = :status";
// add parameter for the query
cmd.Parameters.AddWithValue("status", StatusCode); 
int val = int.Parse(objCmd.ExecuteScalar().ToString());

Upvotes: 1

Related Questions