A little confused...

Amy Snyder

I am trying to discern the difference between creating a web service or
using IIS Virtual Directory Management for SQL Server Utitly if I want
to provide xml data from a database.

I have created some xml templates that will allow a user to access the
data in xml format when entering the http:// address. Its pretty quick
and easy to do once the virtual directory is configured through sql.

Is creating a web service to provide xml data from a database as
straighforward?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #1

Subscribe Post Reply

1190

Kevin Spencer

If you load your data into a DataSet, it is extremely simple. You just
create a WebMethod that queries the database and returns a DataSet loaded
with the results.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Amy Snyder" <am**@yahoo.com> wrote in message
news:ug**************@TK2MSFTNGP12.phx.gbl...

I am trying to discern the difference between creating a web service or
using IIS Virtual Directory Management for SQL Server Utitly if I want
to provide xml data from a database.

I have created some xml templates that will allow a user to access the
data in xml format when entering the http:// address. Its pretty quick
and easy to do once the virtual directory is configured through sql.

Is creating a web service to provide xml data from a database as
straighforward?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #2

Amy Snyder

It seems there is more work involved with the web service. I guess I
am trying to understand why (if at all) you would use the webmethod
versus the xml template. Are there certain instances that would
determine which is better to use?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #3

Kevin Spencer

Well, your original question was if using Web Services was "Is creating a
web service to provide xml data from a database as straightforward?" I
believe my answer was intentended to brielfy indicate "yes." If the question
is "Is creating a web service to provide data from a SQL Server database as
straightforward" I would have to say "no." In other words, if you''re
talking about databases in general, it is quite simple to transform a result
set (or any other kind of data) into XML using Web Services. However, as SQL
Server can do this without Web Services, it is not necessarily necessary
(depending upon your requirements) to use the extra step.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Amy Snyder" <am**@yahoo.com> wrote in message
news:O2**************@TK2MSFTNGP12.phx.gbl...

It seems there is more work involved with the web service. I guess I
am trying to understand why (if at all) you would use the webmethod
versus the xml template. Are there certain instances that would
determine which is better to use?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #4

Kevin Spencer

Just a bit more, if it will help. For example, if you want to expose data
via HTTP over Port 80, you would have to use Web Services. This might be
necessary for any number of reasons, such as firewall issues.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Amy Snyder" <am**@yahoo.com> wrote in message
news:O2**************@TK2MSFTNGP12.phx.gbl...

It seems there is more work involved with the web service. I guess I
am trying to understand why (if at all) you would use the webmethod
versus the xml template. Are there certain instances that would
determine which is better to use?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Nov 18 '05 #5

by: stewart.midwinter | last post by:

No doubt I've overlooked something obvious, but here goes: Let's say I assign a value to a var, e.g.: myPlace = 'right here' myTime = 'right now' Now let's say I want to print out the two...

Python

Need a little help with NODES

by: Charlie T | last post by:

Hello, I am a little confused... please help: ----------------------------------- <DIV id="01"> <DIV id="aNum"></DIV> <DIV id="bNum"></DIV> <DIV id="cNum"></DIV> </DIV>

Javascript

A little help with random records

by: Jeff Uchtman | last post by:

I have read 10000 opinions on returning random records and I am more confused now that before I started. I have a small access db that will contain 20 or so rows with 3 or 4 columns. I like to...

ASP / Active Server Pages

BitArray and Little Endian bit order of bytes

by: Laszlo Szijarto | last post by:

In using the BitArray class to parse a single byte, I noticed that the bits show up in Little Endian order. Aren't bits always arranged in Big Endian order? I'm a bit confused and would...

C# / C Sharp

ASP.Net has me confused, little help please

by: Daniel | last post by:

I'm new to .Net and all of its abilities so I hope this makes sense. Basically I'm confused on when is the appropriate time to use web forms controls vs. regular HTML. For example in ASP...

ASP.NET

It's the little things

by: CMM | last post by:

Do the developers of Visual 2005 actuall use it??? There's lots of great things in VS2005 (mostly related to the outstanding work done on the CLR)... but in general the LITTLE THINGS totally drag...

.NET Framework

Little Confused

by: manochavishal | last post by:

Hi , Ihave this code to show binary of an integer. #include<stdio.h> #include<stdlib.h> typedef struct binary* binaryptr; typedef struct binary { int data;

C / C++

Little program

by: mdh | last post by:

Can someone look at this little program and tell me why the last line is not compiling. #include <stdio.h> int main (){ int i, j, k; i=0;

C / C++

Data ... need advice on this ... a little bit confused.

by: shapper | last post by:

Hello, I need to create a data object to hold a number of records with 3 columns. A datatable would do. My problem is this: 1. I will use this as a GridView datasource. 2. I will need to...

ASP.NET

[struct] A little bit confused about structure in C.

by: mattmao | last post by:

I am moving onto the tough part in learning C:( First, about the declaration of a user defined structure: I found this syntax in my lecture notes: struct userinfo { char username; ...

C / C++

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

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

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

A little confused...

Similar topics