一:连接字符串
<appSettings>
<add key="ConnectionString1" value="Data Source=zynlh;User Id=scott;Password=tiger;Integrated Security=no;" />
</appSettings>
特别的:Data Source 需要赋予的值是 oracle 服务名
我在第一次使用的时候,写成orale服务器的ip了,报错:服务名 server_name 不对.
二:使用上与sqlserver 很相似.下面是个例子
string mySelectQuery="select * from nlh";
string conn=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString1"];
OracleConnection myConnection =new OracleConnection(conn);
OracleCommand myCommand=new OracleCommand(mySelectQuery,myConnection);
myConnection.Open();
System.Data.OracleClient.OracleDataReader myReader;
myReader=myCommand.ExecuteReader();
ArrayList myArrayList=new ArrayList();
while(myReader.Read())
{
Response.Write(myReader.GetString(0)+myReader.GetString(1));
}
myReader.Close();
myConnection.Close();
三:需要导入 using System.Data.OracleClient;
<appSettings>
<add key="ConnectionString1" value="Data Source=zynlh;User Id=scott;Password=tiger;Integrated Security=no;" />
</appSettings>
特别的:Data Source 需要赋予的值是 oracle 服务名
我在第一次使用的时候,写成orale服务器的ip了,报错:服务名 server_name 不对.
二:使用上与sqlserver 很相似.下面是个例子
string mySelectQuery="select * from nlh";
string conn=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString1"];
OracleConnection myConnection =new OracleConnection(conn);
OracleCommand myCommand=new OracleCommand(mySelectQuery,myConnection);
myConnection.Open();
System.Data.OracleClient.OracleDataReader myReader;
myReader=myCommand.ExecuteReader();
ArrayList myArrayList=new ArrayList();
while(myReader.Read())
{
Response.Write(myReader.GetString(0)+myReader.GetString(1));
}
myReader.Close();
myConnection.Close();
三:需要导入 using System.Data.OracleClient;