SqlDataAdapter 存储过程使用

  protected void Page_Load(object sender, EventArgs e)
        {
            string connstr = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["SampleDBConnectionString"].ConnectionString;

            using (SqlConnection conn = new SqlConnection(connstr))
            {
          
                SqlDataAdapter dr = new SqlDataAdapter("selectall",conn);
                dr.SelectCommand.CommandType = CommandType.StoredProcedure;

                SqlParameter spr = new SqlParameter("@count", SqlDbType.Int);
                spr.Direction = ParameterDirection.Output;
                dr.SelectCommand.Parameters.Add(spr);

           

                SqlParameter spr2 = new SqlParameter("@min", SqlDbType.Int);
                spr2.Direction = ParameterDirection.Output;
                dr.SelectCommand.Parameters.Add(spr2);

                SqlParameter spr3 = new SqlParameter("@max", SqlDbType.Int);
                spr3.Direction = ParameterDirection.Output;
                dr.SelectCommand.Parameters.Add(spr3);

           

                DataSet ds = new DataSet() ;
                dr.Fill(ds);
                GridView1.DataSource = ds;
                GridView1.DataBind();
                Response.Write(spr.Value + "<br/>" + spr2.Value + "<br/>" + spr3.Value);
                conn.Close ();

            }
        }

 

================存储过程================================

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[selectall]
 -- Add the parameters for the stored procedure here
@count int output,
@max int output,
@min int output
AS
BEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from
 -- interfering with SELECT statements.
 SET NOCOUNT ON;

    -- Insert statements for procedure here
 select @count = count(id) ,@max=max(Age),@min = min(age) from   users;
SELECT * FROM  users;
return @@rowcount;
END