windowsforms controls is there any limit to how long of a string SqlDataReader.GetString() can return?

Microsoft	Articles	Forums	Groups
C# .NET
VB.NET
Visual Studio .NET
ADO.NET
Xml/Xslt
VB 6.0
.NET CF
GDI+
LINQ
Deployment
Security
FoxPro
Silverlight / WPF
Entity Framework
RIA Services

Web Programming	Articles	Forums	Groups
JavaScript
ASP
ASP.NET
Web Services

Non-Microsoft	Articles	Forums	Groups
NHibernate
Perl
PHP
Ruby
Java
Linux / Unix
Apple
Open Source

Databases	Articles	Forums	Groups
SQL Server
Access
Oracle
MySQL
Other Databases

Office	Articles	Forums	Groups
Microsoft Excel
Microsoft Word
Microsoft Powerpoint
Publisher
Money

Operating Systems	Articles	Forums	Groups
Windows 7
Windows Server
Windows Vista
Windows XP
Windows Update
MAC
Linux / UNIX

Server Platforms	Articles	Forums	Groups
Share Point
BizTalk
Site Server
Exhange Server
IIS
Transaction Server

Graphic Design	Articles	Forums	Groups
Macromedia Flash
Adobe PhotoShop
Microsoft Expression

Other	Articles	Forums	Groups
Subversion / CVS
Ask Dr. Dotnetsky
Active Directory
Networking
Uninstall Virus
Job Openings
Reviews
Search Engines
Resumes

Previous Thread: ReportViewer

4/18/2006 8:41:38 PM is there any limit to how long of a string SqlDataReader.GetString() can return?

is there any limit to how long of a string SqlDataReader.GetString() can  
  
return?

5/6/2006 9:29:48 PM Re: is there any limit to how long of a string SqlDataReader.GetString() can return?

The string can't be longer than what the field in the database can  
  
handle. For SQL Server that would be 2 GiB for a text field. For a  
  
non-blob field, like varchar, it can't be longer than the data buffer,  
  
which is around 8 kiB.  
  
Daniel wrote: