how to split the total and dislay into datagridview

Question

when i run as follows in datagridview in windows applciation Course GS VB SJ RK MS(faculty) Total REO 10 AFF 10 total number of faculty is 5 total hours of course is 10 when i divide the total(10) by number of faculty (5) and give the answer 2. i want to display the 2 for each faculty GS,VB,SJ,RK,Ms. i want the output as follows; i have one Load Button Course GS VB SJ RK MS(faculty) Total REO 2 2 2 2 2 10 AFF 2 2 2 2 2 10 when click the Load button 2 has to displayed in datagridview for each faculty. for that i have using this formula, total (10) is divide by number of faculty(5) gives the answer 2 this 2 will display in datagridview for each faculty. for th above output how can i do using csharp. Note: it is a windows application please help me.

Answer 1

Gaurav,

Would like to understand few things.

Whether you want to delete the records in a table based on the count of rows (parameter)? irrespective of which 10 or 40 records to be deleted.

Below link has the sample stored procedure to delete the records (result of search query) from the table.

https://technet.microsoft.com/en-us/library/ms189634(v=sql.105).aspx

Hope it will solve your issue.

Answer 2

Another approach you can take is schedule the deletion of rows during a time when database is not used.

Example during Night.

Then you would not need to implement any extra logic.

But use this, only if deletion can be done later.

Answer 3

CREATE PROCEDURE spDeleteRecord
@DeleteBatchSize INT,
@DelayTime DATETIME
AS
BEGIN
SET NOCOUNT ON;
DECLARE @DeleteRowCount INT
SET @DeleteRowCount = 1

WHILE (@DeleteRowCount > 0)
BEGIN
BEGIN TRANSACTION
DELETE TOP(@DeleteBatchSize) SchemaTableName;
SET @DeleteRowCount = @@ROWCOUNT;
PRINT @DeleteRowCount;
COMMIT
WAITFOR DELAY @DelayTime
END
END
GO

Answer 4

https://sqlperformance.com/2013/03/io-subsystem/chunk-deletes