Oracle connection with C#

Question

Hi Guys,

 

I try to pull data from Oracle & bind my datasource. Below is my code snippet.

 

string sql =  "Select * from Employee Where EmpId = ':EmpId'";

OracleConnection con = new OracleConnection(connectionString);

OracleCommand cmd = new OracleCommand(sql, con); 

cmd.Parameters.Add(new OracleParameter("EmpId", "10");

OracleAdapter oDA = new OracleAdapter(cmd);

oDA.fill(ds);

 

I don't see any errors but results are not coming. but when i execute my query as follows i see results.

 

Select * from Employee Where EmpID = '10';     //I can see result 

 

Could you please let me know where It's going wrong.

 

Thanks