. Net does not install a client to connect to Oracle

Oralce Version: 11g r2

1. Copy OCI. dll, ociw32.dll, Oracle. dataaccess. dll, orannzsbb11.dll, oraocci11.dll, oraociicus11.dll, and oraops11w. DLL to the bin directory.
2. Add a reference to Oracle. dataaccess. dll.
3. WriteCodeSuch:

View plaincopy to clipboardprint?

2. UsingSystem;
4. UsingSystem. Collections. Generic;
6. UsingSystem. LINQ;
8. UsingSystem. Web;
10. UsingSystem. Web. UI;
12. UsingSystem. Web. UI. webcontrols;
14. UsingOracle. dataaccess. client;
18. NamespaceOracle1
20. {
22. PublicPartialClass_ Default: system. Web. UI. Page
24. {
26. Protected VoidPage_load (ObjectSender, eventargs E)
28. {
30. StringConnstring ="Data Source = (description = (address = (Protocol = TCP) (host = 192.168.0.37) (Port = 1521 ))"+"(CONNECT_DATA = (SID = orcl); User ID = system; Password = ikmbikmb ;";
34. Using(Oracleconnection conn =NewOracleconnection (connstring ))
36. {
40. Conn. open ();
44. StringSQL ="Select * from T1 t";
48. Using(Oraclecommand comm =NewOraclecommand (SQL, Conn ))
50. {
54. Using(Oracledatareader RDR = comm. executereader ())
56. {
60. While(RDR. Read ())
62. {
64. Response. Write (RDR. getstring (1) +"<Br>");
68. }
72. }
76. }
80. }
84. }
86. }
88. }