Adding a Web Reference changes DataTypes ???

  • Thread starter Thread starter cc
  • Start date Start date
C

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
 
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
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
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 said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
thanks Peter !
I'll have a look with the tool you suggest.

Chris

Peter Bromberg said:
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 said:
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
Click to expand...
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
Click to expand...
is
used
at the client as well ?

thanks
Chris
Click to expand...
Click to expand...
Click to expand...
 
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 said:
CC

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

Cor

cc said:
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
Click to expand...
Click to expand...
 
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
 
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 said:
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 said:
CC

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

Cor

cc said:
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
Click to expand...
Click to expand...
Click to expand...
 
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 said:
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 said:
CC

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

Cor

cc said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top