Calling StorageProcedure

[Devinim ÞÖLEN]

Hi;

How can I solve following problem ?

When I try to call SP from DataGrid update event, getting following errors :

Procedure or function Ch_Hm_Sp_Test has too many arguments specified.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Procedure or function
Ch_Hm_Sp_Test has too many arguments specified.


You can see my SP as follows;


create procedure Ch_Hm_Sp_Test
@Id int
as
return 0

GO


and, my ASP script is;

<asp:SqlDataSource ID="m_ChSqlDataSource" SelectCommand="Ch_Hm_Sp_Test"
UpdateCommand="Ch_Hm_Sp_Test" ConnectionString="<%$
ConnectionStrings:AppConnectionString %>" Runat="server">

<UpdateParameters>

<asp:QueryStringParameter Name="Id" QueryStringField="Id"
Type="Int32"></asp:QueryStringParameter>

</UpdateParameters>

<SelectParameters>

<asp:QueryStringParameter Name="Id" QueryStringField="Id"
Type="Int32"></asp:QueryStringParameter>

</SelectParameters>

</asp:SqlDataSource>

Thanks
--
Devinim ÞÖLEN

TO - Technology Services

Global Bilgi Paz., Dan. ve Çaðrý Servisi Hiz. A.Þ.

Fatih C. Dereboyu S. No:8 34660 Halkalý-Ýstanbul/Türkiye
GSM : +90 (532) 555 5500
Tel : +90 (212) 473 2020
Fax : +90 (533) 981 4653