Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > XML and Strongly typed datasets

Thread Tools

XML and Strongly typed datasets

Posts: n/a
I'm trying to apply techniques I'd normally use to pull data from SQL/Server
to pull XML from SQL/Server, and I'm running into a problem. Here's what
I'm doing:

1. I've built a stored procedure that pulls my data, and renders it into
proper XML. I'm using 'FOR XML AUTO, ELEMENTS', but I'll bet the issues
would occur with EXPLICIT also.
2. Using VS2005, I've added a DataSet item, and have dragged the sProc into
the dataset so I can access it through a TableAdapter.
3. When I fill the DataTable via the TableAdapter, I get a single column
limited to 2033 characters, so I'm not getting the entire XML tree.

Google has a number of posts regarding using OLEDB / Streaming to get the
data from the 2033 character fields, but none of the posts address the use
of strongly typed datasets and TableAdapters, which are what I'm using.

Can this be done? If so, how?


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
strongly typed datasets Mike P ASP .Net 0 08-30-2006 02:40 PM
SqlCacheDependency and Strongly Typed Datasets chris ASP .Net 2 02-25-2006 02:54 PM
Strongly typed datasets and nested repeaters Duncan Welch ASP .Net 3 04-07-2005 03:37 PM
Strongly typed datasets and XML Big D ASP .Net 1 02-17-2004 11:32 PM
Webservices and strongly typed datasets Thomas Zaleski ASP .Net Web Services 0 07-09-2003 03:38 PM