Exposing Northwind on a Web Site

21 Feb 2006 9:30 AM

Oriane

Hi,

what would be the simplest way to expose a database like Northwind on a Web
site ? I mean, give the Web user a way to display the provider of a region
knowing the region code... This would be a read-only web site. I would like
to take into account the authentication/authorization pb...

1> ASP.NET ?
2> A Web part on SPS 2003 (the site is already present) ?
3> A web service ?

Thank you

21 Feb 2006 10:28 AM

Cor Ligthert [MVP]

Oriana,

If it is to use the data in a whatever other application.
Webservice

If it is to show the data to humans
ASPNET

Just my thought,

Cor

22 Feb 2006 7:51 PM

Cowboy (Gregory A. Beamer) - MVP

I find any of these methods easy, so it depends on the requirements. If you
merely want to pass back the metadata and info, a web service is fairly flat.
It does not give you much in the way of clueing in the user, however.

ASP.NET is another option and allows you to add more GUI bits to lead the
user. SharePoint web part is pretty much the same, but you are adding more
software into the mix.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************

Show quote

"Oriane" wrote:

> Hi,
>
> what would be the simplest way to expose a database like Northwind on a Web
> site ? I mean, give the Web user a way to display the provider of a region
> knowing the region code... This would be a read-only web site. I would like
> to take into account the authentication/authorization pb...
>
> 1> ASP.NET ?
> 2> A Web part on SPS 2003 (the site is already present) ?
> 3> A web service ?
>
> Thank you
>
>
>