how to perform count on alert ?

Question

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

Gajendra Jangid · Answer

look at this one: https://www.aspsnippets.com/Articles/Display-Show-Success-Message-after-record-inserted-Form-Submit-in-ASPNet.aspx

Sivakumar Koneti · Answer

see this link example available https://stackoverflow.com/questions/32988346/how-to-show-alert-message-after-all-records-inserted-to-database

Parth Munjpara · Answer

var count = 0; Event jjj

Mario Scheeren · Answer

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 Shekar · Answer

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 Thomas · Answer

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 Scheeren · Answer

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)