aReader reader;
oracle2.ConnectionString="User ID=system;user id=system;data source=rick;password=system";
System.Data.OracleClient.OracleCommand Com=new System.Data.OracleClient.OracleCommand(sqlText,oracle2);
Com.Connection.Open();
reader=Com.ExecuteReader();
DataGrid4.DataSource=reader;
DataGrid4.DataBind();
//this.Response.Write(oleDbConnection1.ConnectionString);
reader.Close();
Com.Connection.Close();
}
注意点:
如果不设置远程数据的本级网络配置
ORA-00162: external dbid length 18 is greater than maximum (16)
连接名称不能超过16个字符
修改方法
Configuration and Migration Tools->Net Configuration Assistant中配置
===========================================
在.NET中调用Oracle9i存储过程经验总结
在.NET中调用Oracle9i存储过程可以用多个数据提供者,比如OralceClient,OleDb。本文将用OralceClient为例。.NET语言用C#。
一、调用一个带输入、输出参数的存储过程
首先,在Oralce中创建存储过程如下:
create or replace procedure GetRecords(name_out out varchar2,age_in in varchar2) as
begin
select NAME into name_out from test where AGE = age_in;
end;
然后,在C#项目中作如下调用:
string connectionString = "Data Source=YXZHANG;User ID=YXZHANG;Password=YXZHANG";
string queryString = "getrecords";
OracleConnection cn = new OracleConnection(connectionString);
OracleCommand cmd = new OracleCommand(quer
用AspNetPager分页实例代码.txt