oracle 客户端连接

首先在数据库上配一个本地命名配置,

2.输入网络服务名:

3.默认TCP/IP服务

4.输入主机名

5.输入服务名:

6.用正确的帐户进行测试,最后完成操作

try
   {

    string oraString="Data Source=ems;User ID=ems_user;Password=emssme";

    using (OracleConnection conn = new OracleConnection(oraString))
    {
     conn.Open ();
     string oraSelectString="select G_MARK,DU_CODE from ems_dcr_head where rownum<10";
     OracleCommand cmd=new OracleCommand (oraSelectString,conn);
     OracleDataReader dr=cmd.ExecuteReader ();
     while(dr.Read())
     {
      listBox1.Items.Add("G_MARK:"+dr.GetString (0)+"    DU_CODE:"+dr.GetString(1));
     }
 
     
    }

    
   }
   catch(System.Exception ex)
   {
    MessageBox.Show (ex.ToString ());
   }