To retrieve data from a web service first make method in 
web service that query to the database and retrieve data 
and return Dataset or the data type which you want to 
retrieve (But web service can only return integer, string, 
arrays, enum, xmlNode, Dataset etc). Make a proxy class for 
your web service using VS or wsdl.exe. Now just make a 
client class, make an object instance of web service in 
your client class, and call the web method using this 
object. I think now you can design code according to your 
need.

dfnjdfjdfj

(1)create a method in webservice as

[WebMethod]
    public string AccBalanceAgingSummary(string FilterBy)
    {
        DataAccess.Report.DailyReport daDailyReport = new 
DataAccess.Report.DailyReport();
        return daDailyReport.AccBalanceAgingSummary
(FilterBy);
    }
(2)