Webservice with data retrieval

[MLSrinivas]

Hi all,

This is my first task with web services and quite new .NET.

I tried a test webservice with "hello world" and "addnum" functions.
When I tested them, they worked fine. Then in the same service I added
webmethods which interact with database and returns me the output.

When I execute these methods while testing, I'm getting "Page cannot
be displayed" in browser.

How to locate the problem? And what could be the problem?

Please help.

thanks
-srinivas

[Daniel Hobert]

Hi Srinivas,

Unfortunately I don't have an answer, but I'm in the same predicament and
posted a similar message (including my code) in the
microsoft.public.dotnet.framework.aspnet.webservic es news group. If I get a
response or some sort of revelation as to why this is happening I'll be sure
to post the solution here.

Cheers and Good Luck,

Daniel
"MLSrinivas" <ml********@gmail.com> wrote in message
news:d8**************************@posting.google.c om...

Hi all,

This is my first task with web services and quite new .NET.

I tried a test webservice with "hello world" and "addnum" functions.
When I tested them, they worked fine. Then in the same service I added
webmethods which interact with database and returns me the output.

When I execute these methods while testing, I'm getting "Page cannot
be displayed" in browser.

How to locate the problem? And what could be the problem?

Please help.

thanks
-srinivas

[Daniel Hobert]

Hi again,

I was browsing through this newsgroup hoping for an answer when I noticed a
snippet of code in a semi-related thread that I thought might help shed some
light onto why I was unable to retrieve the information necessary and why
the page was incapable of being displayed.

I added the code below to my webMethod that is returning a string of XML
data and suddenly I was able to get to the heart of my issue.

So here goes.

string xmlPlayerList;
try
{
sdaManageRoster.SelectCommand.Connection.Open();
sdaManageRoster.SelectCommand.Prepare();
sdaManageRoster.SelectCommand.Parameters["@player_id"].Value =
player_id;
sdaManageRoster.SelectCommand.Parameters["@is_active"].Value =
is_active;

sdaManageRoster.Fill(dsPlayerList);
xmlPlayerList = dsPlayerList.GetXml();
}
catch(Exception ex)
{
xmlPlayerList = ex.ToString();
}

sdaManageRoster.SelectCommand.Connection.Close();

return xmlPlayerList;

What this did for me was return the exact text of the exception I was
experiencing (but not seeing). The gist of it is that the default user was
not able to execute a stored procedure in the master database and so I was
unable to open the Connection in the first place. Once I put in the
necessary login info and made sure it was saved, my list of players was
successfully returned and displayed on the page.

Of course now I'm faced with the problem of figuring out the best way to
supply the login and password without having it hardcoded into the page
itself, but that's a minor issue compared to tracking down this one.

Cheers and I hope this helps,

Daniel
"MLSrinivas" <ml********@gmail.com> wrote in message
news:d8**************************@posting.google.c om...

Hi all,

This is my first task with web services and quite new .NET.

I tried a test webservice with "hello world" and "addnum" functions.
When I tested them, they worked fine. Then in the same service I added
webmethods which interact with database and returns me the output.

When I execute these methods while testing, I'm getting "Page cannot
be displayed" in browser.

How to locate the problem? And what could be the problem?

Please help.

thanks
-srinivas