How to connect to a oracle database and run some sample query using ASP.NET
Posted on 2011-05-09
Need your help in the following.
I have a odbc connection configured in my PC for oracle database. (Oracle for orahome92)
using Visual studio web developer 2008 version (Express edition free version),
need to connect to the database using connection string.
then run 2 distinct count queries like
select distinct count empid where dept = finance
select distinct count where sal > 10000and dept = finance
2nd one is subset of first one
Just need one page web screen to show the values returned in the above queries.
then also show the percentage of it on the screen
Have tried many connection string.
Either I am getting error in connection or if its connecting unable to execute the query to return the value and show on the screen.
Request your help