"Peter Bromberg [C# MVP]" <pbromberg@yahoo.nospammin.com> wrote in message
news:13FDA5CB-EAD8-487B-82F0-9BC3CCA9AE6A@microsoft.com...
> Put the datatable inside a new DataSet and have the WebMethod return a
> DataSet object.
>
> I don't believe the WebService infrastructure is capable of intelligently
> serializing a datatable by itself.
> Peter
>
> --
> Co-founder, Eggheadcafe.com developer portal:
> http://www.eggheadcafe.com
> UnBlog:
> http://petesbloggerama.blogspot.com
>
>
>
>
> "cc" wrote:
>
> > Hi,
> >
> > I having created a simple WebService (in VS 2005) with just one
WebMethod as
> > follows :
> > [WebMethod]
> > public DataTable GetProducts()
> > {
> > DataTable objDataTable = null;
> >
> > // code for filling up the datatable
> >
> > return objDataTable;
> > }
> >
> > Then, Adding the WebService as a Web Reference to a Client Application
is
> > following proxy code generated
> > at the client for the WebMethod :
> >
> > public GetProductsResponseGetProductsResult GetProducts()
> > {
> > object[] results = this.Invoke("GetProducts", new object[0]);
> > return ((GetProductsResponseGetProductsResult)(results[0]));
> > }
> >
> > Look at the return type of the method :
> > at the server it was defined as DataTable but at the client is it
changed to
> > an unreadable name GetProductsResponseGetProductsResult ???
> >
> > What is happening here ? how can I make sure that the DataTable-type is
used
> > at the client as well ?
> >
> > thanks
> > Chris
> >
> >
> >

> Hi,
>
> I having created a simple WebService (in VS 2005) with just one WebMethod
> as
> follows :
> [WebMethod]
> public DataTable GetProducts()
> {
> DataTable objDataTable = null;
>
> // code for filling up the datatable
>
> return objDataTable;
> }
>
> Then, Adding the WebService as a Web Reference to a Client Application is
> following proxy code generated
> at the client for the WebMethod :
>
> public GetProductsResponseGetProductsResult GetProducts()
> {
> object[] results = this.Invoke("GetProducts", new object[0]);
> return ((GetProductsResponseGetProductsResult)(results[0]));
> }
>
> Look at the return type of the method :
> at the server it was defined as DataTable but at the client is it changed
> to
> an unreadable name GetProductsResponseGetProductsResult ???
>
> What is happening here ? how can I make sure that the DataTable-type is
> used
> at the client as well ?
>
> thanks
> Chris
>
>

"Peter Bromberg [C# MVP]" <pbromberg@yahoo.nospammin.com> wrote in message
news:4E1CBF26-116C-4004-800C-5F1A1B9FB7D9@microsoft.com...
> Ok. The easiest way to figure this out is to look at the SOAP Envelope
that's
> returned by the WebService. YOu can examine the XML and see (for example)
if
> it could be loaded into a DataSet object with ReadXml and provide easy
access
> to the DataTable that way, or it may be that's it's being returned as an
> array. if your web proxy class can't represent it accurately on the client
> side, then you need to look at the raw XML to figure out what is being
> returned to you.
>
> WebService Studio is a nice tool that makes this easy. I think its on
> Gotdotnet.com in the user samples or in a workspace.
>
> Peter
>
> --
> Co-founder, Eggheadcafe.com developer portal:
> http://www.eggheadcafe.com
> UnBlog:
> http://petesbloggerama.blogspot.com
>
>
>
>
> "cc" wrote:
>
> > thanks for the tip !
> >
> > Still, at my company, they are using a WebMethod that returns something
of
> > type DataTable and the proxy code uses DataTable as well !!!
> > And I have been asked to use the same webmethod in my client but can't
get
> > it work !!
> >
> > any idea how the datatable can be maintained ?
> >
> > thanks
> > Chris
> >
> >
> > "Peter Bromberg [C# MVP]" <pbromberg@yahoo.nospammin.com> wrote in
message
> > news:13FDA5CB-EAD8-487B-82F0-9BC3CCA9AE6A@microsoft.com...
> > > Put the datatable inside a new DataSet and have the WebMethod return a
> > > DataSet object.
> > >
> > > I don't believe the WebService infrastructure is capable of
intelligently
> > > serializing a datatable by itself.
> > > Peter
> > >
> > > --
> > > Co-founder, Eggheadcafe.com developer portal:
> > > http://www.eggheadcafe.com
> > > UnBlog:
> > > http://petesbloggerama.blogspot.com
> > >
> > >
> > >
> > >
> > > "cc" wrote:
> > >
> > > > Hi,
> > > >
> > > > I having created a simple WebService (in VS 2005) with just one
> > WebMethod as
> > > > follows :
> > > > [WebMethod]
> > > > public DataTable GetProducts()
> > > > {
> > > > DataTable objDataTable = null;
> > > >
> > > > // code for filling up the datatable
> > > >
> > > > return objDataTable;
> > > > }
> > > >
> > > > Then, Adding the WebService as a Web Reference to a Client
Application
> > is
> > > > following proxy code generated
> > > > at the client for the WebMethod :
> > > >
> > > > public GetProductsResponseGetProductsResult GetProducts()
> > > > {
> > > > object[] results = this.Invoke("GetProducts", new object[0]);
> > > > return ((GetProductsResponseGetProductsResult)(results[0]));
> > > > }
> > > >
> > > > Look at the return type of the method :
> > > > at the server it was defined as DataTable but at the client is it
> > changed to
> > > > an unreadable name GetProductsResponseGetProductsResult ???
> > > >
> > > > What is happening here ? how can I make sure that the DataTable-type
is
> > used
> > > > at the client as well ?
> > > >
> > > > thanks
> > > > Chris
> > > >
> > > >
> > > >
> >
> >
> >