过程或函数 'GetMaxMinDateTime' 需要参数 '@MaxDateTime'，但未提供该参数。

SQL code

USE [Gethome]GO/****** Object:  StoredProcedure [dbo].[GetMaxMinDateTime]    Script Date: 05/23/2012 08:33:38 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:        查询一个用户的日志，日志，活动，照片这四个中日期最小的一个和最小-- Create date: 2012-05-22-- Description:    查询一个用户的日志，日志，活动，照片这四个中日期最小的一个和最小的时间-- =============================================ALTER PROCEDURE  [dbo].[GetMaxMinDateTime]@ClanID int,--家族的ID@MaxDateTime datetime OUT,--最大时间返回出去@MinDateTime datetime OUT--最小时间返回出去ASBEGIN   Declare @MaxDate datetime--储存这四个中最大时间   declare @MinDate datetime--储存这四个最小时间   declare @guodu datetime--时间过度   select top 1 @MinDate=HappeTime from GH_Event where ClanID=@ClanID order by HappeTime--取得大事记的最小时间   select top 1 @guodu=B.PostTime from dbo.GH_Blog as B INNER JOIN  dbo.GH_UserInfo AS U ON B.UserID=U.UserID where U.ClanID=@ClanID order by PostTime   IF @guodu<@MinDate--把日志的最小时间取出之后开始对比时间大小    BEGIN--如果过度时间没有最小时间大就把过度时间赋值给最小时间        set @MinDate=@guodu    end   select top 1 @guodu=BeginTime from GH_Activity where ClanID=@ClanID order by BeginTime      IF @guodu<@MinDate    BEGIN        set @MinDate=@guodu    end    select top 1 @guodu=P.PostTime from  dbo.GH_Photo as P INNER JOIN  dbo.GH_UserInfo AS U ON P.UploadUser=U.UserID WHERE U.ClanID=@ClanID  order by PostTime    IF @guodu<@MinDate    BEGIN        set @MinDate=@guodu        SET @MinDateTime=@MinDate    end               select top 1 @MaxDate=HappeTime from GH_Event where ClanID=@ClanID order by HappeTime desc   select top 1 @guodu=B.PostTime from dbo.GH_Blog as B INNER JOIN  dbo.GH_UserInfo AS U ON B.UserID=U.UserID where U.ClanID=@ClanID order by PostTime desc   IF @guodu>@MaxDate    BEGIN        set @MaxDate=@guodu    end   select top 1 @guodu=BeginTime from GH_Activity where ClanID=@ClanID order by BeginTime desc      IF @guodu>@MaxDate    BEGIN        set @MaxDate=@guodu    end    select top 1 @guodu=P.PostTime from  dbo.GH_Photo as P INNER JOIN  dbo.GH_UserInfo AS U ON P.UploadUser=U.UserID WHERE U.ClanID=@ClanID  order by PostTime desc    IF @guodu>@MaxDate    BEGIN        set @MaxDate=@guodu        SET @MaxDateTime=@MaxDate    endEND

我第一次写存储过程代码可能会有点多余。现在写了半天一直报错。也不知怎么改了。大哥大姐帮帮忙

C# code

       SqlParameter[] param = new SqlParameter[3];            param[0] = new SqlParameter("@ClanID", ClanID);                    param[1] = new SqlParameter("@MaxDateTime", "2000-01-01");            param[1].Direction = ParameterDirection.ReturnValue;            param[2] = new SqlParameter("@MinDateTime", "2000-01-01");            param[2].Direction = ParameterDirection.ReturnValue;                       DbHelper.ExecuteScalar(CommandType.StoredProcedure, "GetMaxMinDateTime", param);            string[] lostTime = new string[2];            lostTime[0] = param[1].Value.ToString();            lostTime[1] = param[2].Value.ToString();

就是获取一个最大时间一个最小时间

[解决办法]
param[1].Direction = ParameterDirection.Output;