473,563 Members | 2,895 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 ?
Aug 15 '06 #1
3 1569
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
Aug 16 '06 #2
Tomb, checked the datatypes , they are all the same in both dataset and
client side dataset. any more ideas ?

"tomb" <to**@technetce nter.comwrote in message
news:_U******** ***********@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

Aug 17 '06 #3
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" <to**@technetce nter.comwrote in message
news:_U******** ***********@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

Aug 17 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
1931
by: Tom Leylan | last post by:
(I posted this in languages.vb also... I can't figure out where things go if you use a little of a lot of things) Hi all... I'm looking for an example (or a pointer to one) related to the following. I have a WebService (it works) that fetches data, turns it into XML and returns it to a vb.net client. The "data" though represents property...
18
7354
by: cjl | last post by:
Hey all: I know that it is silly in the age of Google to 'lose' something on the internet, but I recently checked out a project that had implemented a database with a subset of SQL in pure client-side javascript. I forgot to bookmark it, and now I can't find it. Anyone?
1
3081
by: Son Matt | last post by:
This is new territory for me so I don't know where to start with a design. I have to render a client side Dataset (5 cols x 20 or more rows) to a canvas. I know I can use Dataset.WriteXML("myfile.xml") but not sure what producing an XML file does for me. I know that if I rename "myfile.XML" to "myfile.HTML" it renders to IE, but it ain't...
8
3040
by: Sue | last post by:
I have a datagrid populated with 6 visible read-only labels and several hidden fields. Below the datagrid, I have a table with various textboxes, dropdowns, etc. I've managed to decypher the client-side coding needed for the user to click a "select" button (HTMLButton) in column 0 of the datagrid and have the table objects auto-fill with...
7
2909
by: Nalaka | last post by:
Hi, I created a sinple web service that returns a dataSet. Then I created a client program that uses this web service (that returns the Dataset). My question is, how did the client figure out to create a "DataSet" as the return type from the webservice?
9
2405
by: CGW | last post by:
I asked the question yesterday, but know better how to ask it, today: I'm trying to use the File.Copy method to copy a file from a client to server (.Net web app under IIS ). It looks to me that when I give a path like @"C:\holdfiles\myfile.txt" it looks on the server C drive. How do I pull from the client? Do I need a different class and/or...
0
1204
by: NH | last post by:
I know how to make client side paging work in the gridiew control using a sqlDataSource (and it works great!). But how can I "code" this i.e. I want to use a dataset as the datasource of the gridview. I have a stored procedure that returns data based on what parameter is passed in to it from the page load event of an asp.net form and then I...
2
1200
by: Visual Systems AB \(Martin Arvidsson\) | last post by:
Hi! Im developing my first client/server application. So ofcourse i got a cople of questions for you gurus out there ;) Created a simple order/detail, with fields and a datagrid, works excelent. Now, in a walkthru i read in the helpfile it updates the grid in three steps.
0
694
by: einnor91 | last post by:
Hi Chosen people, Im developing a download to excel functionality for asp.net. I have grid/dataset. I want to create program that will download to excel the entries of the grid or dataset. As of now, I have a javascript-client side that does the thing. But the problem there is if the Allowpaging of datagrid is True. Then my code only gets...
0
7665
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7583
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7888
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8106
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7950
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6255
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3643
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2082
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
924
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.