Adding a Web Reference changes DataTypes ???

[cc]

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]]

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

[cc]

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]" <pb*******@yahoo.nospammin.com> wrote in message
news:13**********************************@microsof t.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

[Peter Bromberg [C# MVP]]

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]" <pb*******@yahoo.nospammin.com> wrote in message
news:13**********************************@microsof t.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

[Cor Ligthert [MVP]]

CC

I would use VB Net that is much simpler for this,

Cor

"cc" <cm****@yahoo.com> schreef in bericht
news:44***********************@news.skynet.be...

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

[cc]

thanks Peter !
I'll have a look with the tool you suggest.

Chris

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:4E**********************************@microsof t.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]" <pb*******@yahoo.nospammin.com> wrote in message news:13**********************************@microsof t.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
>
>
>

[Peter Bromberg [C# MVP]]

Cor,
With all due respect, and notwithstanding the fact that you are posting to
the C# newsgroup and then advising posters that using VB.NET can solve their
issues better, I fail to see what VB.NET can do for this individual that he
can't do with C#, which is the programming language he has chosen?
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Cor Ligthert [MVP]" wrote:

CC

I would use VB Net that is much simpler for this,

Cor

"cc" <cm****@yahoo.com> schreef in bericht
news:44***********************@news.skynet.be...

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

[William Stacey [MVP]]

It was a crosspost, but I agree totally agree Peter.

--
William Stacey [MVP]

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> wrote in message
news:10**********************************@microsof t.com...
| Cor,
| With all due respect, and notwithstanding the fact that you are posting to
| the C# newsgroup and then advising posters that using VB.NET can solve
their
| issues better, I fail to see what VB.NET can do for this individual that
he
| can't do with C#, which is the programming language he has chosen?
| Peter

[Cor Ligthert [MVP]]

Peter,

I completely agree with you, I could not resist doing it like this, it was a
trap. However, the OP did not ask "why". If he had done I would have written
than "why do you post than to the language.vb newsgroup"

It was just trying another approach, but the OP did not go into the trap.

:-)

Cor

"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> schreef in bericht
news:10**********************************@microsof t.com...

Cor,
With all due respect, and notwithstanding the fact that you are posting to
the C# newsgroup and then advising posters that using VB.NET can solve
their
issues better, I fail to see what VB.NET can do for this individual that
he
can't do with C#, which is the programming language he has chosen?
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Cor Ligthert [MVP]" wrote:

CC

I would use VB Net that is much simpler for this,

Cor

"cc" <cm****@yahoo.com> schreef in bericht
news:44***********************@news.skynet.be...

> 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
>
>

[Cor Ligthert [MVP]]

Peter,

There was something more that I almost forgot.

I wrote in my idea nothing wrong, however I could have placed two words
extra.

"I would use VB Net that is much simpler for this, *for me*".

But I thought that that was obvious because I wrote *I would* .

:-)

Cor

I wrote
"Peter Bromberg [C# MVP]" <pb*******@yahoo.nospammin.com> schreef in bericht
news:10**********************************@microsof t.com...

Cor,
With all due respect, and notwithstanding the fact that you are posting to
the C# newsgroup and then advising posters that using VB.NET can solve
their
issues better, I fail to see what VB.NET can do for this individual that
he
can't do with C#, which is the programming language he has chosen?
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Cor Ligthert [MVP]" wrote:

CC

I would use VB Net that is much simpler for this,

Cor

"cc" <cm****@yahoo.com> schreef in bericht
news:44***********************@news.skynet.be...

> 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
>
>