Overload resolution failed because no accessible 'New' accepts this number of arguments.
Th error is on line 22
Line 21: DIM PrizeNameParameter as string
Line 22: PrizeNameParameter = new SqlParameter("@PrizeName" 0)
Line 23: PrizeNameParameter.Direction = ParameterDirection.Output
Line 24: cmd.Parameters.Add(PrizeNameParameter)
I am trying to get the output of a stored procedure. The output is a VARCHAR data type.
Public Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles submit.Click
Try
Dim cmd As New SqlCommand("promo_GetPrize", New SqlConnection(ConfigurationManager.AppSettings("strConn")))
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.AddWithValue("@PromoCode", txtPromoCode.Text)
cmd.Parameters.AddWithValue("@userID", 5)
DIM PrizeNameParameter as string
PrizeNameParameter = new SqlParameter("@PrizeName" 0)
PrizeNameParameter.Direction = Param ...
Go to the complete details ...