c#调用存储过程的问题

[hya0114145]

 public static int ChiDao(string name, DateTime mintime,DateTime maxtime)
        {
            try
            {
                SqlParameter[] par = new SqlParameter[]
                {
                    new SqlParameter("@name",SqlDbType.VarChar).Value=name,
                    new SqlParameter("@datemin",SqlDbType.DateTime).Value=mintime,
                    new SqlParameter("@datemax",SqlDbType.DateTime).Value=maxtime,
                    new SqlParameter("@shuchu",SqlDbType.Int).Direction=ParameterDirection.Output
                };
                DBHelper.ExecuteCommand("chaxunchidao",par);
                
                
            }
            catch (Exception)
            {
                
                throw;
            }

 public static void ExecuteCommand(string name, SqlParameter[] paramArray)
    {
        using (conn = new SqlConnection(SqlConn))
        {
            try
            {
                command = new SqlCommand();
                command.CommandText = name;
                command.Connection = conn;
                command.CommandType = CommandType.StoredProcedure;
                for (int i = 0; i < paramArray.Length; i++)
                {
                    command.Parameters.Add(paramArray[i]);
                }
                conn.Open();
                command.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                throw e;
            }
        }

    }

在ChiDao中怎样返回@shuchu的值

[downmoon]

http://topic.csdn.net/u/20080717/17/7cca1510-c690-48ef-99bd-2991becb86d4.html

[amingo]

执行完后par [2].value

[Zeteyu]

return (int)par[3].Value;

[xingboat]

command.ExecuteNonQuery();後面加
return (int)command.Parameters["@shuchu"].Value;
---樓主可以結貼了。。