CODEWITHSUNDEEP
c#oracle-databaseselectparametersrequest
Millet Antoine
Millet Antoine

Reputation: 415

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

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;
}

Upvotes: 0

Views: 62

Answers (1)

Mairaj Ahmad
Mairaj Ahmad

Reputation: 14604

You are calling ExecuteNonQuery while you should call ExecuteReader.

ExecuteNonQuery is used for Insert,Update and Delete commands.

OracleDataReader reader = cmd.ExecuteReader();

Upvotes: 2

Related Questions