XML and strongly typed datasets

TheMSsForum.com: The Microsoft Software Forum

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?

Thanks
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?

Thanks
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?

Thanks
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?

Thanks
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?

Thanks
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?

Thanks
Top

Re: XML and strongly typed datasets by John

John
Fri Aug 17 12:18:51 CDT 2007



--
John Saunders [MVP]

"Ben" <bf001nospamplease@abovetheline.biz> wrote in message
news:uiB$omN4HHA.3400@TK2MSFTNGP03.phx.gbl...
> 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?
>
> Thanks

What kind of connection are you using? If you are using the SQL Native
Client, you should be able to handle columns of the new XML type.
--
John Saunders [MVP]

Top