Solved

Edit Cells and Add & Delete rows in a DataGrid

Posted on 2009-03-29
3
263 Views
Last Modified: 2012-05-06
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
Comment
Question by:rkckjk
  • 2
3 Comments
 
LVL 48

Accepted Solution

by:
jpaulino earned 500 total points
ID: 24013772
0
 
LVL 48

Expert Comment

by:jpaulino
ID: 24013783
Basically it's
YourAdapter.Update(YourDataSet)
 
0
 
LVL 2

Author Closing Comment

by:rkckjk
ID: 31564074
thanks
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question