Connect Oracle database and Fetch the record and Display in Asp.net

Question

User-465685172 posted

Hi,

Everyone

    I have a  Project in Which i need to Fetch the Data from Oracle and display

in RDLC report

I need the steps how can i connect  the Asp.net

with Oracle database

 

Reply me

Answer 1

User353943928 posted

Please see the below link it is all about the information you need.

Link: http://www.startvbdotnet.com/ado/oracle.aspx 

Cheers...

Answer 2

User-465685172 posted

 

Anand Tiwari

 

this Link is contain the data in VB.net

I need what all the things should i change in web.config file

and in the Page also

in C# Language

Reply me

Answer 3

User1013750657 posted

hi anand

make sure you have oracle client installed.

make sure you are using the namespace system.data.oracleclient from microsoft. (thats what i use. you can try others)

add the connection string to web.config

<connectionStrings>
        <add name="OracleConnString" connectionString="User ID=myuser;Password=mypass;Data Source=TNSALIASfromTNSFILE"/>
</connectionStrings>

 

then from the code behind just :

String SqlQuery; 
OracleConnection OraConnection = new OracleConnection(WebConfigurationManager.ConnectionStrings["OraConnectionString"].ConnectionString); 
OracleCommand OraCommand; 

SqlQuery = "Insert Into " + 
                  "mytable " + 
                  "            (myfield) " + 
                  " Values " + 
                  "            ('Hello') "; 

OraCommand = new OracleCommand(SqlQuery,OraConnection); OracleDataReader OraDataReader = OraCommand.ExecuteReader(); 

SqlQuery = "Select " + 
                  "       myfield " + 
                  "From " + 
                  "       mytable"; 

OraCommand = new OracleCommand(SqlQuery,OraConnection); OracleDataReader OraDataReader = OraCommand.ExecuteReader(); 

while(OraDataReader.Read) 
{ 
         """"whatever you want to do with the result"""" = OraDataReader["myfield"]; 
} 

Answer 4

User1013750657 posted

of course the connection string can be alot more elaborated. you can actually copy the TNSNAMES block and pasted on the conenction string , this way you dont have to configure the TNSNAMES. all configuration is done on the web.config file.

i should olso point that i never use the web.config file since the oracle password will be available for anyone to see.

i normaly do a form so that the installer can insert the password , and then i save it with encription.

if you have a db with credit card information for instance , you will fail on an audit since clear passwords are not PCI compliant.

 

rgds

rui