C#Á¬½ÓOracle 10g

C#Á¬½ÓOracle 10g
ÎÄÕ³ö´¦£ºDIY²¿Âä(http://www.diybl.com/course/4_webprogram/asp.net/asp_netshl/200853/112441.html)
 
1¡¢¿ØÖÆÃæ°å->¹ÜÀí¹¤¾ß->Êý¾ÝÔ´(ODBC)->Ìí¼ÓÊý¾ÝÔ´->Ñ¡Ôñoracle ¿Í»§¶Ë
       Data Source Name ¿ÉÒÔÈÎÒâÆðÃû£¬ÍƼöºÍSIDÒ»Ñù
       Description ÃèÊö
       TNS Service Name ÏÂÀ­²Ëµ¥Öлá×Ô¶¯ÏÔʾ»·¾³±äÁ¿TNS_ADMINËùָĿ¼ÏµÄtnsnames.oraÎļþÖÐSERVICE_NAMEµÄÃû³Æ£¬Ò²¾ÍÊÇÒªÁ¬½ÓµÄSID
       UserID Óû§Ãû
2¡¢Test ConnectionÁ¬½Ó³É¹¦
C#
ÏîÄ¿->Ìí¼ÓÒýÓÃ->.NET->System.Data.OracleClient.dll £¨Õâ¸öDLLÔÚ×°ÍêDOTNET 1.1¾Í´æÔÚ£©
using System;
using System.Data;
using System.Windows.Forms;
using System.Data.OracleClient;
namespace Test
...{
    /**//**//**//// <summary>
    /// ¼ò½àÆڼ䣬ֱ½Ó½«ÊµÏÖдÔÚ¹¹Ô캯ÊýÖÐ
    /// </summary>
    public class Test
    ...{
        public Test()
        ...{
            //
            // TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼­
            //
            string ConnectionString = "Data Source=orcl
 ; User Id=SCOTT; Password=scott";  //Á¬½Ó×Ö·û´®
            OracleConnection conn = new OracleConnection(ConnectionString);    //´´½¨Ò»¸öÐÂÁ¬½Ó
           
            try
            ...{
             &n