tags:

views:

28

answers:

1
Q: 

Is there a limit to the number of DataColumns I can add to a DataTable?

I can't find any references to there being a limit to the number of DataColumns I can add to a DataTable. The DataTable will not be generated from a SQL query, but rather synthesized from other data.

Thanks, Matthew

+2  A: 

The Method signatures for AddAt and RemoveAt and Item for the DataColumnCollection class all take Int32. This is the object that the DataTable Class uses to store the columns.

This means it can have 2,147,483,647 columns give or take 1 or 2 for good measure. :)

klabranche  2009-09-02 21:06:41
Or until you run out of memory
Chuck Conway  2009-09-02 21:07:53
Or until you get hit in the head for having a design where you have so many columns that you have to worry about the limit. lol
Max Schmeling  2009-09-02 21:09:24
Great comments!!!! :)
klabranche  2009-09-02 21:53:06

related questions

What is the best data access paradigm for scalability?
Output parameters not readable when used with a DataReader
Handling empty values with ADO.NET and AddWithValue()
ADO.NET Entity Framework tutorials
How do you create a database from an EDM?
Old-school SQL DB access versus ORM (NHibernate, EF, et al). Who wins?
How to log in T-SQL
Anyone using the Entity Framework *Well*?
What are the disadvantages of Typed DataSets
What's the best way to detect if an IDataReader is empty?
What real-world usages of ADO.NET Entity Framework do you know?
Where WCF and ADO.Net Data services stand?
Flex and ADO.NET Data Services...anyone done it?
Simulating queries of large views for benchmarking purposes
How to Catch an exception in a using block with .NET 2.0?
How can I retrieve a list of parameters from a stored procedure in SQL Server
How do you prevent leading zeros from being stripped when importing an excel doc using c#
ADO.NET Mapping From SQLDataReader to Domain Object?
ADO.NET Entity vs NHibernate
[ADO.NET ERRROR]: CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file HelloWorld.mdf failed...
[ADO.NET] What's the deal with |Pipe-delimited| variables in connection strings?
[ADO.NET] System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
ADO.NET Connection Pooling & SQLServer
How do you persist a tree structure to a database table with auto incrementing IDs using an ADO.NET DataSet and a DataAdapter
How to learn ADO.NET