急！存储过程的结果放到DataSet中怎么不对？

[wengyz]

代码如下：
dsCommand.SelectCommand = myOdbcConnection.CreateCommand()
dsCommand.SelectCommand.Parameters.Add(FOLDERID_PARM, OdbcType.Int)
dsCommand.SelectCommand.Parameters(FOLDERID_PARM).Value = FolderID
dsCommand.SelectCommand.CommandText = "fmLoadDoc ?"
dsCommand.SelectCommand.CommandType = CommandType.StoredProcedure
dsCommand.SelectCommand.ExecuteNonQuery()
Dim data As New FileData
'dsCommand.Fill(data)

Dim data As New DataSet
Dim commandAdp As New OdbcDataAdapter
commandAdp.SelectCommand = dsCommand.SelectCommand
Try
commandAdp.Fill(data)
Catch ex As Exception
Throw New ApplicationException(ex.ToString())
End Try
执行fill的时候很慢。执行后也没有报错，然后检查data为空

[impeller]

dsCommand.SelectCommand.CommandText = "fmLoadDoc ?"
怎么有个?

设个断点跟踪下FolderID的值，然后拿到查询分析器中执行，看看有没有错

[wengyz]

加？是sybase调用存储过程的写法。存储过程结果没错

[boby168]

原因如下：
多执行了如下语句：
dsCommand.SelectCommand.ExecuteNonQuery()

ExecuteNonQuery需要OdbcConnection打开执行后，需要显式关闭OdbcConnection。
如myOdbcConnection.Close();


OdbcDataAdapter的Fill方法执行后会自动关闭。

试试如下代码：

dsCommand.SelectCommand = myOdbcConnection.CreateCommand()
dsCommand.SelectCommand.Parameters.Add(FOLDERID_PARM, OdbcType.Int)
dsCommand.SelectCommand.Parameters(FOLDERID_PARM).Value = FolderID
dsCommand.SelectCommand.CommandText = "fmLoadDoc ?"
dsCommand.SelectCommand.CommandType = CommandType.StoredProcedure

‘dsCommand.SelectCommand.ExecuteNonQuery()
‘Dim data As New FileData
’dsCommand.Fill(data)

Dim data As New DataSet
Dim commandAdp As New OdbcDataAdapter
commandAdp.SelectCommand = dsCommand.SelectCommand
Try
commandAdp.Fill(data)
Catch ex As Exception
Throw New ApplicationException(ex.ToString())
End Try

[fanliang11]

一看就写错拉

[fanliang11]

看我写的代码模仿一下,你的代码好象写的不对
SqlConnection sc=this.getSqlConnection();
sc.Open();
SqlCommand sm=sc.CreateCommand();
//sm.Connection=sc;
sm.CommandText=procName;
sm.CommandType=CommandType.StoredProcedure;

foreach(SqlParameter s in sp)
{
sm.Parameters.Add(s);
}
SqlDataAdapter sda=new SqlDataAdapter();
sda.SelectCommand=sm;
DataSet ds=new DataSet();
sda.Fill(ds);
int i=ds.Tables[0].Rows.Count;
sc.Close();
return ds;

[活靶子哥哥]

你在查询分析器内执行你的过程看有结果没
然后检查你的调用
你的过程名有 问号吗?