Inhildipied
New Member
I have an XML with following structure:\[code\]<table name="tblsiccodes"> <row> <sSICCode>0888</sSICCode> </row> <row> <sSICCode>0900</sSICCode> </row> <row> <sSICCode>1000</sSICCode> </row> <row> <sSICCode>1040</sSICCode> </row> <row> <sSICCode>1044</sSICCode> </row> <row> <sSICCode>1090</sSICCode> </row> <row> <sSICCode>1220</sSICCode> </row> <row> <sSICCode>1221</sSICCode> </row></table>\[/code\]and I need to pick the description for each of SIC code from this site http://www.epa.gov/enviro/html/sic_lkup.htmlor this sitehttp://www.sec.gov/info/edgar/siccodes.htmWhat will be easiest way using vb.net to get description for each SIC from the website? I can not modify this XML file. Do I need to create a collection with SIC code and description manually copied to it and then get description of SIC code in XMl by matching SIC code with collection ? Final collection will be used to populate a repeater with each item/row having SIC code and Industry Name.Do I need to do screen scrapping ? I don't think that these websites have some API/service using which I can get industry namesI can not use HTMl agility pack or any other third party library except Jquery.Please suggest.