public bool RunProcedure(string ReturnParameter, CoreLab.Oracle.OracleDbType ParamType, ref DataSet Dataset, Hashtable HT, string ProcedureName)
{ CoreLab.Oracle.OracleConnection Connection =new CoreLab.Oracle.OracleConnection();
Connection.ConnectionString = this.DataAcc.OracleConnectionString;
Connection.Open(); CoreLab.Oracle.OracleCommand dacommand = new CoreLab.Oracle.OracleCommand();
dacommand.Connection = Connection; dacommand.CommandType = CommandType.StoredProcedure;
IDictionaryEnumerator Enumerator;
Enumerator = HT.GetEnumerator();
object Value = null;
CoreLab.Oracle.OracleParameter OracleParam;
OracleParam = dacommand.Parameters.Add(new CoreLab.Oracle.OracleParameter(ReturnParameter, ParamType));
OracleParam.Direction = ParameterDirection.Output; while (Enumerator.MoveNext())
{
Value = Enumerator.Value;
OracleParam = dacommand.Parameters.Add(new CoreLab.Oracle.OracleParameter(Enumerator.Key.ToString(), Value));
} CoreLab.Oracle.OracleDataAdapter ODAdapter = new CoreLab.Oracle.OracleDataAdapter(dacommand); try
{
ODAdapter.Fill(Dataset);
Close();
return true;
}
catch
{
Close();
return false;
}
finally
{
HT.Clear();
dacommand.Parameters.Clear();
}
}此种方式在访问System.Data.OracleClient方式下访问就可以,为什么在CoreLab.Oracle方式的时候就没有返回记录!哪位给看看
{ CoreLab.Oracle.OracleConnection Connection =new CoreLab.Oracle.OracleConnection();
Connection.ConnectionString = this.DataAcc.OracleConnectionString;
Connection.Open(); CoreLab.Oracle.OracleCommand dacommand = new CoreLab.Oracle.OracleCommand();
dacommand.Connection = Connection; dacommand.CommandType = CommandType.StoredProcedure;
IDictionaryEnumerator Enumerator;
Enumerator = HT.GetEnumerator();
object Value = null;
CoreLab.Oracle.OracleParameter OracleParam;
OracleParam = dacommand.Parameters.Add(new CoreLab.Oracle.OracleParameter(ReturnParameter, ParamType));
OracleParam.Direction = ParameterDirection.Output; while (Enumerator.MoveNext())
{
Value = Enumerator.Value;
OracleParam = dacommand.Parameters.Add(new CoreLab.Oracle.OracleParameter(Enumerator.Key.ToString(), Value));
} CoreLab.Oracle.OracleDataAdapter ODAdapter = new CoreLab.Oracle.OracleDataAdapter(dacommand); try
{
ODAdapter.Fill(Dataset);
Close();
return true;
}
catch
{
Close();
return false;
}
finally
{
HT.Clear();
dacommand.Parameters.Clear();
}
}此种方式在访问System.Data.OracleClient方式下访问就可以,为什么在CoreLab.Oracle方式的时候就没有返回记录!哪位给看看
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货