Web Service - Passing Dataset Problem

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

Web Service - Passing Dataset Problem

Author

Topic

BigMeat
Yak Posting Veteran

56 Posts

Posted - 2005-08-17 : 03:00:35

Hi

I am new to web services and I am trying to use them in my app. I am trying to pass a dataset in from my DAL to my ASP.NET web site via web services.

I have created a strongly typed Dataset in my DAL called dsCap which has a table called Areas in it. I then use the following web service to call this dataset

<WebMethod()>_
Public Function getAreas(ByVal ctrl as baseControl, Byval dt as dsCap.AreasDataTable) as dsCap.AreasDataTable

Dim db As New myComponent(ctrl.conn) 'This is a class that holds my data adapter and I just pass it a conn string
db.daAreas.Fill(dt) 'This calls my data adapter and populates my datatable

return dt

End Function

However when I run this web service I get teh following error:

"You must implement the Add(System.Object) method on myProjectName.dsCap+AreasDataTable because it inherits from IEnumable"

I dont understand why I get this error..... any help would be much appreciated

Is this problem occuring because im passing a strongly typed dataset?

thanks in advance

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources