client side dataset and dataset

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Jon Vaughan
    #1

    client side dataset and dataset

    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 clientsidedatas et
    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 ?


    Tags: None
    • tomb
      #2
      Re: client side dataset and dataset

      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 clientsidedatas et
      >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

        Comment

        • Jon Vaughan
          #3
          Re: client side dataset and dataset

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

          "tomb" <tomb@technetce nter.comwrote in message
          news:_UIEg.2818 9$Uq1.23986@big news6.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 clientsidedatas et
          >>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

            Comment

            • Jon Vaughan
              #4
              Re: client side dataset and dataset

              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 ?


              "tomb" <tomb@technetce nter.comwrote in message
              news:_UIEg.2818 9$Uq1.23986@big news6.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 clientsidedatas et
              >>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

                Comment

                Previous template Next
                Working...