hai,
I have stored procedure as follows
Alter PROCEDURE SP_CURRENCYLIST
@CURRENCYNAME VARCHAR(200)
AS
BEGIN
TRUNCATE TABLE TMCUR
INSERT INTO TMCUR VALUES (@CURRENCYNAME)
select * from TMCUR
END
GO
In my code-behind page:
connection.Open()
For Each listofcurrencies As CurrencyListRow In client.GetSupportedCurrencies
str = "exec SP_CURRENCYLIST"
mycommand = New SqlCommand(str, connection)
mycommand.Parameters.Add(New SqlParameter("@CURRENCYNAME", SqlDbType.VarChar, 200)).Value = listofcurrencies.CurrencyShortName
mycommand.ExecuteNonQuery()
Next
When i run my application it;s showing error as "Procedure
sp_currencylist" expects parameter @currencyname,which is not supplied."
Even i have supplied correc ...
Go to the complete details ...