--存储过程2 create proc Test2 as select top 1 * from spt_monitor return 3 SqlConnection con = new SqlConnection("server=.;database=master;uid=sa;pwd=;"); con.Open(); SqlCommand cmd = new SqlCommand("Test2",con); //指定操作为执行存储过程 cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@RETURN", SqlDbType.Int)); //获取存储过程返回值 cmd.Parameters["@RETURN"].Direction = ParameterDirection.ReturnValue; //获取存储过程数据集合 SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { Response.Write("存储过程数据集合:" + dr[0].ToString()); } dr.Close(); con.Close(); Response.Write("<br/>存储过程返回值:" + cmd.Parameters["@RETURN"].Value.ToString());