I am wrinting a data service to access and update a datset. I am
having problem when I try to add a SqlConnection to a web service.
Using C# in VS 2005 I started a new web service project. Then I  made
a new Sql server data base and added one table I also added some
data.
So far so good. The data base shows up in the Server Explorer (with
a .dbo extention) and I can look at the data. But I get no auto-
generated code when I drag and drop the database onto the designer
screen. Also there is no data menu in VS when I have a web service
project. Do I have to add this code by hand? If I have to add this
code my hand is there anyway to get VS to auto generate the SQL for
the dataset for adding, updating and deleting items?

BTW I am running on a Vista machine.