Hi siamandm,
I have modified your code as well as stored procedure.
C#
protected void btnEdit_Click(object sender, EventArgs e)
{
Session["Grid_ID"] = GRIDASSET.SelectedDataKey.Value;
try
{
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = "SP_EditAsset";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Asset_ID", Convert.ToInt32(Session["Grid_ID"]));
cmd.Parameters.AddWithValue("@Asset_Name", txtAssetName.Text);
cmd.Parameters.AddWithValue("@Asset_SN", txtAssetSN.Text);
cmd.Parameters.AddWithValue("@Asset_Make", ddlMake.SelectedValue);
cmd.Parameters.AddWithValue("@Asset_Model", ddlModel.SelectedValue);
cmd.Parameters.AddWithValue("@Emp_ID", ddlEmpList.SelectedValue);
cmd.Parameters.AddWithValue("@Asset_Status", ddlAssetStatus.SelectedValue);
con.Open();
SqlDataReader V = cmd.ExecuteReader();
con.Close();
lblmsg.Text = "Asset Update!!";
}
catch
{
}
}
SQL
/****** Object: StoredProcedure [dbo].[SP_EditAsset] Script Date: 02/12/2016 18:50:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[SP_EditAsset]
@Asset_ID int,
@Asset_Name nvarchar(50),
@Asset_SN nvarchar(50),
@Asset_Make int,
@Asset_Model int,
@Emp_ID int,
@Asset_Status nvarchar(50)
AS
BEGIN
DECLARE
--SET @Asset_ID = (select ISNULL(MAX(Asset_ID),0) + 1 from tbl_Asset)
update tbl_Asset set Asset_Name=@Asset_Name, Asset_SN=@Asset_SN, Asset_Make=@Asset_Make, Asset_Model=Asset_Model,Emp_ID=@Emp_ID,
@Asset_Status=@Asset_Status
where
Asset_ID=@Asset_ID
END
I hope works for you.