Error saving SQL table: TableAdapterManager contains no connection information.

Posted on 2008-02-08
Medium Priority
Last Modified: 2013-12-20
Hi, just getting to grips with SQL and VB 2008. I have a simple form with a single table called customers.

When i click the 'save' button on the CustomerBindingNavigator i get an error "TableAdapterManager contains no connection information. Set each TableAdapterManager TableAdapter property to a valid TableAdapter instance."

If i run the code behind the save button on another button it works fine, doesn't make sense to me...

Please help before i go insaine.
Private Sub CustomerBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CustomerBindingNavigatorSaveItem.Click
        Me.TableAdapterManager.UpdateAll(Me.Dataset_customers)  ' I GET THE ERROR HERE
    End Sub
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
    End Sub

Open in new window

Question by:bassl1ne
LVL 31

Accepted Solution

James Murrell earned 600 total points
ID: 20856915

Author Comment

ID: 20858604
Thanks, i have checked out the link but it does not provide additional information required to solve my problem.

I am sure if i recreated the form it would work ok as it did originally, i suspect something deeper in the generated code has gone wrong. The reason i ask the question rather than simply recreate the form it because i would like to learn how to debug these faults rather than starting all over again as seems to be the case at the moment.

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

619 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