Grid Delete is not working(DeleteCommandType="StoredProcedure") plz Help?
-
i got SP that is working fine ,i checked it in the SQL serever ,but it is not working with the Grid ,i tried changing the parameter name but it didnt work , here is the ASP code -------------------------------------------------------------------------- <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:APServerConnectionString1 %>" DeleteCommand="Multiple_Delete" SelectCommand="SELECT PROC_INST_ID, PROC_INST_NAME, DEF_NAME FROM WF_PROC_INSTS" DeleteCommandType="StoredProcedure"> <DeleteParameters> <asp:Parameter Name="_PROC_INST_ID" /> </DeleteParameters> </asp:SqlDataSource> ----------------------------------------------------------------------- is there anything wrong here? ThnX
-
i got SP that is working fine ,i checked it in the SQL serever ,but it is not working with the Grid ,i tried changing the parameter name but it didnt work , here is the ASP code -------------------------------------------------------------------------- <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:APServerConnectionString1 %>" DeleteCommand="Multiple_Delete" SelectCommand="SELECT PROC_INST_ID, PROC_INST_NAME, DEF_NAME FROM WF_PROC_INSTS" DeleteCommandType="StoredProcedure"> <DeleteParameters> <asp:Parameter Name="_PROC_INST_ID" /> </DeleteParameters> </asp:SqlDataSource> ----------------------------------------------------------------------- is there anything wrong here? ThnX
-
Aren't we suppose to define sp name in sqldatasource attibutes?
Please don't forget to mark 'Good Answer', if you find it really a good one! Kashif