Followng is my function and stored procedure. Issue us that data is not getting updated
protected void ImageButton2_Click1(object sender, ImageClickEventArgs e)
{
string data1 = Request.QueryString["Id"].ToString();
SqlCommand _cmd = new SqlCommand("editproduct", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cn.Open();
_cmd.Parameters.AddWithValue("@Name", proname.Text);
_cmd.Parameters.AddWithValue("@Model", promodel.Text);
_cmd.Parameters.AddWithValue("@Description", CKEditorControl1.Text);
_cmd.Parameters.AddWithValue("@id", data1);
_cn.Close();
Response.Redirect(Request.Url.AbsoluteUri);
}
ALTER procedure [dbo].[editproduct]
@Name nvarchar(30),@Model nvarchar(Max),@Description nvarchar(max)
,@id int,@behcode nvarchar(10)
as
begin
update House_p set Name=@Name,Model=@Model,Description=@Description,Date=GETDATE()
where id=@id
end