Live link datagridview to SQL (Windows Forms App)

HI Fellas

Hope you all had a great weekend...

I have a datagridview which is updated using the following code

Dim dbadp As New SqlClient.SqlDataAdapter("Select * From Users", "Data Source=196.220.43.247,1444;Initial Catalog=psql;User ID=MYNAME;Password=PASS;")
Dim dTable As New DataTable
dbadp.Fill(dTable)
dbadp.Dispose()

DgvUsers.DataSource = dTable
Me.UsersTableAdapter.Fill(Me.PsqlDataSetUsera.Users)

Select allOpen in new window

I would like to be able to edit a cell in the datagridview and it update the table in SQL.
Is this possible? or will I have to do some kind of update button?