Record not getting deleted

Ramco Ramco

5y743.NET

Below is the code. Secondly i in ExecuteNonQuery returns -1.

if @Action='D'

Begin

--Update Location set IsActive = 'N' where Id = @Id;

Delete from Location where Id = @Id;

End

*********************

in **Id** it shows value as CHD\n

public int Delete(string Id)

{

int i;

using (SqlConnection con = new SqlConnection(cs))

{

con.Open();

SqlCommand com = new SqlCommand("sp_Location", con);

com.CommandType = CommandType.StoredProcedure;

com.Parameters.AddWithValue("@Id", Id);

com.Parameters.AddWithValue("@Action", "D");

i = com.ExecuteNonQuery();

}

return i;

}

**********************

In LocId it shows Chd

function Delete() {

var LocId = $("#hiddenId").val();

alert(LocId);

$.ajax({

url: "/Location/Delete",

data: { Id: LocId },

type: "POST",

dataType: "json",

success: function (result) {

$("#row_" + LocId).remove();

$('#DeleteModal').modal('hide');

clearTextBox();

$.notify(result.message, {

globalposition: "top center",

className: "success"

})

error: function (errormessage) {

alert(errormessage.responseText);

}

});

4 Replies

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

Jignesh Kumar5y ago
Accepted answer
Hi,

Please use this one remove newline charachter and check
function Delete() {
var LocId = $("#hiddenId").val();
alert(LocId);
$.ajax({
url: "/Location/Delete",
data: { Id: LocId.replace(/\r?\n|\r/g, ""); },
type: "POST",
dataType: "json",
success: function (result) {
$("#row_" + LocId).remove();
$('#DeleteModal').modal('hide');
clearTextBox();
$.notify(result.message, {
globalposition: "top center",
className: "success"
})
},
error: function (errormessage) {
alert(errormessage.responseText);
}
});
In case still you get new line character then remove from c# method,
public int Delete(string Id)
{
int i;
Id = Regex.Replace(Id, @"\t|\n|\r", "");
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
SqlCommand com = new SqlCommand("sp_Location", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@Id", Id);
com.Parameters.AddWithValue("@Action", "D");
i = com.ExecuteNonQuery();
}
return i;
}
+2
Ramco Ramco5y ago
Hi

Below is the Stored Procedure. I have commented Set NoCount On . Now it returns value 0
Record is still not getting deleted.

ALTER PROCEDURE [dbo].[sp_Location]
-- Add the parameters for the stored procedure here
@Id nvarchar(4) = Null,
@Description nvarchar(25) = Null,
@CreatedOn datetime = Null,
@IsActive nvarchar(1) = Null,
@Action varchar(1)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
if @Action='C'
Begin
Insert into Location(Id,Description,IsActive,CreatedOn) values(@Id,@Description,@IsActive,@CreatedOn);
End
if @Action='D'
Begin
Delete from Location where Id = @Id;
End
END

Thanks
+1
Ramco Ramco5y ago
Hi

In Controller Value of **Id** it shows value as CHD\n .

In JavaScript it shows CHD. Why So

In ExecuteNonQuery() it returns -1

Thanks
+1
Yogi S5y ago
Put the breakpoint on the C# function and debug. You can also refer - https://www.yogihosting.com/delete-records-ado-net-aspnet-core/
+1