problem adding data connection.

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • dlbriggs1729@yahoo.com

    #1

    problem adding data connection.

    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.

Working...