Determining size of recordset column

		Wrox Programmer Forums > .NET > Other .NET > ADO.NET
Determining size of recordset column

ADO.NET For discussion about ADO.NET.Â Â Topics such as question regarding the System.Data namespace are appropriate.Â Â Questions specific to a particular application should be posted in a forum specific to the application .

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

May 27th, 2004, 04:12 AM

gp_mk

Authorized User

Join Date: Nov 2003

Posts: 78

Thanks: 0

Thanked 0 Times in 0 Posts

Determining size of recordset column

Does anyone know if it is possible to determine the size of a dataset column at runtime? I am using ADO.NET with System.Data.SqlClient and System.Data.OracleClient

I need to output the results of a query, and need to know the maximum size (characters) of each column in order to format the output correctly. The ds.Tables[0].Columns[i].MaxLength property always seems to return 0, so I can't use that.

Cheers,
Gary

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Determining Which Column is Primary Key	1kHz	SQL Language	4	August 16th, 2010 09:16 AM
Determining the cache size	easwars	C++ Programming	0	January 28th, 2007 12:33 PM
Loading a jpg and determining the pixel size	jaucourt	Flash (all versions)	0	January 19th, 2005 07:09 AM
how to add new column to recordset??	huela	Access VBA	0	October 13th, 2004 01:22 PM
Recordset size is always 100	CHARALYI	Classic ASP Professional	2	June 14th, 2004 12:11 AM