Data menu not available in web service

Hi

I have a web service project, and want to connect to a DB, and return the data from the web service

The problem is that the data menu is not available, i know i need to create a data provider, but i cant... what am i doing wrong?

Regards
Greg Phillips

[264 byte] By [GregP] at [2007-12-16]
# 1

Is the connection string pointing to the correct database?

WbTest1-1 at 2007-9-8 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 2

Hi, thanks for the reply.
Well, i cant add a data provider of any sort to the web service, as you would with say a winform app, I cant get the data providers window to open, cant add any data connection or data provider to my web service.

It's strange, dont know if i am not using it the way its meant to be used, or that i have some sort of bug....

Its frustrating, we currently cant make web services in VS2005, we can do the rest though...
So to answer your question... we not getting to add a connection to a data provider yet... the problem is before that.
Greg

GregP at 2007-9-8 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 3
I have exactly the same problem. It would be nice if someone from MS could confirm that either this is a bug or by design and if the latter the rationale for it.

I going to try creating a winforms project and then creating my data connection, datasets etc and then try and use the classes and other stuff generated in a Web Services project.

Not sure if it will work though...

Regards

Jayne at 2007-9-8 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 4
really the reason I think its not there is because your going to have to manually create the data and the reason being is because in webservices your returning objects like datasets etc... and the things from the data menu would not do that. You would end up going back and changing your code and the whole big thing about that menu is creating stuff for you. Its not there on mine and I can honestly say that I have never needed it to be there because almost all the code I need; I am writing because thats what U have to do LOL..

I would Look over some examples on the MSDN website on how to create Webservices.

wacko at 2007-9-8 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 5

Hi Wacko

Thanks for the reply, though the way i extract data from the database and return it out of the web service currently, is that i create a data adapter. Then fill a dataset with the data adapter, and return this dataset.

Now yes, i could code this functionality, though for productivity reasons, i like to use the wizards to help set up the code.

If you have some examples of a better way, one which i should possibly adopt, please could you provide them?

--


I would also appreciate someone from Microsoft responding to this query.

Greg
GregP at 2007-9-8 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 6
this is not really a web services question.

our team doesn't own the designer, etc. in visual studio.

i am going to move this thread over to the IDE forum.

douglasp at 2007-9-8 > top of Msdn Tech,Visual Basic,Visual Basic General...