CREATE OR REPLACE PACKAGE BODY PKG_HIS_APPOINTMENT IS
PROCEDURE UP_DEPT_DICT(cur_OUT OUT MYCURSOR) IS
BEGIN
OPEN cur_OUT FOR
select dept_name, dept_code
from dept_dict
where OUTP_OR_INP = 0
or OUTP_OR_INP = 2;
END UP_DEPT_DICT;using (OracleConnection connection = new OracleConnection(ConString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
OracleDataAdapter oracleDataAdapter = new OracleDataAdapter();
OracleCommand oracleSelectCommand = new OracleCommand(); oracleSelectCommand.CommandText = "OUTPADM.PKG_HIS_APPOINTMENT.UP_DEPT_DICT";
oracleSelectCommand.CommandType = CommandType.StoredProcedure;
oracleSelectCommand.Parameters.Add("cur_OUT", OracleType.Cursor).Direction = ParameterDirection.Output;
oracleDataAdapter.SelectCommand = oracleSelectCommand;
oracleDataAdapter.Fill(ds);
oracleDataAdapter.Dispose();
}
catch (System.Data.OracleClient.OracleException ex)
{
throw new Exception(ex.Message);
}
finally
{
connection.Close();
}
return ds;
}DS总是空值
PROCEDURE UP_DEPT_DICT(cur_OUT OUT MYCURSOR) IS
BEGIN
OPEN cur_OUT FOR
select dept_name, dept_code
from dept_dict
where OUTP_OR_INP = 0
or OUTP_OR_INP = 2;
END UP_DEPT_DICT;using (OracleConnection connection = new OracleConnection(ConString))
{
DataSet ds = new DataSet();
try
{
connection.Open();
OracleDataAdapter oracleDataAdapter = new OracleDataAdapter();
OracleCommand oracleSelectCommand = new OracleCommand(); oracleSelectCommand.CommandText = "OUTPADM.PKG_HIS_APPOINTMENT.UP_DEPT_DICT";
oracleSelectCommand.CommandType = CommandType.StoredProcedure;
oracleSelectCommand.Parameters.Add("cur_OUT", OracleType.Cursor).Direction = ParameterDirection.Output;
oracleDataAdapter.SelectCommand = oracleSelectCommand;
oracleDataAdapter.Fill(ds);
oracleDataAdapter.Dispose();
}
catch (System.Data.OracleClient.OracleException ex)
{
throw new Exception(ex.Message);
}
finally
{
connection.Close();
}
return ds;
}DS总是空值
解决方案 »
- 怎么打包C#代码可执行文件!
- 有什么 办法可以让winform的窗口在双击标题栏时不最大化
- 4个panel如何共用一个上下文菜单
- 菜鸟问题!怎么得到从a.aspx到b.aspx传的request值?在线等~~~~
- SQL Server 2005 安装问题
- 正则表达式匹配问题....
- 为什么Vs2010里面不支持bringtofront()
- 用JAVA脚本发邮件,出现乱码问题,需要把utf-8编码转换成GB2312编码,请大虾指教!!UP有分,在线等候
- 请大家帮忙讨论,如何实现web应用程序和windows应用程序(后台)间进行通信!参与给分
- C# SilverLight 工程怎么连接数据库,如mysql或者SQL server数据库
- 难题!在反序列化的时候出现“在分析完成之前就遇到流结尾”
- 一个建立服务器和客户端的代码有没行不是很明白 哪位可以给我说一下
1、创建OracleDataAdapter时,指定
2、创建OracleCommand时指定,然后指定OracleDataAdapter的SelectCommand 为该OracleCommand
这个要复制 出来看看
1、创建OracleDataAdapter时,指定
2、创建OracleCommand时指定,然后指定OracleDataAdapter的SelectCommand 为该OracleCommand
LZ OracleCommand 没有指定连接的目标
OracleDataAdapter oracleDataAdapter = new OracleDataAdapter();
OracleCommand oracleSelectCommand = new OracleCommand();你connection没有和oracleDataAdapter 或oracleSelectCommand 关联,他们都没有连接。当然没有数据了。
using(OracleConnection con = new OracleConnection(""))
{
con.Open();
OracleCommand cmd=new OracleCommand("",con);
cmd.CommandType=CommandType.StoredProcedure;
OracleParameter p1=new OracleParameter("a",OracleType.Cursor);
p1.Direction=System.Data.ParameterDirection.Output;
cmd.Parameters.Add(p1);
OracleDataAdapter da=new OracleDataAdapter(cmd);
DataSet ds=new DataSet();
da.Fill(ds);
}