ASP.NET coding 问题.

alice8609

每当我按delete button 时就会一直出现
"Must declare the variable '@TASK_TYPE.'"

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStringsonnectionString %>"
   DeleteCommand="DELETE FROM [TLS_DURATION] WHERE [PROCESS] = @PROCESS AND [TASK_TYPE] = @TASK_TYPE) AND [TASK_SUB_TYPE] = @TASK_SUB_TYPE" >

<DeleteParameters>
             <asparameter Name="ROCESS" Type="String" />
             <asparameter Name = "TASK_TYPE" Type= "String " />
             <asparameter Name = "TASK_SUB_TYPE" Type= "String" />
        </DeleteParameters>
        </asp:SqlDataSource>

可是我已经 declare parameter 了..还是这样, 那里出了问题??
请大家帮帮我..
感激不尽

pavelbk

cmd.Parameters.Add("@TASK_TYPE", SqlDbType.NVarChar, 10)
  cmd.Parameters("@TASK_TYPE".Value = 'bak bak'

是 @TASK_TYPE, 不是 TASK_TYPE