How to make a request SELECT on an oracle db with parameters ? C#

Question

I want do the folowing request :

SELECT nom_projet, version_projet, version_build FROM analyses WHERE nom_projet=:Variable1 and version_projet=:Variable2 and version_build=:Variable3";

I dont understand why it doesn't work because i have done the same code for a request INSERT and this one works perfectly.

Code C#

public Boolean VerifierVersionDejaPresnte(ParseurXML.DonneesGblobale donneGlobale)
{
OracleCommand cmd = new OracleCommand();
cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "SELECT nom_projet, version_projet, version_build FROM  analyses WHERE nom_projet=:Variable1 and version_projet=:Variable2 and version_build=:Variable3" 
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new OracleParameter("Variable1",donneGblobale._nom));
cmd.Parameters.Add(new OracleParameter("Variable2",donneGblobale._version));
cmd.Parameters.Add(new OracleParameter("Variable3",donneGblobale._build));

OracleDataReader reader = cmd.ExecuteNonQuery();
if(reader.HasRows)
  return true;
return false;
}

I assume that the missing colon at version_build=Variable3 is just a typo? — Barry O'Kane
– Barry O'Kane, Commented Jun 9, 2016 at 9:04

Mairaj Ahmad · Accepted Answer · 2016-06-09 09:05:44Z

2

You are calling ExecuteNonQuery while you should call ExecuteReader.

ExecuteNonQuery is used for Insert,Update and Delete commands.

OracleDataReader reader = cmd.ExecuteReader();

answered Jun 9, 2016 at 9:05

Mairaj Ahmad

14.6k2 gold badges29 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Millet Antoine Over a year ago

when the program tries to execute cmd.ExecuteReader () I have an exception, do you have any ideas ?

Mairaj Ahmad Over a year ago

What is exception ?

Millet Antoine Over a year ago

unfortunately I'm not sure this execption is going to help us much: external component has thrown an exception

Mairaj Ahmad Over a year ago

Can u share the exception details

Millet Antoine Over a year ago

I'm sorry, it was my mistake I did a error in the code ... Your answer works perfectly.

|

Collectives™ on Stack Overflow

How to make a request SELECT on an oracle db with parameters ? C#

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related