存储过程调用

 

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[Demo] 
	-- Add the parameters for the stored procedure here
	@sex varchar(50),
	@age int
AS
BEGIN
	declare @num int;
	set @num=(select count(*) from tb_userInfo where sex=@sex and age>=@age);
	return @num; 
END

C#代码调用过程

        string connectionString = "server=.;database=demo;uid=sa;pwd=root";
        using (SqlConnection conn = new SqlConnection(connectionString))
        {
            conn.Open();
            using(SqlCommand cmd=new SqlCommand("Demo",conn))
            {
                cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.Add("@sex", SqlDbType.VarChar, 50);
                cmd.Parameters["@sex"].Value = "男";
                cmd.Parameters["@sex"].Direction = ParameterDirection.Input;

                cmd.Parameters.Add("@age", SqlDbType.Int,4);
                cmd.Parameters["@age"].Value = 0;
                cmd.Parameters["@age"].Direction = ParameterDirection.Input;

                cmd.Parameters.Add("@num", SqlDbType.Int, 4);
                cmd.Parameters["@num"].Direction = ParameterDirection.ReturnValue;

                cmd.ExecuteNonQuery();
                int values = Convert.ToInt32(cmd.Parameters["@num"].Value);

                Response.Write(values);

            }
        }