return multi-table value from ASP.NET webservice

See more:

ASP.NET

webservice

Hi All,
This question is regarding the ASP.NET webservice that i am creating using the DAL-BLL architecture for my final school project.

Here is some more information:
I am using the SQL dataset (.xsd) in DAL. So i have a datatable called "Insurance", which has a tableAdapter. One of the queries in the adapter references to a stored procedure, which has an inner join. So my SP looks like:

ALTER PROCEDURE dbo.GetInsurancesPaged
       (
           @startRowIndex int,
           @maximumRows int,
           @patientID int
       )
   AS
       select * from
       (
       SELECT Insurance.insuranceID, Insurance.memberID, Insurance.groupID, Insurance.accountType, Insurance.comments, Insurance.patient, Insurance.company, InsuranceCompany.companyID, InsuranceCompany.companyName, InsuranceCompany.address, InsuranceCompany.phone, InsuranceCompany.fax, ROW_NUMBER() over (order by Insurance.dateModified DESC) as ROWRANK
   FROM Insurance INNER JOIN InsuranceCompany ON Insurance.company = InsuranceCompany.companyID
   WHERE Insurance.patient = @patientID
       )
       AS DataWithRowNumbers
   WHERE ROWRANK > @startRowIndex AND ROWRANK <= (@startRowIndex + @maximumRows)

So this SP returns a datatable which will be a combination of the 2 tables in the inner join.

Now in my BLL, i have:

[System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public mySys.InsuranceDataTable GetInsurancesPaged(int startRowIndex, int maximumRows, int patientID)
        {
           return insAdapter.GetInsurancesPaged(startRowIndex, maximumRows, patientID);
        }

where insAdapter is an instance of insuranceTableAdapter

This gives an error on execution.

I can execute the SP successfully, so i think the problem is only because i am trying to return a wrong datatable from the BLL. Help greatly appreciated.