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)

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?
GrahamSAAsked:
Who is Participating?
 
indrajitmahajanCommented:
Hi..

You can do it by editing a cell..

for your reference:
http://www.dotnetspider.com/resources/17855-Use-SqlCommandBuilder.aspx
0
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.