By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,904 Members | 1,646 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,904 IT Pros & Developers. It's quick & easy.

Dataadapter creation errors on WebService Projects

P: n/a

I create a simple DATAADAPTER in a webservice project. It creates the
UPDATE, INSERT, DELETE commands for me - no problem.

In vS2005 it creates these commands as RESOURCES in the RESX file (i.e.
strings). The problem is whenever I try to test the webservice I get:

System.Resources.MissingManifestResourceException: Could not find any
resources appropriate for the specified culture or the neutral culture. Make
sure "WS_SComm2.resources" was correctly embedded or linked into assembly
"App_Code" at compile time, or that all the satellite assemblies required are
loadable and fully signed.
at System.Resources.ResourceManager.InternalGetResour ceSet(CultureInfo
culture, Boolean createIfNotExists, Boolean tryParents)
at System.Resources.ResourceManager.InternalGetResour ceSet(CultureInfo
culture, Boolean createIfNotExists, Boolean tryParents)
at System.Resources.ResourceManager.InternalGetResour ceSet(CultureInfo
culture, Boolean createIfNotExists, Boolean tryParents)
at System.Resources.ResourceManager.GetString(String name, CultureInfo
culture)
at System.Resources.ResourceManager.GetString(String name)
at WS_SComm2.InitializeComponent()
at WS_SComm2..ctor()

I've tried restarting, moving my resx files, I've even created entire new
blank applications - and then i would just set up one dataadapter and i still
get this error. It seems like the application can't find these resource
strings.

I am not doing anything special - I am just creating a dataadapter usine the
VS2005 IDE. In VS2003 this was a real easy process and everything worked
fine. I don't know how to get this to work! We literally have HUNDREDS of
these dataadapters with the embedded SQL statements. These things have to
work in VS2005. What's the deal - I am completely lost!

So in order to get my project done I am ripping out all of my dataadapters.
Shouldn't the resx file thing just work? I didn't have any of these troubles
in VS2003... Please help? What should I do?

Thanks!

--
Franklin M. Gauer III
Applications Development Manager
Integrated Companies, Inc.
Jun 4 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Can someone try this? Try the following:

1) Create a VB WebService Project
2) Connect to a SQL Server Instance using Server Explorer (or use a
connection you already have)
3) Create a dataadapter using the VS 2005 IDE (i.e. drag one on your
webservice from the TOOLBOX) and have the wizard create the UPDATE and INSERT
statements for you (i.e. just go though the wizard and select a table from
your database)
4) Now test your application using the HELLO WORLD webservice and you will
get the error I described above.

I thought it might be happening on one of my machines - so I completely
wiped one and installed VS 2005 on it from scratch. Same error.
--
Franklin M. Gauer III
Applications Development Manager
Integrated Companies, Inc.
"Franklin M. Gauer III" wrote:

I create a simple DATAADAPTER in a webservice project. It creates the
UPDATE, INSERT, DELETE commands for me - no problem.

In vS2005 it creates these commands as RESOURCES in the RESX file (i.e.
strings). The problem is whenever I try to test the webservice I get:

System.Resources.MissingManifestResourceException: Could not find any
resources appropriate for the specified culture or the neutral culture. Make
sure "WS_SComm2.resources" was correctly embedded or linked into assembly
"App_Code" at compile time, or that all the satellite assemblies required are
loadable and fully signed.
at System.Resources.ResourceManager.InternalGetResour ceSet(CultureInfo
culture, Boolean createIfNotExists, Boolean tryParents)
at System.Resources.ResourceManager.InternalGetResour ceSet(CultureInfo
culture, Boolean createIfNotExists, Boolean tryParents)
at System.Resources.ResourceManager.InternalGetResour ceSet(CultureInfo
culture, Boolean createIfNotExists, Boolean tryParents)
at System.Resources.ResourceManager.GetString(String name, CultureInfo
culture)
at System.Resources.ResourceManager.GetString(String name)
at WS_SComm2.InitializeComponent()
at WS_SComm2..ctor()

I've tried restarting, moving my resx files, I've even created entire new
blank applications - and then i would just set up one dataadapter and i still
get this error. It seems like the application can't find these resource
strings.

I am not doing anything special - I am just creating a dataadapter usine the
VS2005 IDE. In VS2003 this was a real easy process and everything worked
fine. I don't know how to get this to work! We literally have HUNDREDS of
these dataadapters with the embedded SQL statements. These things have to
work in VS2005. What's the deal - I am completely lost!

So in order to get my project done I am ripping out all of my dataadapters.
Shouldn't the resx file thing just work? I didn't have any of these troubles
in VS2003... Please help? What should I do?

Thanks!

--
Franklin M. Gauer III
Applications Development Manager
Integrated Companies, Inc.

Jun 4 '06 #2

P: n/a

Hi I wanted to post a solution to this in case anyone coming from VS 2003
runs into this same issue.

The trick is to abandon creating the dataadapter UPDATE, INSERT and DELETE
statements at DESIGN time and instead - create them at RUN TIME.

Look up the SQLCOMMANDBUILDER object in the .NET 2005 documentation. It
shows you how to use the object to dynamically re-create your UPDATE, INSERT
AND DELETE statements right before you execute the UPDATE METHOD on your
dataadapter...

....actually a very slick little solution...

--
Franklin M. Gauer III
Applications Development Manager
Integrated Companies, Inc.
"Franklin M. Gauer III" wrote:
Can someone try this? Try the following:

1) Create a VB WebService Project
2) Connect to a SQL Server Instance using Server Explorer (or use a
connection you already have)
3) Create a dataadapter using the VS 2005 IDE (i.e. drag one on your
webservice from the TOOLBOX) and have the wizard create the UPDATE and INSERT
statements for you (i.e. just go though the wizard and select a table from
your database)
4) Now test your application using the HELLO WORLD webservice and you will
get the error I described above.

I thought it might be happening on one of my machines - so I completely
wiped one and installed VS 2005 on it from scratch. Same error.
--
Franklin M. Gauer III
Applications Development Manager
Integrated Companies, Inc.
"Franklin M. Gauer III" wrote:

I create a simple DATAADAPTER in a webservice project. It creates the
UPDATE, INSERT, DELETE commands for me - no problem.

In vS2005 it creates these commands as RESOURCES in the RESX file (i.e.
strings). The problem is whenever I try to test the webservice I get:

System.Resources.MissingManifestResourceException: Could not find any
resources appropriate for the specified culture or the neutral culture. Make
sure "WS_SComm2.resources" was correctly embedded or linked into assembly
"App_Code" at compile time, or that all the satellite assemblies required are
loadable and fully signed.
at System.Resources.ResourceManager.InternalGetResour ceSet(CultureInfo
culture, Boolean createIfNotExists, Boolean tryParents)
at System.Resources.ResourceManager.InternalGetResour ceSet(CultureInfo
culture, Boolean createIfNotExists, Boolean tryParents)
at System.Resources.ResourceManager.InternalGetResour ceSet(CultureInfo
culture, Boolean createIfNotExists, Boolean tryParents)
at System.Resources.ResourceManager.GetString(String name, CultureInfo
culture)
at System.Resources.ResourceManager.GetString(String name)
at WS_SComm2.InitializeComponent()
at WS_SComm2..ctor()

I've tried restarting, moving my resx files, I've even created entire new
blank applications - and then i would just set up one dataadapter and i still
get this error. It seems like the application can't find these resource
strings.

I am not doing anything special - I am just creating a dataadapter usine the
VS2005 IDE. In VS2003 this was a real easy process and everything worked
fine. I don't know how to get this to work! We literally have HUNDREDS of
these dataadapters with the embedded SQL statements. These things have to
work in VS2005. What's the deal - I am completely lost!

So in order to get my project done I am ripping out all of my dataadapters.
Shouldn't the resx file thing just work? I didn't have any of these troubles
in VS2003... Please help? What should I do?

Thanks!

--
Franklin M. Gauer III
Applications Development Manager
Integrated Companies, Inc.

Jun 6 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.