client side dataset and dataset

  • Thread starter Thread starter Jon Vaughan
  • Start date Start date
J

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 ?
 
Jon said:
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 ?
Click to expand...
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
 
Tomb, checked the datatypes , they are all the same in both dataset and
client side dataset. any more ideas ?
 
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 ?
 
Back
Top