Solved

Updating Database Table with DataGridView

Posted on 2009-06-26
7
351 Views
Last Modified: 2012-05-07
Hi, I'm using VB 2005, WinForms. I have a database Table we can call (UsersList). I have a DataTable called (dtUsers) in my code that works with a DataAdapter. Together they fill a DataGridView for me to display my list of Users. - That much works well.

I would like to allow my users to make changes (Edits) to the data that they see in  the DataGridView. My problem is how do I execute the "Update" of changes back to the Table from the DataGridView.  And have the DataGridView refresh itself.

In other words, if I do the following it does not work:

dgvUserList.Update
dgvUserList.Refresh

I would like to provide my users a button for them to click and be able to save any modifications made to the data they see in the DatGridView.

Thanks for your help,
Fulano
0
Comment
Question by:Mr_Fulano
7 Comments
 
LVL 15

Expert Comment

by:JackOfPH
ID: 24726339
Try this


da.Update(dtUsers) '<--- Update the dtUsers using the dataadapter.
dtUsers.AcceptChanges() '<---- Accepts the changes made.

Open in new window

0
 

Author Comment

by:Mr_Fulano
ID: 24726398
Hi Jack,
I'm getting this error at the first line of code you provided [da.Update(dtUsers)].
Obviously, I changed the adapter and table names to be correct with my code.

Error:
Additional information: Update requires a valid UpdateCommand when passed DataRow collection with modified rows.

0
 
LVL 1

Accepted Solution

by:
hearts earned 500 total points
ID: 24726475
I think you are not writing the commandbuilder code for dataadapter to update the records back in database. Or might be missing some columns in commandbuilder update query thats why there comes an error.
This will help you for more details:
http://msdn.microsoft.com/en-us/library/ms971491.aspx
0
Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

 

Author Comment

by:Mr_Fulano
ID: 24726523
Thanks, I figured out what was wrong with my original code, so I was able to fix my problem and learned a some new tricks form you along the way.

Thanks again,
Fulano
0
 
LVL 6

Expert Comment

by:BALMUKUND KESHAV
ID: 24726528
pl.see the attached aspx.net/vb.net code.
This will help you, i think method is same for win form datagrid or aspx page datagrid.
Where every i have used mysql you can use Sql property.

Bm keshav
0
 

Author Comment

by:Mr_Fulano
ID: 24731569
Thanks BMKESHAV. I appreciate the help!!!
0
 

Author Comment

by:Mr_Fulano
ID: 24731574
BMKESHAV, did you say there was a link attached? I can't see one attached to your post.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

Suggested Solutions

Title # Comments Views Activity
How to use odbc in vb to connect to ms sql 14 63
Get hold of longitude and latitude in iframe string 11 49
Sql server insert 13 37
VB.Net. Reading xml value 6 30
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…
Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

828 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