sql exception occurs checked various times but it shows

#my Dal

public void UpdateProductDetail(EntityClass en)

{

SqlConnection conn = new SqlConnection(constring);

try

{

conn.Open();

SqlCommand cmd = new SqlCommand("spUpdateProductDetails", conn);

cmd.Parameters.AddWithValue("@prodName", DbType.String).Value = en.ProductName;

cmd.Parameters.AddWithValue("@productId", DbType.Int32).Value = en.ProductId;

cmd.Parameters.AddWithValue("@productDesc", DbType.String).Value = en.ProductDescription;

cmd.Parameters.AddWithValue("@categoryId", DbType.Int32).Value = en.CategoryId;

cmd.Parameters.AddWithValue("@price", DbType.Int32).Value =en.Price;

cmd.Parameters.AddWithValue("@availability", DbType.String).Value = en.Availability;

cmd.ExecuteNonQuery();

}

catch(Exception)

{

throw new Exception("");

}

#code behind

protected void grdView1ProductUpdate(object sender, GridViewUpdateEventArgs e)

{

TextBox txtProductName = grdView1.Rows[e.RowIndex].FindControl("txtProductName") as TextBox;

TextBox txtProductId = grdView1.Rows[e.RowIndex].FindControl("txtProductId") as TextBox;

TextBox txtProductDesc = grdView1.Rows[e.RowIndex].FindControl("txtProductDesc") as TextBox;

TextBox txtCategoryId = grdView1.Rows[e.RowIndex].FindControl("txtCategoryId") as TextBox;

TextBox txtPrice = grdView1.Rows[e.RowIndex].FindControl("txtPrice") as TextBox;

TextBox txtAvailability = grdView1.Rows[e.RowIndex].FindControl("txtAvailability") as TextBox;

EntityClass en=new EntityClass(txtProductName.Text,Convert.ToInt32(txtProductId.Text),txtProductDesc.Text,Convert.ToInt32(txtCategoryId.Text),Convert.ToInt32(txtPrice.Text),txtAvailability.Text);

bll.UpdateProductDetail(en);

grdView1.EditIndex=-1;

ShowGrid();

}

#my stored procedure

alter procedure[dbo].[spUpdateProductDetails]

@prodName as nvarchar(50),

@productId as int,

@productDesc as nvarchar(50),

@categoryId as int,

@price as int,

@availability as nvarchar(50)

begin

update ProductDetail set ProductName=@prodName,ProductDescription=@productDesc,CategoryId=@categoryId,Price=@price,Availability=@availability where ProductId=@productId

end

#exception im getting is

Procedure or function 'spUpdateProductDetails' expects parameter '@prodName', which was not supplied.

# correct me where iam wrong

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel9y ago
Look at below code to find out of your text box value is coming back or it is null.
Please check the constructor for Entity class. Is that setting the productname on the entity object?
EntityClass en=new EntityClass(txtProductName.Text,Convert.ToInt32(txtProductId.Text),txtProductDesc.Text,Convert.ToInt32(txtCategoryId.Text),Convert.ToInt32(txtPrice.Text),txtAvailability.Text);
Ravi Patel9y ago
Hi ,

remove the as key word from stored procedure

try this

alter procedure[dbo].[spUpdateProductDetails]
@prodName nvarchar(50),
@productId int,
@productDesc nvarchar(50),
@categoryId int,
@price int,
@availability nvarchar(50)
as
begin
update ProductDetail set ProductName=@prodName,ProductDescription=@productDesc,CategoryId=@categoryId,Price=@price,Availability=@availability where ProductId=@productId
end