client side dataset and dataset

[Jon Vaughan]

I have a client side dataset that is made up from a stored proc, I also have
a web service that returns a dataset from this stored proc. But when I call
the web service and try and store them in an instance of the client side
dataset , I get an invalid cast error.

example :

dim myclientds as new clientsidedataset
dim objwebservice as web.myservice

myclientds = objwebservice .getData

- causes an invalid cast, the dataset are indentical ,as they stem from the
same SP , the only difference is that datset / datatable name.

Any ideas ?

 

[tomb]

I have a client side dataset that is made up from a stored proc, I also have
a web service that returns a dataset from this stored proc. But when I call
the web service and try and store them in an instance of the client side
dataset , I get an invalid cast error.

example :

dim myclientds as new clientsidedataset
dim objwebservice as web.myservice

myclientds = objwebservice .getData

- causes an invalid cast, the dataset are indentical ,as they stem from the
same SP , the only difference is that datset / datatable name.

Any ideas ?

Try declaring the client dataset as just a dataset, then loop through
the columns to see what the data types are - most likely the transition
from the web service to the client is altering something in the structure.

T

 

[Jon Vaughan]

Tomb, checked the datatypes , they are all the same in both dataset and
client side dataset. any more ideas ?

 

[Jon Vaughan]

Th eonly different is the datset from the xsd has the table called Suppliers
, whereas the data side created from the webservice is called table , could
that be it ?