请问高手，怎样调用存储过程返回数据集？急啊！！！

tob 2003-07-30 02:05:59

在oracle建立了一个包，包里有一个test1的存储过程，怎么用asp.net(c#)调用存储过程返回数据集，并写到datagrid里？
create or replace package Test1 is
type rs is ref cursor;
PROCEDURE getYhRs(ydm in varchar, yhrs out rs);
end Test1;

create or replace package body Test1 is

PROCEDURE getYhRs(ydm in varchar, yhrs out rs) as

begin
open yhrs for select * from t_yonghu WHERE yhdm=ydm;
end;
end Test1;

...全文

21 8 打赏收藏举报

写回复

8 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

tob 2003-07-30

打赏
举报

谢谢大家！但好像都不行，我的存储过程写在包里，而且要返回数据集

liuzhonghe 2003-07-30

打赏
举报

看一下SDK的SqlCommand类，关于它的用法里面的有详细的例子。

xu0007 2003-07-30

打赏
举报

sql 的
storedProcName：存储过程名称 parameters：参数集 tableName：返回的表名
public DataSet RunProcedure(string storedProcName, IDataParameter[] parameters, string tableName )
{
DataSet dataSet = new DataSet();
SqlDataAdapter sqlDA = new SqlDataAdapter();
sqlDA.SelectCommand = BuildQueryCommand( storedProcName, parameters );
sqlDA.Fill( dataSet, tableName );
return dataSet;
}

greystar 2003-07-30

打赏
举报

public DataSet ExeForSp(string sqname, string [,] array )
{
try
{
DataSet dset =new DataSet();
SqlDataAdapter dp=new SqlDataAdapter();

SqlCommand cmmd = new SqlCommand();
dp.SelectCommand=cmmd;
dp.SelectCommand.Connection =this.conn;
dp.SelectCommand.CommandType=CommandType.StoredProcedure;
dp.SelectCommand.CommandText =sqname;
for(int i=0;i<=array.GetUpperBound(0);i++)
{

if(array[i,0]!=null)
{
SqlParameter Parm = dp.SelectCommand.Parameters.Add( array[i,0].ToString(), SqlDbType.NVarChar);
Parm.Value =array[i,1].ToString();
}
}
dp.Fill(dset);
return dset;
}
catch(System.Exception e)
{
throw e;
}
}

yohomonkey 2003-07-30

打赏
举报

有Sql的：
Public Function RunStoreProcReturn(ByVal sStoreProduceName As String, Optional ByRef colParms As Collection = Nothing) As DataSet
StrSqlConn = New SqlConnection(STRCONN)
Dim ds As New DataSet()
Dim sqlAdapt As New SqlDataAdapter()
Dim sqlCMD As New SqlCommand(sStoreProduceName, StrSqlConn)
sqlCMD.CommandType = CommandType.StoredProcedure
If Not IsNothing(colParms) Then
Dim oParm As SqlClient.SqlParameter
For Each oParm In colParms
sqlCMD.Parameters.Add(oParm)
Next
End If

Try
StrSqlConn.Open()
sqlAdapt.SelectCommand = sqlCMD
sqlAdapt.Fill(ds)
Return ds
Catch e As Exception

Finally
StrSqlConn.Close()
End Try
End Function