Question

大虾，给个调用c#存储过程返回DataSet的例子，谢谢~~

Answer 1

/// <summary>
/// 执行查询存储过程
/// </summary>
/// <param name="strproc">存储过程名称</param>
/// <returns></returns>
public DataSet GetProcData(string strproc)
{
SqlCommand scmd = new SqlCommand(strproc,sqlcon);
scmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = scmd;
DataSet ds = new DataSet();
sda.Fill(ds);
return ds;
}