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

 

[Guest]

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

 

[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

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

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

 

[Guest]

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

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

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

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]

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

Chris

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

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

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




:

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

 

[Guest]

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

CC

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

Cor

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]

| 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

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

CC

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

Cor

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

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

CC

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

Cor

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