Hi,
What I meant to say was by default the SQLDataAdapter is not being added to
the toolbox, however if I add it in via "Add new item" then it appears,
when I try to use it I need to first flip into "View Component Designer"
from there I drag my SQLDataAdapter onto the form, and go through the
wizard, I then have to manually add an Initialize() within my Form_Load(),
everything compiles fine, no error, however when I run my application it
Blows up with a System.Resources.MissingManifestResourceException,
Please not that if I only select a couple fields within my SQL query then
the program does not bomb.. when I further investigated this I see that it
is putting the lengthy select statements into a resource that it for some
reason doesn't seem to know it has at runtime... The two statements that it
seems to be adding to it when the select strings are longer are:
private void Initialize()
{
System.ComponentModel.ComponentResourceManager resources = new
System.ComponentModel.ComponentResourceManager(typeof(articles_wanted));
this.sqlCommand2.CommandText =
resources.GetString("sqlCommand2.CommandText"); // this is where the error
occurs, apparently it is not loading the component resource
This is why I figured that Microsoft had dropped support, I do notice that
the docs still say its supported and that it not marked as being
obsolete..., However this error is becoming a real bother as I am working
with a vs2003 application which has been converted into the vs2005
environment..
I have tried performing the exact same steps within a regular winform and is
too creates the resource file, but everything runs correctly...
Any help would be greatly appreciated..
If you have a moment maybe you could try the same on your end, creating a
sample project, I'm sure it will fail,, and if it doesn't then maybe you
could zip it up and send it to me and I will try it on this end.. I have
also tried loading VS2005 and retrying the same steps on a fresh machine...
thanks.