ALTER proc [dbo].[usp_AppendInfo]

@insertCount int =0 output,

@updateCount int =0 output

as

                             SqlConnection sqlconn = new SqlConnection(strConn);

                                SqlCommand cmd = new SqlCommand();

                                cmd.Connection = sqlconn;

                                cmd.CommandText = "usp_AppendInfo";

                                cmd.CommandType = CommandType.StoredProcedure;

                                // 创建参数

                                IDataParameter[] parameters = {

                 new SqlParameter("@insertCount", SqlDbType.Int,4) ,

                 new SqlParameter("@updateCount", SqlDbType.Int,4) ,

             };

                                // 设置参数类型

                                parameters[0].Direction = ParameterDirection.Output;

                                parameters[1].Direction = ParameterDirection.Output;



                                // 添加参数

                                cmd.Parameters.Add(parameters[0]);

                                cmd.Parameters.Add(parameters[1]);