|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
client side dataset and datasetI 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 Vaughan wrote:
Show quoteHide quote >I have a client side dataset that is made up from a stored proc, I also have Try declaring the client dataset as just a dataset, then loop through >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 ? > > > > 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 ? Show quoteHide quote "tomb" <t***@technetcenter.com> wrote in message news:_UIEg.28189$Uq1.23986@bignews6.bellsouth.net... > Jon Vaughan wrote: > >>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 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 ? Show quoteHide quote "tomb" <t***@technetcenter.com> wrote in message news:_UIEg.28189$Uq1.23986@bignews6.bellsouth.net... > Jon Vaughan wrote: > >>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 
Other interesting topics
Update DataSet
Using OLEDB with Excel What is the correct format for DateTime.Compare ? Using values from one useform in another userform Difficult Task VB.Net Appliction stops working when version is updated IndexOf string method brain death How to read large text file ? ISDATE() took 8 seconds to complete ? |
|||||||||||||||||||||||
