结合ASP.NET的GridView到Oracle SYS_REFCURSOR [英] Binding ASP.NET GridView to an Oracle SYS_REFCURSOR
本文介绍了结合ASP.NET的GridView到Oracle SYS_REFCURSOR的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我们在甲骨文返回我们要绑定到ASP.NET GridView控件的数据的SYS_REFCURSOR的输出参数的过程。我见过这样做过,但我找不到我用来解决问题的原件备查。
下面是具体的步骤是什么样子:
创建或替换PROCEDURE GETSOMEDATA
(
P_DATA OUT SYS_REFCURSOR
)
如
开始
OPEN FOR P_DATA SELECT * FROM SOMETABLE;
END GETSOMEDATA;
和现在在GridView仅仅是最基本的:
< ASP:GridView控件ID =grdData=服务器的AutoGenerateColumns =真>< / ASP:GridView的>
解决方案
尝试是这样的:(没有指定哪一种语言)
公共功能GetSomeData()作为数据表
昏暗OrclConn作为新的OracleConnection(的ConnectionString)
昏暗OrclCmd作为新的OracleCommand(GETSOMEDATA,OrclConn)
OrclCmd.CommandType = CommandType.StoredProcedure
OrclCmd.Parameters.Add(P_DATA,OracleType.Cursor).Direction = ParameterDirection.Output'或ParameterDirection.ReturnValue 昏暗OrclDA作为新OracleDataAdapter(OrclCmd)
昏暗RtnTable如数据表
OrclConn.Open
OrclDA.Fill(RtnTable)
OrclConn.Close 返回RtnTable
结束功能
We have a Procedure in Oracle with a SYS_REFCURSOR output parameter that returns the data we want to bind to an ASP.NET GridView control. I've seen this done before but I can't find the original reference I used to solve the problem.
Here is what the procedure looks like:
create or replace PROCEDURE GETSOMEDATA
(
P_Data OUT SYS_REFCURSOR
)
AS
BEGIN
OPEN P_Data FOR SELECT * FROM SOMETABLE;
END GETSOMEDATA;
And for now the GridView is just bare-bones:
<asp:GridView ID="grdData" runat="server" AutoGenerateColumns="true"></asp:GridView>
解决方案
Try something like: (didn't specify which language)
Public Function GetSomeData() as DataTable
Dim OrclConn as New OracleConnection("Connectionstring")
Dim OrclCmd as New Oraclecommand("GETSOMEDATA", OrclConn)
OrclCmd.CommandType = CommandType.StoredProcedure
OrclCmd.Parameters.Add("P_Data", OracleType.Cursor).Direction = ParameterDirection.Output 'Or ParameterDirection.ReturnValue
Dim OrclDA as New OracleDataAdapter(OrclCmd)
Dim RtnTable as DataTable
OrclConn.Open
OrclDA.Fill(RtnTable)
OrclConn.Close
Return RtnTable
End Function
这篇关于结合ASP.NET的GridView到Oracle SYS_REFCURSOR的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文