Hi all,
I'm trying to add update funtionality to my gridiview with zero success. I am using a stored proc and passing 2 parameters to it. This is the error message "The procedure or function has 2 many arguments specified"
Stored Proc
CREATE PROCEDURE [dbo].[usp_UpdateInvoice]
@PAIDDATE VARCHAR(50),
@ORDERNUMBER VARCHAR(50)
AS
UPDATE dbo.ORDER_HEADER
SET PAID_DATE = CONVERT(DATETIME, @PAIDDATE, 103)
WHERE ORDERNUMBER = @ORDERNUMBER HTML
<asp:SqlDataSource ID="dsOrders" runat="server" Go to the complete details ...