PC Review


Reply
Thread Tools Rate Thread

DataTable.Rows[int i]

 
 
John A Grandy
Guest
Posts: n/a
 
      4th Nov 2008
Apparently, only Int.MaxValue rows may be stored in a DataTable because the
accessor is defined as an int :

DataTable.Rows[int i]


Is this true ? How to handle # rows > Int.MaxValue ? ( aside from
multi-stage load )


 
Reply With Quote
 
 
 
 
Miha Markic
Guest
Posts: n/a
 
      5th Nov 2008
It sucks, doesn't it. The limitations of the number of the rows in a table
that is.
I mean, who can live with only 2147483647 rows in memory?
Seriously, having more than 100 rows is pushing, having more than 1000 rows
is almost too much. Why would you need more than 1000 rows (ok, you can say
2000, but still)?
There are times you need a lot of rows in memory, but certainly not that
much. Othwerwise is a bad design.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message
news:(E-Mail Removed)...
> Apparently, only Int.MaxValue rows may be stored in a DataTable because
> the accessor is defined as an int :
>
> DataTable.Rows[int i]
>
>
> Is this true ? How to handle # rows > Int.MaxValue ? ( aside from
> multi-stage load )
>


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
DataTable.Select vs DataTable.rows.Find vs foreach Dave Microsoft C# .NET 1 17th May 2007 09:06 PM
Updating datatable using datatable.rows.find() Lars E Microsoft C# .NET 1 27th Apr 2006 09:28 AM
Copy just some rows from a datatable to another datatable. UJ Microsoft ADO .NET 3 3rd Jan 2006 09:41 AM
DataTable.Select() - is it possible to pass rows back to datatable =?Utf-8?B?QW5kcmUgUmFuaWVyaQ==?= Microsoft ADO .NET 5 9th Nov 2005 05:10 PM
How can I use real SQL on a DataTable? i.e. not array of rows using a filter... as in DataTable.Select Dan V. Microsoft C# .NET 3 1st Jul 2004 03:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:19 PM.