Go Premium for a chance to win a PS4. Enter to Win

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

Updating Database Table with DataGridView

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
Mr_Fulano
Asked:
Mr_Fulano
1 Solution
 
JackOfPHCommented:
Try this


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

Open in new window

0
 
Mr_FulanoAuthor Commented:
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
 
heartsCommented:
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Mr_FulanoAuthor Commented:
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
 
BALMUKUND KESHAVCommented:
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
 
Mr_FulanoAuthor Commented:
Thanks BMKESHAV. I appreciate the help!!!
0
 
Mr_FulanoAuthor Commented:
BMKESHAV, did you say there was a link attached? I can't see one attached to your post.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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