Read Method (UniDataReader)
|
|---|
'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
UniConnection, a
UniCommand, and a
UniDataReader. The example reads through the data, writing it out to the console. Finally, the example closes the
UniDataReader, then the
UniConnection.
|
|---|
public void ReadMyData(string myConnString)
{
string mySelectQuery = "SELECT DeptNo, DName FROM Test.Dept";
UniConnection myConnection = new UniConnection(myConnString);
UniCommand myCommand = new UniCommand(mySelectQuery,myConnection);
myConnection.Open();
UniDataReader myReader;
myReader = myCommand.ExecuteReader();
// Always call Read before accessing data.
while (myReader.Read()) {
Console.WriteLine(myReader.GetInt32(0) + ", " + myReader.GetString(1));
}
// always call Close when done reading.
myReader.Close();
// Close the connection when done with it.
myConnection.Close();
} |
|
|---|
Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT DeptNo, DName FROM Test.Dept"
Dim myConnection As New UniConnection(myConnString)
Dim myCommand As New UniCommand(mySelectQuery, myConnection)
myConnection.Open()
Dim myReader As UniDataReader
myReader = myCommand.ExecuteReader()
' Always call Read before accessing data.
While myReader.Read()
Console.WriteLine(myReader.GetInt32(0).ToString() + ", " _
+ myReader.GetString(1))
End While
' always call Close when done reading.
myReader.Close()
' Close the connection when done with it.
myConnection.Close()
End Sub |
