procedure getshipmap
(v_voyageid sellmap.voyageid%TYPE,
v_seatcls sellmap.seatcls%TYPE,
minXpos out NUMBER,
minYpos out NUMBER,
maxXpos out NUMBER,
maxYpos out NUMBER,
cur_shipmap out shipmap_cursor)
as
beginselect min(Xpos) into minXpos from sellmap where voyageid=v_voyageid and seatcls=v_seatcls;
select min(Ypos) into minYpos from sellmap where voyageid=v_voyageid and seatcls=v_seatcls;
select max(Xpos) into maxXpos from sellmap where voyageid=v_voyageid and seatcls=v_seatcls;
select max(Xpos) into maxYpos from sellmap where voyageid=v_voyageid and seatcls=v_seatcls;open cur_shipmap for
select * from sellmap where voyageid=v_voyageid and seatcls=v_seatcls order by Ypos,Xpos;end getshipmap; 如果是单一返回值,或单一经cursor返回dataset的话就没问题,
但如果要像上面那面同时返回值与数据集的话,在C#中应该怎样操作?
(v_voyageid sellmap.voyageid%TYPE,
v_seatcls sellmap.seatcls%TYPE,
minXpos out NUMBER,
minYpos out NUMBER,
maxXpos out NUMBER,
maxYpos out NUMBER,
cur_shipmap out shipmap_cursor)
as
beginselect min(Xpos) into minXpos from sellmap where voyageid=v_voyageid and seatcls=v_seatcls;
select min(Ypos) into minYpos from sellmap where voyageid=v_voyageid and seatcls=v_seatcls;
select max(Xpos) into maxXpos from sellmap where voyageid=v_voyageid and seatcls=v_seatcls;
select max(Xpos) into maxYpos from sellmap where voyageid=v_voyageid and seatcls=v_seatcls;open cur_shipmap for
select * from sellmap where voyageid=v_voyageid and seatcls=v_seatcls order by Ypos,Xpos;end getshipmap; 如果是单一返回值,或单一经cursor返回dataset的话就没问题,
但如果要像上面那面同时返回值与数据集的话,在C#中应该怎样操作?
解决方案 »
- 如何用C#.net绘制象Excel的曲面图
- 彻底晕倒 重新开帖 关于静态构造函数
- 請問怎樣能改變Datatable的數劇列的排列順序
- 类型化的DataSet里的自动编号,与数据源的自动编号不一致,
- winForm里的treeView事件问题。
- 求助.GetType().GetProperty(column.ColumnName)获取不到值。
- 请教关于注册C#开发的DLL问题
- 在vs.net2003中using System.Windows时没有Windows类怎么办?
- 封装数据库访问层,支持多数据库。
- 关于 BeginUpdate() 与 EndUpdate() 的问题
- c# gridview数据绑定的问题
- 界面设计生成哪些代码
{
myStr=xxxx;//返回单个值
return 某一个DataSet;//返回DataSet
}
返回临时表
或设置返回值为数据集