Solved

Edit Cells and Add & Delete rows in a DataGrid

Posted on 2009-03-29
3
261 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

813 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now