I have an asp.net page called default.

The page has 3 fields: patientid, userid and resourceid.


I need to develop a web service that will use the patientid and resourceid fields to query a table called resource. The resource table contains the following fields:

Resourceid,resource,patientid,recorded and resourcefile.

The web service should use the patientid and resourceid parameter from the default.aspx page and display the resourcefile which is an image data type on an image.aspx file.

The userid parameter should be used to track who accessed the resource file and should update a log table which has the following fields: userid, patientid and resourceid and datetime.

I have not developed a webservice before how would I go about doing this?


Sanjeet

__________________
Sanjeet

3 questions:


1.
I have created a web service to handle the database functionlity. I need to pass three parameters to the web service:
userid, patientid and resourceid. function should return an Image data type.
I get an error message stating: Key word is not a valid identfier. This

 <WebMethod()> _
    Public Function RetreiveImage(string userid,string patientid,string resourceid) As String

    End Function



2. After I retreive the image data type I need to update a log table in the database. Can I do this within the same function?

3. The sql statement should query based on patient and resource id. How do I pass the paramters in the embedded sql?

Sanjeet