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 ());
}