Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

Edit Cells and Add & Delete rows in a DataGrid

I'm trying to figure out how to update a cell in a datagrid and also how to add or delete rows so it's saved in Access.

I have the datagrid1 property options set to true for "AllowUserToAddRows and DeleteRows"

So, I need to be able to save the changes to the database.

I used the wizard to create the adapter and the dataset. It fills the the datagrid fine with the code below.

thanks
Imports System.Data.Oledb
Public Class Form1
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Me.FirstShift_ChecklistTableAdapter.Fill(Me.First_Shift_CheckSheetDataSet.FirstShift_Checklist)
    End Sub
End Class

Open in new window

0
Richard Kreidl
Asked:
Richard Kreidl
  • 2
1 Solution
 
Jorge PaulinoIT Pro/DeveloperCommented:
0
 
Jorge PaulinoIT Pro/DeveloperCommented:
Basically it's
YourAdapter.Update(YourDataSet)
 
0
 
Richard KreidlSoftware DeveloperAuthor Commented:
thanks
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.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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