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=,1444;Initial Catalog=psql;User ID=MYNAME;Password=PASS;")
Dim dTable As New DataTable

DgvUsers.DataSource = dTable

Open 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?
Who is Participating?

You can do it by editing a cell..

for your reference:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.