调用存储过程返回DataSet
public static DataSet UseStoredProcedure(string strsp)
{
DataSet data = new DataSet();
SqlConnection con = new SqlConnection(connectionString);
SqlCommand cmd = new SqlCommand(strsp, con);
try
{
CheckConnection(con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(data);
return data;
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message);
return data;
}
finally
{
CheckConnection(con);
}
}
/// <summary>
/// 检查连接状态
/// </summary>
/// <param name="con"></param>
private static void CheckConnection(SqlConnection con)
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
else if (con.State == ConnectionState.Open)
{
con.Close();
con.Dispose();
}
}
这是我写的 感觉没错啊,数据库也连接上了 存储过程没问题,就是无法得到数据集