执行带查询集，有输入输出参数的存储过程

/// <summary>
/// 执行存储过程，查询数据
/// </summary>
/// <param name="para"></param>
/// <param name="commandtext"></param>
/// <returns></returns>
public static DataSet GetDataSetByStoredProcedure(SqlParameter[] para, string commandtext)
{

para[11].Direction = ParameterDirection.Output;
using (SqlConnection sqlconn = new SqlConnection(strConn))
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlconn;
cmd.CommandText = commandtext;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(para);
sqlconn.Open();

SqlDataAdapter dp = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
// 填充dataset
dp.Fill(ds);

string result = para[11].Value.ToString();
return ds;
}
catch (Exception ex)
{
return null;
}
finally
{
sqlconn.Close();
}
}
}

执行带查询集，有输入输出参数的存储过程

原文：https://www.cnblogs.com/simoncheung/p/11910207.html