Author: itgalloway | Posted on: 10/10/2008 9:51:17 AM | Views : 429

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 ...