Home > 2010 Fall DPS907 > DPS907 WSA500 Lab 1 (due Mon Sep 27)

DPS907 WSA500 Lab 1 (due Mon Sep 27)

September 20, 2010 Leave a comment Go to comments

Lab 1 enables you to create a SOAP XML Web Services “server”, and test it with an ASP.NET Web Forms “client”. It is due on Monday September 27.

DPS907 WSA500 Lab 1 – due Mon Sep 27

Assigned: During Week 2

Due date: Monday, September 27, 2010, at 9:50am ET

Grade value: 3% of your final course grade

Grading method: The following will be checked:

  • Your “labs/lab1.aspx” page
  • Correct interactive operation of the page’s logic
  • Implementation of the specifications
  • Code writing quality, including commenting



Create a web service server endpoint, as a SOAP XML Web Service

Create a web forms page that consumes the endpoint above


Introduction to the problem that you will solve

A SOAP XML Web Service “server” is needed that will interface with your personal web site. You can decide what data to serve, but it will data that you create, or data from your copy of the Northwind database.



You should create some tables in your warp server database as your first task. For this Lab 1, it really doesn’t matter what you store in your database, but make sure that there are at least two (2) tables, and twenty (20) rows in each table. You could store music data (e.g. artists, albums, songs, etc.), or sports data (e.g. football teams, players, games/results, etc.), or academic data (e.g. your courses in the program, your grades, your professors, etc.). Alternatively, you could copy in some Northwind tables from the read-only Northwind database on the warp server cluster.

A link to the script that copies the Northwind tables into your database is at the bottom of this post.

After you create your database tables, you should then create a data access layer. Beyond the default methods that get created when you create a new table adapter, you will have to create some additional methods for your table adapters. The methods will take one or more arguments, and enable the method to shape the query (e.g. where, order by, etc.). These methods will be called by your web service “server” methods (see below).

If you need a reminder on how to work with your database on the warp server cluster, check out the following blog posts from the Winter 2010 session of BTI420 (the degree-program version of INT422):

List of class notes (blog posts) for the Winter 2010 session of BTI420, and look for these February and March notes:

Database server for our ASP.NET web apps

SQL Server administration toolset

Copying Northwind tables to your database…

Introduction to a Data Access Layer for BTI420 students

Learning more about a Data Access Layer

Getting started with a digital content table

Getting started with a blog post table

After you have made good progress on your database and data access layer, you can begin coding your web service “server”, and an ASP.NET Web Forms “client” that will call the “server”.

On your warp-based web site, create a “labs” folder. Create lab1.aspx in your labs folder. (The purpose of this lab1.aspx page is only to hold links to your web service and your client.)

On the web form, describe the API that you are creating. Then, include links to these resources:

  1. Your SOAP XML Web Service “server” endpoint (which will display WSDL info when visited)
  2. Your ASP.NET Web Forms “client” page that consumes the above “server”

Additional detail about these resources follows.


1. Your SOAP XML Web Service “server” endpoint

As noted above, you will serve some data, which will be data that you create, or data from your copy of the Northwind database. The “server” must expose four (4) methods, which serve your data.

Two methods will serve dataset-like data, either a dataset or a datatable. At least one of these methods must take an argument.

The other two methods will serve “plain old XML” (POX). At least one of these methods must take an argument.

Write and comment your web service “server” code so that the WSDL page is informative and fully documented.


2. Your ASP.NET Web Forms “client” page that consumes the above “server”

Create an ASP.NET  Web Forms “client” page that simply consumes your “server” methods, and displays the result on some data display web server controls. Again, you decide what to do and show, just document it, so that I know what your intention is.


Reminder about academic honesty

You must comply with the College’s academic honesty policy. Although you may interact and collaborate with others, submit your own work.


Submitting your work

When you do a lab exercise, you are creating it online on the warp server (or, you are creating it elsewhere, and then copying it to the warp server). Therefore, you do NOT have to submit paperwork to your professor. Just do the lab, and your professor will find it (as long as it is in the right location!).

Reminder: The URL to your Lab 1 should be in the following format (replace “dps907_103a01” with your account name):




Script to copy the Northwind tables – copy the query text (from the following Word 2007 document) into a new query window in SQL Server Management Studio, and then run it:

Copy Northwind Tables


Categories: 2010 Fall DPS907
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: