简单的C#使用Oracle
来源:互联网 发布:数据科技类的经营范围 编辑:程序博客网 时间:2024/05/17 20:12
1.设置Scott账户的权限,使之能创建表。
2.create table employee(UserID number(4), UserName nvarchar2(32));
3.创建包,存储过程。
用DataReader:
插入数据:
2.create table employee(UserID number(4), UserName nvarchar2(32));
3.创建包,存储过程。
create or replace procedure AddNew(pUserID in Number,pUserName in nvarchar2) is
begin
insert into Employee(UserID ,UserName) values(pUserID,pUserName);
end AddNew;
--
create or replace package Employee_Op
as
type mycType is ref cursor;
procedure ShowAll(pC out mycType);
end Employee_Op;
--
create or replace package body Employee_Op
as
procedure ShowAll(pC out mycType)
is
begin
open pC for select UserID,UserName from Employee;
end ShowAll;
end Employee_Op;
4.在C# 中调用:begin
insert into Employee(UserID ,UserName) values(pUserID,pUserName);
end AddNew;
--
create or replace package Employee_Op
as
type mycType is ref cursor;
procedure ShowAll(pC out mycType);
end Employee_Op;
--
create or replace package body Employee_Op
as
procedure ShowAll(pC out mycType)
is
begin
open pC for select UserID,UserName from Employee;
end ShowAll;
end Employee_Op;
用DataReader:
string ConnStr = "data source=First;User ID = scott;Password=tiger";
OracleConnection Conn = new OracleConnection(ConnStr);
Conn.Open();
OracleCommand Cmd = new OracleCommand();
Cmd.Connection = Conn;
Cmd.CommandText = "EMPLOYEE_OP.SHOWALL";
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.Add("PC",OracleType.Cursor);
Cmd.Parameters[0].Direction = ParameterDirection.Output;
OracleDataReader DR = Cmd.ExecuteReader();
DataGrid1.DataSource = DR;
DataBind();
DR.Close();
Conn.Close();
用DataSet:OracleConnection Conn = new OracleConnection(ConnStr);
Conn.Open();
OracleCommand Cmd = new OracleCommand();
Cmd.Connection = Conn;
Cmd.CommandText = "EMPLOYEE_OP.SHOWALL";
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.Add("PC",OracleType.Cursor);
Cmd.Parameters[0].Direction = ParameterDirection.Output;
OracleDataReader DR = Cmd.ExecuteReader();
DataGrid1.DataSource = DR;
DataBind();
DR.Close();
Conn.Close();
string ConnStr = "data source=First;User ID = scott;Password=tiger";
OracleConnection Conn = new OracleConnection(ConnStr);
Conn.Open();
OracleCommand Cmd = new OracleCommand();
Cmd.Connection = Conn;
Cmd.CommandText = "EMPLOYEE_OP.SHOWALL";
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.Add("PC",OracleType.Cursor);
Cmd.Parameters[0].Direction = ParameterDirection.Output;
OracleDataAdapter DA = new OracleDataAdapter(Cmd);
//DA.TableMappings.Add("Table","Employee");
DataSet DS = new DataSet();
DA.Fill(DS);
Response.Write( DS.Tables[0].Rows.Count.ToString() );
DataGrid2.DataSource = DS.Tables[0].DefaultView;
DataGrid2.DataBind();
Cmd.Parameters.Clear();
Conn.Close();
OracleConnection Conn = new OracleConnection(ConnStr);
Conn.Open();
OracleCommand Cmd = new OracleCommand();
Cmd.Connection = Conn;
Cmd.CommandText = "EMPLOYEE_OP.SHOWALL";
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.Parameters.Add("PC",OracleType.Cursor);
Cmd.Parameters[0].Direction = ParameterDirection.Output;
OracleDataAdapter DA = new OracleDataAdapter(Cmd);
//DA.TableMappings.Add("Table","Employee");
DataSet DS = new DataSet();
DA.Fill(DS);
Response.Write( DS.Tables[0].Rows.Count.ToString() );
DataGrid2.DataSource = DS.Tables[0].DefaultView;
DataGrid2.DataBind();
Cmd.Parameters.Clear();
Conn.Close();
插入数据:
string ConnStr = "data source=First;User ID = scott;Password=tiger";
OracleConnection Conn = new OracleConnection(ConnStr);
Conn.Open();
OracleCommand Cmd = new OracleCommand();
Cmd.Connection = Conn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "AddNew";
Cmd.Parameters.Add( new OracleParameter("pUserID",OracleType.Number,4) );
Cmd.Parameters.Add(new OracleParameter("pUserName",OracleType.NVarChar,32) );
Cmd.Parameters[0].Direction = ParameterDirection.Input;
Cmd.Parameters[1].Direction = ParameterDirection.Input;
Cmd.Parameters[0].Value = int.Parse( lblID.Text.ToString() ) ;
Cmd.Parameters[1].Value = lblName.Text.ToString() ;
Cmd.ExecuteNonQuery();
Conn.Close();
dsbtn_Click(this,EventArgs.Empty);
OracleConnection Conn = new OracleConnection(ConnStr);
Conn.Open();
OracleCommand Cmd = new OracleCommand();
Cmd.Connection = Conn;
Cmd.CommandType = CommandType.StoredProcedure;
Cmd.CommandText = "AddNew";
Cmd.Parameters.Add( new OracleParameter("pUserID",OracleType.Number,4) );
Cmd.Parameters.Add(new OracleParameter("pUserName",OracleType.NVarChar,32) );
Cmd.Parameters[0].Direction = ParameterDirection.Input;
Cmd.Parameters[1].Direction = ParameterDirection.Input;
Cmd.Parameters[0].Value = int.Parse( lblID.Text.ToString() ) ;
Cmd.Parameters[1].Value = lblName.Text.ToString() ;
Cmd.ExecuteNonQuery();
Conn.Close();
dsbtn_Click(this,EventArgs.Empty);
- 简单的C#使用Oracle
- c# oracle的使用
- C# BackGroundWorker 的简单使用
- C# Linq的简单使用
- C#枚举的简单使用
- C# SharpMap的简单使用
- C# BackGroundWorker 的简单使用
- C#连接Oracle数据库的简单应用
- C#连接Oracle数据库的简单应用
- c#备份Oracle数据库的简单程序
- C#连接Oracle数据库的简单应用
- oracle触发器的简单使用
- Oracle脚本的简单使用
- oracle简单DDL的使用
- Oracle - 简单的 SELECT 的使用
- C#三层中oracle事务的使用
- C#开发之反射的简单使用
- C#中使用简单的线程
- CRM
- 在oracle数据库保存图片的方法
- scm
- J2EE
- 商业智能(Business Intelligence 简称BI),
- 简单的C#使用Oracle
- 怎样做好管理软件的项目实施和产品研发
- 数据库开发者常犯的十大错误
- 忘记MYSQL密码的解决方案
- 从人民币升值看美国对中国的经济侵略
- 精妙的SQL的数据导入导出转换
- 封装数据结果集
- Visual Studio2008(rtm版)试用心得
- Linux 裸设备基础知识