and when I run my Web Service the WebMethod shows up as ViewPortfolio and I am able to click on it, but when I type in the Stock_Symbol the xml info that I want doesn't show up instead this text does...

1) Use code tags around code
2) Not enough information here for us to see what's going on. What is Stock_Symbol when it gets to this method? What does GetDataPortfolio do?

January 14th, 2010, 04:30 PM

katie_1988

Re: WebMethod or DataSet doesn't work in Web Service

I have a database with two tables in called Stock_Info and Price_Info and I have created a dataset using both of the tables and created a query, which would get the information from the Stock table and the information in the Price table and match the Stock_Symbol to the one that is typed in and sort them in ascending order of Stock_Symbol and then in descending order of Stock_Date, my query is shown below...

When I run my Web Service the WebMethod shows up as ViewPortfolio and I am able to click on it and type in the Stock_Symbol that I want to see the information for but when I click on the invoke button to get my results the xml info that I want doesn't show up instead this text does...