c#还原oracle11g,c# 访问Oracle11g的方法--无需客户端

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using Oracle.ManagedDataAccess.Client;

using Oracle.ManagedDataAccess.Types;

using System.Data;

namespace Oracle11gDemo2ManagedDataAccessdll

{

class Program

{

static void Main(string[] args)

{

try

{

string connStr = "User Id=DJCB;Password=12345678;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=172.23.253.105)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)))";

using (var conn = newOracleConnection(connStr))

{

conn.Open();

DataSet ds=new DataSet ();

string sql="select * from DJCB_WZSJ";OracleDataAdapteroda = new OracleDataAdapter(sql, conn);

oda.Fill(ds);

DataTable dt = ds.Tables[0];

}

}

catch (OracleException ex)

{

throw new Exception(ex.Message);

}

}

}

}