前面的课程包含了使用SqlDataReader的代码，但是关于前面课程中的细节的讨论我们推迟了。这节课建立自你所见到的并解释如何使用SqlDataReader。

As explained earlier, the SqlDataReader returns data via a sequential stream.  To read this data, you must pull data from a table row-by-row.  Once a row has been read, the previous row is no longer available.  To read that row again, you would have to create a new instance of the SqlDataReader and read through the data stream again.

前面已经解释了，SqlDataReader通过顺序数据流返回数据。为了读取这些数据，你必须从一个表中一行一行的取出数据。只要一行被读取，之前的数据就不再有效。为了再次读取那行，你应该创建一个新的SqlDataReader实例并且再次从数据流中读取它。

The typical method of reading from the data stream returned by the SqlDataReader is to iterate through each row with a while loop.  The following code shows how to accomplish this:

从SqlDataReader中读取返回的数据流的典型方法是通过while循环迭代没一行。下面的代码显示了如何完成：

        while (rdr.Read())

        {

               // get the results of each column

               string contact = (string)rdr["ContactName"];

               string company = (string)rdr["CompanyName"];

               string city    = (string)rdr["City"];

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9] [10]  ...  下一页 >>