Oracle connection with C#

Siva V

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi,
Please refer the below link, it might helps you
https://www.c-sharpcorner.com/UploadFile/nipuntomar/connection-strings-for-oracle/
Sanwar Ranwa8y ago
Put Debugger and Debug your code and also check is there data in your database table
Siva V8y ago
I have reviewed all below stuff for your reference. code looks good not sure where is the
exact issue.

Sanwar,

Do you understand my question & code snipper what is provide above. If not take a deep look into it & understand again. please do comment if you have any relevant. Debugging & checking the data in table is the very basic step any developer do. please don't waste my time & your time.
Sanwar Ranwa8y ago
Hello Siva

Please check these Links

https://www.youtube.com/watch?v=8VmBbVOMggk

https://www.oracle.com/technetwork/articles/dotnet/vs2010-oracle-dev-410461.html

https://o7planning.org/en/10509/connecting-to-oracle-database-using-csharp-without-oracle-client

https://stackoverflow.com/questions/12568100/connecting-to-oracle-database-through-c