[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 535
  • Last Modified:

web service in excel 2007

I have this store procedure
alter PROCEDURE padron.BuscarPorNumeroDocumento
@numdle nchar(16)
as
select PDR.NUMDLE, PDR.APEPAT, PDR.APEMAT, PDR.NOMBRE
from   padron.padron_20091121 PDR
      INNER JOIN padron.ubigeo_20091121 UBI
      ON PDR.coddep=UBI.coddep
            and PDR.codpro=UBI.codpro
                            and PDR.coddis=UBI.coddis
where PDR.NUMDLE = @numdle

This stored procedure is part of a web service:
service name = BuscarPadronServicio
method name = BuscarPorNumeroDocumento
service found = consultaPadron
reference name web = net.padron.amag.api
VIEW FILE

I want to consume it from an excel sheet, that's why I created a project such as Excel 2007 Workbook, I can not find much information, what I could do is:
using Tools = Microsoft.Office.Tools.Excel;
using BuscarPadron = WebServiceConsumer.net.padron.amag.api;

public void DisplayWebServiceResults (string searchterm)(
 paramMissing = System.Type.Missing object;

 / / Clear the current display.
 Tools.NamedRange range = (Tools.NamedRange) this.Controls ["Data"];
 range.Clear ();

 / / Call the Web service.
 BuscarPadron.BuscarPadronServicio BuscarPadron.BuscarPadronServicio service = new ();

)

I'm helping this URL http://msdn.microsoft.com/en-us/library/dd819156 (office.12). Aspx
but I can not do

I am using  Visual Studio 2008
If there is a solution in Excel 2003 no problem

1-web-service.jpg
2-addReferenceWEB.jpg
0
enrique_aeo
Asked:
enrique_aeo
1 Solution

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now