Solved

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

Posted on 2010-09-12
6
328 Views
Last Modified: 2013-11-27
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
Comment
Question by:jampost
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33659792
Instead Of CustomerDataset use CustomerDataset1
u are using TableAdapterManager1 with CustomerDataset
Replace it with
Me.TableAdapterManager1.UpdateAll(Me.CustomerDataSet1)    
0
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33659814
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
 

Author Comment

by:jampost
ID: 33662799
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
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 18

Accepted Solution

by:
John (Yiannis) Toutountzoglou earned 500 total points
ID: 33662849
It Happens...!!My suggestion is to rebulid this part of your program.you might have a problem with vb.designer .
0
 

Author Closing Comment

by:jampost
ID: 33663197
    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
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33663226
Glad i helped you!!
0

Featured Post

Use Filtering Commands to Process Files in Linux

Learn how to manipulate data with the help of various filtering commands such as `cat`, `fmt`, `pr`, and others in Linux.

Question has a verified solution.

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

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

617 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