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

Wendi Turner

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??

Jun 27 '08 #1

Subscribe Post Reply

2113

Lloyd Sheen

"Wendi Turner" <we*********@gmail.comwrote in message
news:7f**********************************@q27g2000 prf.googlegroups.com...

>
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

Jun 27 '08 #2

by: Bamse | last post by:

Hi all, The problem is as follows: I need to authorize a user: through a WS; if a setting is on, the webservice will look in the local "database", if the setting is off it will connect to the...

.NET Framework

Consuming a PHP Webservice

by: Carlos Lozano | last post by:

Hi, as a background I have an Windows application developed with VS 2003 (c#) that needs to transfer securely data to a MySQL database located on a Linux server. I have created a PHP...

.NET Framework

Dataadapter creation errors on WebService Projects

by: Franklin M. Gauer III | last post by:

I create a simple DATAADAPTER in a webservice project. It creates the UPDATE, INSERT, DELETE commands for me - no problem. In vS2005 it creates these commands as RESOURCES in the RESX file (i.e....

.NET Framework

Personal Web Site Starter Kit - Can't connect to Personal.mdf

by: Larry Rebich | last post by:

I am trying to use the sample web template that is distributed with Visual Studio 2005 called 'Personal Web Site Starter Kit'. After running for awhile it fails with the following message: ...

.NET Framework

Help on deploying webservice

by: adi | last post by:

Hi I only have this situation at one of my client's site. I install the webservice setup prog. Usually, i may access the asmx file from an IE browser. Not this time. My webservice uses .NET...

C# / C Sharp

Webservice not releasing SQL connections

by: Steve Ricketts | last post by:

I have a webservice written in VB.net that opens a connection to SQL Server 2000 with a connection string. The connection remains open for the life of the web service so the ADODB.connection is...

.NET Framework

Re-Connect with Remote SQL Servr 2005 Database

by: BD | last post by:

I am developing C# win form app to work with remote database on SQL Server 2005. Problem scenario is as follows: 1. a form is open that has downloaded dataset to local cache 2. computer is...

C# / C Sharp

ASP.NET 2.0 C# WebService Connect to Database

by: Wendi Turner | last post by:

ASP.NET 2.0 C# WebService Connect to Database: Sql Server 2005 --------------------------------------------------------------------------------------------------- I have successfully created a...

C# / C Sharp

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

by: Wendi Turner | last post by:

ASP.NET 2.0 C# WebService Connect to Database: Sql Server 2005 --------------------------------------------------------------------------------------------------- I have successfully created a...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

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

Similar topics