• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 651
  • Last Modified:

Visual Basic, Update Database Using DataGridView

Hi Everyone,

I am creating a visual basic application that links to a table in a SQL Server database. I

went through the wizard for creating a DataGridView. My problem now is that I cannot

add or update to the database. Though it gives me the form that I can use to input data,

it is never saved to the database.

Ironically, at the beginning of the process, it gives you options to add, delete and Update

from the View.

What more do I need to setup to get the application to be able to add and update data.


1 Solution
You need to call the Update method on table adapter and it should save changes to the DB.

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.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now