Maximum Rows for a datatable and data readers

[napstar]

What is maximum number of rows a datatable, OleDbDataReader and SqlDataReader can hold?

[Plater]

I'm not sure actually. I've used a datatable with up to around 40k I think. Takes a very long time to do anything with though.

[Curtis Rutland]

I've actually loaded a DataTable with over 2 million records once...not on purpose; I forgot to code in my WHERE clause :/

It crashed because I ran out of memory but it kept loading. I think that the maximum theoretical rows is less important than what you can actually fit in memory and still be useful.