?
Solved

Update Dataset with Datagridview'

Posted on 2009-02-16
6
Medium Priority
?
1,715 Views
Last Modified: 2012-05-06
I have 1 winform with datagridview, this datagridview will display data from dataset.
I want to edit some value on datagridview and when press savedata button all data will be updated to Database.
How can I do?
0
Comment
Question by:Mr_Bach
  • 3
  • 2
6 Comments
 
LVL 30

Expert Comment

by:anarki_jimbel
ID: 23656024
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:Mr_Bach
ID: 23656359
I can't use those links above, It can't help me, not my idea, I didn't create any qurey on C#, I just used wizard from Visual Studio to bind data from dataset to datagridview.
0
 
LVL 30

Expert Comment

by:anarki_jimbel
ID: 23663355
Mr Bach,

Even if you use the wizard to createa dataset and bind it to a datagridview you still have a reference to the dataset. And basicly all you need to do is to accept changes by calling  DataSet.AcceptChanges - read my first code. Think logically: even if you do not create any statements yourself but use wizards still these statements are created fort you. So still the approach I pointed to is applicable. There is no any magic here.
0
 
LVL 30

Accepted Solution

by:
anarki_jimbel earned 375 total points
ID: 23663635
I believe that is all you need (because you have an adapter and a dataset:

                    ' Update the database
                    da.Update(dsChanges)

                    ' Accept the changes within the DataSet
                    ds.AcceptChanges()

See links that RamanaChoudary sent you.

Honestly you can't expect anything else apart from links. Points are not generous, problem description is too vague etc.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
Loops Section Overview
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?
Suggested Courses
Course of the Month14 days, 13 hours left to enroll

839 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