I am Working on my project, And frustrated to solve this error. " Procedure or function uspSetSubscriptions has too many arguments specified". If any one knows please help.
protected void BtnSubscribe_Click(object sender, EventArgs e)
{
try
{
db1.sqlcmd = new SqlCommand("uspSetSubscriptions");
using (SqlDataAdapter sda = new SqlDataAdapter())
{
db1.sqlcmd.CommandType = CommandType.StoredProcedure;
db1.sqlcmd.Parameters.Clear();
db1.sqlcmd.Parameters.AddWithValue("@UserID", Convert.ToInt32(AppUserID));
db1.sqlcmd.Parameters.AddWithValue("@packageType", Convert.ToString(ViewState["packtype"]));
db1.sqlcmd.Parameters.AddWithValue("@Cost", Convert.ToDouble(ViewState["packagecost"]));
db1.sqlcmd.Parameters.AddWithValue("@MaxNotific", Convert.ToInt32(ViewState["mxnotificaton"]));
db1.sqlcmd.Parameters.AddWithValue("@MaxVideos", Convert.ToInt32(ViewState["mxvidoes"]));
db1.sqlcmd.Parameters.AddWithValue("@MaxArticles", Convert.ToInt32(ViewState["mxarticles"]));
db1.sqlcmd.Parameters.AddWithValue("@MaxEvent", Convert.ToInt32(ViewState["mxevents"]));
db1.sqlcmd.Parameters.AddWithValue("@MaxAllias", Convert.ToInt32(ViewState["mxallias"]));
db1.sqlcmd.Parameters.AddWithValue("@ConstID", Convert.ToInt32(DDConstituency.SelectedValue));
db1.sqlcmd.Parameters.Add("@Identity", SqlDbType.Int);
db1.sqlcmd.Parameters["@Identity"].Direction = ParameterDirection.Output;
db1.sqlcmd.Connection = db1.sqlcon;
db1.sqlcon.Open();
db1.sqlcmd.ExecuteNonQuery();
Subscripid = Convert.ToInt32(db1.sqlcmd.Parameters["@Identity"].Value);
ViewState["Subscripid"] = Subscripid;
}
}
catch (Exception ex){ Response.Write(ex.Message); }
finally {db1.sqlcon.Close(); }
}
Create Proc uspSetSubscriptions
@packageType varchar(25), @UserID int, @ConstID int,
@MaxNotific int, @MaxArticles int, @MaxVideos int,@MaxEvent int,@MaxAllias int,@Cost float,@Identity int OUT
AS
BEGIN
DECLARE @PackageId int
SELECT @PackageId = PackageID FROM TblPackages WHERE Category = @packageType
INSERT INTO TblSubscription(UserId, PackageId, ConstID, StartDate, FinishDate, MaxNotification, MaxArticles, MaxVideos, MaxEvent, MaxAllias, IsActive, IsPaid)
VALUES(@UserID,@PackageId,@ConstID,GetDate(),GETDATE()+30,@MaxNotific,@MaxArticles,@MaxVideos,@MaxEvent,@MaxAllias,0,0)
SET @Identity = SCOPE_IDENTITY()
END