• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 354
  • Last Modified:

CustomerDataSet is not a member of sa.Form1 [vb 2008 to SQL 2008 connection issue]

Program used: Visual Studio 2008 Standard edition using Visual Basic 2008
Database used: SQL Server 2008 Developer edition
Problem to be solved: error message on line of code in project “sa” Form1
Data sources are CustomersDataSet & OrdersDataSet  and both are visable under the Data Sources window.
The code:
Me.TableAdapterManager1.UpdateAll(Me.CustomerDataSet)    

The error message is:
CustomerDataSet is not a member of sa.Form1

DataSetError.pdf
0
jampost
Asked:
jampost
  • 4
  • 2
1 Solution
 
John (Yiannis) ToutountzoglouInstructor Multiengine PilotCommented:
Instead Of CustomerDataset use CustomerDataset1
u are using TableAdapterManager1 with CustomerDataset
Replace it with
Me.TableAdapterManager1.UpdateAll(Me.CustomerDataSet1)    
0
 
John (Yiannis) ToutountzoglouInstructor Multiengine PilotCommented:
You have 2 set of everything ..
2 Table adapter manager ,2 datasets,2 bindinsources
So or use:
Me.TableAdapterManager1.UpdateAll(Me.CustomerDataSet1)    
or
Me.TableAdapterManager.UpdateAll(Me.CustomerDataSet)
 
0
 
jampostGeneral MaanagerAuthor Commented:
Thank you "itoutou",

You are right about 2 sets of everything. I tried eliminating the extra one and things stop working.
I tried:

Me.TableAdapterManager.UpdateAll(Me.CustomerDataSet)
 
Me.TableAdapterManager1.UpdateAll(Me.CustomerDataSet1)

 I also tried both of those lines with customers instead of customer, eliminating the 1 on one end and having it on the other.
 It looks like the answer is elsewhere in the program. I was just thinking that the error message might give a clue.  I guess if it were easy, everybody would be programers.

 
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
John (Yiannis) ToutountzoglouInstructor Multiengine PilotCommented:
It Happens...!!My suggestion is to rebulid this part of your program.you might have a problem with vb.designer .
0
 
jampostGeneral MaanagerAuthor Commented:
    I suppose it is like restarting the PC. it fixes everything. I deleted everything for the Customer and reinstalled the comboBox from the Data Source which automatically installed all the Binding source, Data set, table adapter and table adapter manager. error gone. Thank you.
0
 
John (Yiannis) ToutountzoglouInstructor Multiengine PilotCommented:
Glad i helped you!!
0
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

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

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