Use foreach to read records

The foreach statement structure in C # is used for read-only and sequential traversal of all elements in a set. The set must implement the system. Collections. ienumerable interface. The foreach statement can simplify the traversal of a set. CodeThe code looks fresh and concise. The foreach statement is derived from the VB for each statement.
To quickly access the database, we generally use the system. Data. idatareader interface to access data. This interface provides read-only and sequential access query results. The two are both "read-only and sequential" features, narrowing the relationship between the two. For this reason, the younger brother is in the system. data. the idatareader interface sets an implementation system. collections. the shell of the ienumerable interface, so that we can use foreach to read the query results. This can avoid generating a large number of struct objects and save memory. The younger brother made a demonstration. ProgramIt is very simple. There are no more than 100 rows. I hope you can use them. It is a command line program and uses demomdb. MDB in the program directory as the demo database. Program http://files.cnblogs.com/xdesigner/foreach_record.rar