Read Method (SqlShimDataReader)
public override bool Read()
'Declaration
Public Overrides Function Read() As Boolean
Return Value
true if there are more rows; otherwise, false.
The following example creates a
Devart.Data.Bigcommerce.BigcommerceConnection, a
Devart.Data.Bigcommerce.BigcommerceCommand, and a
SqlShimDataReader. The example reads through the data, writing it out to the console. Finally, the example closes the
SqlShimDataReader, then the
Devart.Data.Bigcommerce.BigcommerceConnection.
public void ReadMyData(string myConnString)
{
string mySelectQuery = "SELECT id, lastname FROM customers";
BigcommerceConnection bigcommerceConnection = new BigcommerceConnection(myConnString);
BigcommerceCommand bigcommerceCommand = new BigcommerceCommand(mySelectQuery,bigcommerceConnection);
bigcommerceConnection.Open();
BigcommerceDataReader bigcommerceReader;
bigcommerceReader = bigcommerceCommand.ExecuteReader();
// Always call Read before accessing data.
while (bigcommerceReader.Read()) {
Console.WriteLine(bigcommerceReader.GetString(0) + ", " + bigcommerceReader.GetString(1));
}
// always call Close when done reading.
bigcommerceReader.Close();
// Close the connection when done with it.
bigcommerceConnection.Close();
}
Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT id, lastname FROM customers"
Dim bigcommerceConnection As New BigcommerceConnection(myConnString)
Dim bigcommerceCommand As New BigcommerceCommand(mySelectQuery, bigcommerceConnection)
bigcommerceConnection.Open()
Dim bigcommerceReader As BigcommerceDataReader
bigcommerceReader = bigcommerceCommand.ExecuteReader()
' Always call Read before accessing data.
While bigcommerceReader.Read()
Console.WriteLine(bigcommerceReader.GetString(0) + ", " _
+ bigcommerceReader.GetString(1))
End While
' always call Close when done reading.
bigcommerceReader.Close()
' Close the connection when done with it.
bigcommerceConnection.Close()
End Sub