Listing 1 Script to create table

--
-- This command file reloads a database that was unloaded using "dbunload".
--
-- ( Version :  10.0.0.2465)
--



-------------------------------------------------
--   Create tables
-------------------------------------------------

CREATE TABLE "DBA"."Media" (
    "ItemID"                         long varchar NOT NULL
   ,"Author"                         long varchar NULL
   ,"Manufacturer"                   long varchar NULL
   ,"Title"                          long varchar NULL
)
go

ALTER TABLE "DBA"."Media"
    ADD UNIQUE ( "ItemID" )
go

commit work
go


-------------------------------------------------
--   Create indexes
-------------------------------------------------

commit work
go


-------------------------------------------------
--   Create triggers
-------------------------------------------------

commit
go

Listing 2 SQL script to create procedure

call sa_make_object('procedure', 'ItemLookup');
alter procedure ItemLookup(IN @UPC char(13))
begin
SELECT ItemID, Author, Manufacturer, Title
FROM Media
WHERE ItemID = @UPC;
end;

Listing 3 Button code

            int sqlCode;

            localhost.ItemLookupWSDL webService = new TestOurAmazonItemLookup.localhost.ItemLookupWSDL();

            DataSet results = webService.OurAmazonItemLookup(textBoxItemID.Text, out sqlCode);

            DataTableReader reader = results.CreateDataReader();

            while(reader.Read())
            {
                labelItemID.Text = reader.GetString(0);
                labelTitle.Text = reader.GetString(1);
                labelManufacter.Text = reader.GetString(2);
                labelAuthor.Text = reader.GetString(3);
            }