Update Datagridview in c# via Trigger UPDATE SQL

Question

Hello, I have the following question.

I’m running a c# application with SQL Server database.

I have a Datagridview where he is carried via Datatable, the information loaded is from people: Name, Status ...

I want you to update the status (change from offline to online) Update the Datagridview automatically.

Currently I do this with a team, which is every 15 seconds updating the form, but I find it unfeasible, and if I need to update the form every 1 second?
and if it’s 100,000 people?

How can I do this via Trigger Update:

My Thought:

Trigger update that calls either select or just the command Select * from pessoa , c# application captures this select and inserts it into Datagridview.

EX: I got to it:

>CREATE TABLE PESSOA(

NOME VARCHAR(250)

)

CREATE TRIGGER SELECIONAR_NOME ON DBO.PESSOA
AFTER UPDATE AS 

BEGIN 
    SELECT * FROM PESSOA

END

Entering Values in the Table

 INSERT INTO PESSOA(NOME) VALUES ('fulano1')
 INSERT INTO PESSOA(NOME) VALUES ('fulano2')
 INSERT INTO PESSOA(NOME) VALUES ('fulano3')
 INSERT INTO PESSOA(NOME) VALUES ('fulano4')
 INSERT INTO PESSOA(NOME) VALUES ('fulano5')

UPDATE PESSOA SET NOME = 'fulano0' WHERE NOME = 'fulano1'

RESULT:

How do I get this table? The table that came out of Trigger After Update?