Read Method (DB2DataReader)
|
|---|
'Declaration
Public Overrides Function Read() As Boolean |
|
|---|
public override bool Read() |
Return Value
true if there are more rows; otherwise, false.
The following example creates a
DB2Connection, a
DB2Command, and a
DB2DataReader. The example reads through the data, writing it out to the console. Finally, the example closes the
DB2DataReader, then the
DB2Connection.
|
|---|
public void ReadMyData(string myConnString)
{
string mySelectQuery = "SELECT DeptNo, DName FROM Dept";
DB2Connection db2Connection = new DB2Connection(myConnString);
DB2Command db2Command = new DB2Command(mySelectQuery,db2Connection);
db2Connection.Open();
DB2DataReader db2Reader;
db2Reader = db2Command.ExecuteReader();
// Always call Read before accessing data.
while (db2Reader.Read()) {
Console.WriteLine(db2Reader.GetInt32(0) + ", " + db2Reader.GetString(1));
}
// always call Close when done reading.
db2Reader.Close();
// Close the connection when done with it.
db2Connection.Close();
} |
|
|---|
Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT DeptNo, DName FROM Dept"
Dim db2Connection As New DB2Connection(myConnString)
Dim db2Command As New DB2Command(mySelectQuery, db2Connection)
db2Connection.Open()
Dim db2Reader As DB2DataReader
db2Reader = db2Command.ExecuteReader()
' Always call Read before accessing data.
While db2Reader.Read()
Console.WriteLine(db2Reader.GetInt32(0).ToString() + ", " _
+ db2Reader.GetString(1))
End While
' always call Close when done reading.
db2Reader.Close()
' Close the connection when done with it.
db2Connection.Close()
End Sub |
