Web Service Not Returning Data

Hi,

Data from DataTable not showing.

I am currently working on a web service that needs to update information from employees in active directory.
I got a DataSet with two DataTables that returns data from a database. The bellow code is the one I am trying:



[WebMethod(Description = "Get Employee Information From DB1")]


public ServiceDS.EmployeeDataTable GetEmps() {


ServiceDS.EmployeeDataTable empTA = new ServiceDS.EmployeeDataTable();


return empTA;
ServiceDS is the name for the DataSet.

I still have not implemented any code for connecting to ADSI, I am trying to get this simple data to display.


Forgot to mention I am new to web service, so any help will be very appreciated.

Thanks.

 

Hello, I'm new in to web service. I hope some one can help me. I create a web service but in browser it cannot return the anydata from database (http://localhost/website/service.asmx), but from debug.NET, it can return any data from database. (http://localhost:1057/website/service.asmx). Canyou explain to mewhat I need so the web service can run on localhost (may be setting on IIS or I must start any services)? (If needed, I use windows XP professional, Microsoft visual studio 2005).</o>
</o>
Note : if to registry the component asp .net, I already register it using this command aspnet_regiis -i</o>
</o>
Thanks.</o>
</o>
</o>
Here the code:</o>
Public Class Service</o>
Inherits System.Web.Services.WebService</o>
Public strconn As SqlConnection = New SqlConnection("server=local;database=northwind; uid =sa")</o>
Public sda As New SqlDataAdapter</o>
Public objData As New DataSet</o>
<WebMethod()> _</o>
Public Function selectRows(ByVal queryString As String) As DataSet</o>
Try</o>
strconn.Open()</o>
sda.SelectCommand = New SqlCommand(queryString, strconn)</o>
sda.Fill(objData)</o>
strconn.Close()</o>
Catch ex As Exception</o>
strconn.Close()</o>
End Try</o>
Return objData</o>
End Function</o>