Hi Gary,
The ntext data type is mapped to a string or a char array when filled in to
a dataset. You can use a DataAdapter to retrieve it and get it from the
result set.
Please refer to the following link for more information on Mapping .NET
Framework Data Provider Data Types to .NET Framework Data Types:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconmappingnetdataproviderdatatypestonetframeworkdatatypes.asp
If anything is unclear, please feel free to reply to the post.
Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
--------------------
| From: "bruce barker" <
[email protected]>
| References: <
[email protected]>
| Subject: Re: ntext from SQL Server 2000
| Date: Thu, 6 Nov 2003 14:51:48 -0800
| Lines: 23
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
| Message-ID: <
[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| NNTP-Posting-Host: rdcsd1.safeco.com 12.144.134.2
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftngp13.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:65696
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| until yukon, ntext can only be returned in a result set (datarow)
|
| -- bruce (sqlwork.com)
|
|
| | > How do I return an ntext value from a stored procedure?
| >
| > I have a table which has an ntext column (among others).
| > I am writing a stored procedure to return a single row's
| > ntext value. I pass in the equivalent of the row ID for
| > the where clause but I cannot return the ntext.
| >
| > Should it be an output parameter?
| >
| > Must it be part of a rowset returned?
| >
| > Many thanks for reading this,
| > Gaz
| >
|
|
|
