ASP.NET 2.0 C# WebService Connect to Database: Sql Server 2005

Discussion in 'ASP .Net' started by Wendi Turner, May 5, 2008.

  1. Wendi Turner

    Wendi Turner Guest

    ASP.NET 2.0 C# WebService Connect to Database: Sql Server 2005
    ---------------------------------------------------------------------------------------------------

    I have successfully created a webservice in ASP.NET 2.0 C# with VS
    2005 & VS 2008, however, i can find nothing - books or otherwise to
    help with the webservice connection to the database.

    Can anyone please offer help on what to return in the method that
    makes a select statement to the database and HOW to connect to the
    database?? Do i use DataSets, TableAdapters, drivers???

    How??
     
    Wendi Turner, May 5, 2008
    #1
    1. Advertising

  2. Wendi Turner

    Lloyd Sheen Guest

    "Wendi Turner" <> wrote in message
    news:...
    >
    > ASP.NET 2.0 C# WebService Connect to Database: Sql Server 2005
    > ---------------------------------------------------------------------------------------------------
    >
    > I have successfully created a webservice in ASP.NET 2.0 C# with VS
    > 2005 & VS 2008, however, i can find nothing - books or otherwise to
    > help with the webservice connection to the database.
    >
    > Can anyone please offer help on what to return in the method that
    > makes a select statement to the database and HOW to connect to the
    > database?? Do i use DataSets, TableAdapters, drivers???
    >
    > How??


    One question. Do you have an currently running web site that uses SQL
    Server? If you do then you connect the same within the webservice as you do
    in the web site.

    Depending on what you want to do you can use datasets etc or just execute to
    get a datareader or a scalar value.

    LS
     
    Lloyd Sheen, May 6, 2008
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Juan T. Llibre
    Replies:
    0
    Views:
    493
    Juan T. Llibre
    Jun 7, 2005
  2. XJ
    Replies:
    8
    Views:
    1,785
  3. Wendi Turner

    ASP.NET 2.0 C# WebService Connect to Database: Sql Server 2005

    Wendi Turner, May 6, 2008, in forum: ASP .Net Web Services
    Replies:
    2
    Views:
    562
    UT-BadBoy
    May 7, 2008
  4. Wesley Chen
    Replies:
    0
    Views:
    247
    Wesley Chen
    Apr 7, 2009
  5. Wesley Chen
    Replies:
    9
    Views:
    263
    Sean O'Halpin
    Apr 14, 2009
Loading...

Share This Page