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.
