.NET DataTable.Select Limitation

  • Thread starter Thread starter Raj
  • Start date Start date
R

Raj

Hi,

I'm using DataTable.Select method to select records from my table. That
query that I'm using is a lengthy query with more than 10,000
characters. I'm getting index out of bounds exception. Is there a size
limitation in the DataTable.Select method? If yes, how can I solve this
problem?

Please help..

Thanks,
Raj
 
Can you break your select into multiple selects? Filter the data once for
some criteria and then filter it again from there? A query with more than
10,000 characters should have a way to do this.
 
That wouldn't work, since Select returns an array of rows, not a datatable.
There is no way to further narrow down just an array.

I would recommend to the original poster, to execute SELECT statements that
complicated in the SQL engine directly. Probably better off performance wise
anyway.
 
Sure it would work because the resulting rows could just be put into a
datatable and then another select could be used on that datatable.
 
Back
Top