How do I include a new Table-Adapter in my Form

Question

0.00/5 (No votes)

See more:

, +

I have confused myself, it's not difficult at my age, but I've now got myself to the stage where I am really pissed off !!!

I have small E:Mail program, written in VB.net inside VS2010, that accesses a SQL-Server database. My initial testing has gone fine, I have 3 Tables in my database that I can access, though I have yet to do anything complicated, they are not even linked at the moment, but the program reads them and can send the E:Mails.

I now want to add the nitty-gritty stuff of keeping the databases up to date and allowing my user to specify where he keeps his data, so I have added a new Tab, a new Table & a new TableAdapter but my Form isn't picking up the new TableAdapter ... what am I doing wrong ?!?

Here are some details, firstly, my form ...

http://sdrv.ms/1ePqFoI

My Solution Explorer ...

http://sdrv.ms/1amUBvs

My Server Explorer ...

http://sdrv.ms/1amULmH

My Dataset design with all the TableAdapters ...

http://sdrv.ms/KBJWR1

As you can see, all of my TableAdapters are shown on my Form except for the new one, FileLocations ... why isn't it there and how do I attach / include it ?!?

Posted 21-Jan-14 0:55am

Gary Heath

Add a Solution

Comments

thatraja 21-Jan-14 7:42am

Just a suggestion, Here this site members don't trust the short urls. Use imgur.com

njammy 21-Jan-14 7:54am

Did you rebuild your solution after adding it?
Can you access it from code behind? i.e. FileLocationsTableAdapter fTa = new FileLocations TableAdapter

Gary Heath 21-Jan-14 10:09am

onenomi, it may have been as simple as that !!! I thought I had rebuilt it ... I've saved it, Closed the Project, re-opened it, tried everything, that's why I was getting so frustrated, maybe I hadn't done a Re-Build, because I just did one and lo & behold, there it is !!!

Thank you, I was sure it had to be something simple / stupid, that's me all over :-) !!!

1 solution

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)

Christian Graus · Accepted Answer · 2014-01-21T08:10:00

Adding as an answer, so that it's clear - onenimo got it. When you change code and it's not there, it's probably not built. When that happens to me, I clean and rebuild, and if that does not work, I change something cosmetic ( like the title bar text ) so I know for sure that what I am looking at, is the latest build.