how to perform count on alert ?

Subin Thomas

i have a function in which if the data in table is already there then the new record is updated when submit button is clicked,

and if there is no data then the record is inserted when submit button is clicked

when submit button is clicked alert message displays record is successfully inserted

i want to write a count where it will display a message that how many records were updated and how many inserted

for eg if i click submit button it should come like

2 data inserted

5 data updated

7 Replies

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

Gajendra Jangid7y ago
look at this one:

https://www.aspsnippets.com/Articles/Display-Show-Success-Message-after-record-inserted-Form-Submit-in-ASPNet.aspx
Sivakumar Koneti7y ago
see this link example available

https://stackoverflow.com/questions/32988346/how-to-show-alert-message-after-all-records-inserted-to-database
7y ago

Event

jjj
Mario Scheeren7y ago
So your problem is not the SQL, but sending back JSON-Data and displaying it in an alert?
[HttpPost]
public async Task MyAction(string whatever, int max = 15)
{
  var data = new
  {
   Inserted: 2,
    Deleted: 3,
    Unchanged: 5
  };

  // do whatever you need to

  return Json(data, JsonRequestBehavior.AllowGet);
}
            $.ajax({
                type: "POST",
                url: '/Idontknow',
                data: { order: order },
                cache: false,
            })
                .done(function (data, textStatus, jqXHR) {
                  alert('Inserted: ' + data.inserted +
                        'Deleted: ' + data.deleted +
                         'Unchanged: ' + data.unchanged +
                     );
            })
                .fail(function (jqXHR, textStatus, errorThrown) {
                console.log(textStatus + ' ' + errorThrown);
            });
Madan Shekar7y ago
for update

SqlCommand comm; // other codes int numberOfRecords = comm.ExecuteNonQuery();

for more info go through this link
https://www.aspsnippets.com/Articles/ExecuteNonQuery-Get-number-of-rows-affected-during-Insert-Update-and-Delete-in-C-and-VBNet.aspx

thanks
Madan S B
Subin Thomas7y ago
i think you havent got my point,
i want to show count on my alert box after clicking on submit/save button
count of numbers of data inserted and count of number of data updated
Mario Scheeren7y ago
DECLARE @tbl (Action varchar(10), DepartmentID_A int, DepartmentID_B int);

MERGE [dbo].[Department_Target] AS trg
USING [dbo].[Department_Source] AS src
ON trg.[DepartmentID] = src.[DepartmentID]
WHEN NOT MATCHED THEN
   INSERT
   (
      [DepartmentID],
      [Name],
      [GroupName],
      [ModifiedDate]
   )
   VALUES
   (
      src.[DepartmentID], src.[Name], src.[GroupName], src.[ModifiedDate]
   )
OUTPUT
   $action,
   inserted.DepartmentID,
   deleted.DepartmentID
INTO @tbl
;

SELECT * FROM @tbl;
-- Having inserted ID and deleted ID means update has taken place, bc it is a combination of both (first delete, then insert again)

how to perform count on alert ?

Event