Hi
I have below code but data is not getting updated. Neither i am getting any error message
C#
try
{
using (SqlConnection con = new SqlConnection(Common.CommonFunction.cnn_Live))
{
SqlCommand cmd = new SqlCommand("Sp_Department", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EntryNo", SqlDbType.Int).Value = hdfDeleteID.Value;
cmd.Parameters.Add("@Action", SqlDbType.NVarChar).Value = "D";
con.Open();
cmd.ExecuteNonQuery();
string message = Common.CommonFunction.recordDeletedSucessfully;
ShowMessage("Success", "Record Saved Successfully", "Success");
GetData();
}
}
catch (Exception ex)
{
ShowMessage("Oops...", ex.Message, "error");
}
Stored Procedure
PROCEDURE [dbo].[sp_Department]
@Action VARCHAR(1)
,@EntryNo int = Null
,@Description VARCHAR(50) = NULL
,@ShortName VARCHAR(25) = NULL
AS
BEGIN
SET NOCOUNT ON;
--UPDATE
IF @Action = 'U'
BEGIN
UPDATE dbo.Department
SET Description = @Description, updatedon = GETDATE() WHERE docentry = @EntryNo
END
--DELETE
IF @Action = 'D'
BEGIN
UPDATE dbo.Department
SET status = 0 , updatedon = GETDATE() WHERE docentry = @EntryNo
END
END
Thanks