Anuradha,
You can do it in advance with a
"Select count from table ...........where..........."
integer Count = Cmd.ExecuteScalar(sqlString,conn)
(Be aware that while reading somebody else can remove a record)
I hope this helps,
Cor
"Anuradha" <an*******@lankaequities.com> schreef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...
Dear Experts
How can I count how many records load to the Data Reader
And if I run while.dataReader.read() loop. will it automatically move to
the next record and loop pls help me
Best regards,
Anuradha