How to update database using BindingSource in Vb.net

Question

0.00/5 (No votes)

See more:

Hi all visitors

I have a problem with update my data in sql server 2005.
I use like this:

VB

dataadapter.update(bindingsource.datasource)

after than will display an error like this:
Update requires a valid UpdateCommand when passed DataRow collection.

Please help me
Best Regards,

Posted 19-Jun-11 18:49pm

soeun tony

Updated 10-Mar-12 21:42pm

ProEnggSoft

v2

Add a Solution

Comments

ProEnggSoft 11-Mar-12 3:43am

Edit: pre tag for VB.NET code and code tags added - PES

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ankur^\m/ · Answer 1 · 2011-06-19T18:56:00

Solving a problem is easiest when you have exact error message. You just need to Google for it.

So is your case. See the link - Error - Update requires a valid UpdateCommand when passed DataRow collection[^].

BTW the error message here is pretty self explaining. You haven't defined an UpdateCommand for the BindingSource. To update something against database, an update query is required and you will need to specify one like this - bindingsource.UpdateCommand = "Update Query here";

Hope this helps!

ExpertTIC · Answer 2 · 2012-03-10T04:49:00

Solution 2

take a look there it maybe help you

[^]

Posted 10-Mar-12 4:49am

ExpertTIC

ProEnggSoft · Answer 3 · 2012-03-13T00:11:00

I have a suggestion.
Please take a look at this article.
General purpose class to fill DataTable(s) from DataBase and to save DataTable(s) to DataBase using reflection[^]

Using this general purpose class you can fill DataTable(s) from database and save DataTable(s) to database easily.

The sample code given in the article is in C#.
You can use the code converter at Telerik.com
http://converter.telerik.com/[^]
to convert the C# code to VB.NET code

How to update database using BindingSource in Vb.net

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0