게시판 본문 ASP, ASP.NET, IIS & Script - Read Only

public DataSet ExecuteDataSet_OutPut(string sql, Hashtable htInPut, CommandType cmdType, out Hashtable htOutPut)
{
ds = new DataSet();
htOutPut = new Hashtable();
try
{
using ( SqlCommand oCmd = new SqlCommand() )
{
oCmd.Connection = oConn;
oCmd.CommandType = cmdType;
oCmd.CommandText = sql;

#region 아웃풋 , 리턴 벨류 이름 얻어와 나머지 파라미터는 다시 삭제
SqlCommandBuilder.DeriveParameters(oCmd); //프로시져에서 모든 파라미터를 얻어온다

ArrayList alOutPutParamName = new ArrayList(oCmd.Parameters.Count);
ArrayList alOutPutParamName_remove = new ArrayList();

int i = 0 , j = 0;
foreach ( SqlParameter param in oCmd.Parameters ) //아웃풋으로된 모든것들의 이름을 빼온다
{
if ( param.Direction == ParameterDirection.Output || param.Direction == ParameterDirection.InputOutput || param.Direction == ParameterDirection.ReturnValue )
{
alOutPutParamName.Add(param.ParameterName);
i += 1;
}
else
{
alOutPutParamName_remove.Add(param.ParameterName);
j += 1;
}
}

for ( int k = 0 ; k < j ; k++ )
{
oCmd.Parameters.RemoveAt(alOutPutParamName_remove[k].ToString());
}
#endregion

if ( htInPut.Count > 0 )
{
foreach ( string keyString in htInPut.Keys )
{
SqlParameter param = new SqlParameter();
param.ParameterName = "@" + keyString;
param.Value = htInPut[keyString].ToString();
oCmd.Parameters.Add(param);
}
}

using ( SqlDataAdapter oDa = new SqlDataAdapter(oCmd) )
{
oDa.Fill(ds);
}

string strOutPutParamName_rename = string.Empty;
for ( int k = 0 ; k < i ; k++ )
{
strOutPutParamName_rename = alOutPutParamName[k].ToString().Remove(0, 1); //앞에 @를 빼고
if ( !strOutPutParamName_rename.ToUpper().Equals("RETURN_VALUE") ) //아웃풋이면
{
htOutPut.Add(strOutPutParamName_rename, oCmd.Parameters[alOutPutParamName[k].ToString()].Value.ToString());
}
else
{
htOutPut.Add(strOutPutParamName_rename, oCmd.Parameters[alOutPutParamName[k].ToString()].Value.ToString());
}
}
}
}
catch ( SqlException ex )
{
SqlErrors(ex);
}
return ds;
}