OleDbDataReader only reads 29,991 of 95,526 records

Asked Jul 03 '13 at 20:27

Active Jul 03 '13 at 20:28

Viewed 110 times

I'm using an OleDbDataReader, but it only reads 29,991 of 95,526 records:

OleDbCommand command = new OleDbCommand("select * from [data$]", connection);
using (OleDbDataReader dr = command.ExecuteReader())
{
    while (dr.Read())
    {
        c++;
        row1Col0 = dr[0].ToString();

    }
    Console.WriteLine(c);
}

Why doesn't it read all records?

edited Jul 03 '13 at 20:28

Danny Beckett

20,529
24
107
134

asked Jul 03 '13 at 20:27

Faisal Sajjad

1

Did you have a try/catch block around this code? Did you catch the exception (if any) and show a message on video? – Steve Jul 03 '13 at 20:29
1

So what actually happens? Does it give an error? Or does the `dr.Read()` call actually return false as if there is no more data? – Tim Jul 03 '13 at 20:30
3

Well just because **95,526 - 29,991 = 65,535**, I suppose there might be an overflow somewhere with a 16-bit integer on the way. – Roman R. Jul 03 '13 at 20:35
i use try/catch block but it not throws any exception, – Faisal Sajjad Jul 03 '13 at 20:50
i use 32 bit integer but result is same , it doesn't give any error it simply prints the result – Faisal Sajjad Jul 03 '13 at 20:52
The database server is Oracle? – Alex Filipovici Jul 03 '13 at 22:15

OleDbDataReader only reads 29,991 of 95,526 records

0 Answers0