如何返回OracleDataReader? [英] How go back with OracleDataReader?

问题描述

我可以继续使用OracleDataReader，但是
如果要再次循环，如何转到第一条记录?.

OracleDataReader DataResult;


谢谢.
Willy

I can go foward with OracleDataReader but
how can go to the first record if I want to do loop again?.

OracleDataReader DataResult;


Thank you.
Willy

推荐答案

您不能. 文档 [
最好的选择是关闭阅读器并打开一个新阅读器.

You can''t. The documentation[^] states that it''s forward-only;

"Provides a way of reading a forward-only stream of data rows from a data source."

Your best alternative is to close the reader and open a new one.

如上所述，DataReader仅是转发的，如果您需要多次遍历同一数据，则应查看一下通过DataAdapter将数据加载到DataSet中.

As has been mentioned a DataReader is forward only, if you need to loop through the same data multiple times you should look at loading the data into a DataSet via a DataAdapter.

这篇关于如何返回OracleDataReader?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！