'Declaration Public Overrides ReadOnly Property HasRows As Boolean
public override bool HasRows {get;}
'Declaration Public Overrides ReadOnly Property HasRows As Boolean
public override bool HasRows {get;}
public void FetchResults(QuickBooksConnection quickBooksConnection) { QuickBooksCommand cmd = new QuickBooksCommand("SELECT * FROM Customer"); cmd.FetchSize = 100; cmd.Connection = quickBooksConnection; quickBooksConnection.Open(); try { QuickBooksDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { for (int i=0;i<reader.FieldCount;i++) { Console.Write("\t"+reader[i]); } Console.WriteLine(); } } else { Console.WriteLine("No rows detected."); } } finally { quickBooksConnection.Close(); } }
Public Sub FetchResults(ByVal quickBooksConnection As QuickBooksConnection) Dim cmd As QuickBooksCommand = New QuickBooksCommand("SELECT * FROM Customer") cmd.FetchSize = 100 cmd.Connection = quickBooksConnection quickBooksConnection.Open() Try Dim reader As QuickBooksDataReader = cmd.ExecuteReader() If reader.HasRows Then While reader.Read() Dim i For i = 0 To reader.FieldCount - 1 Console.Write(String.Concat(" ", reader(i))) Next i Console.WriteLine() End While Else Console.WriteLine("No rows detected.") End If Finally quickBooksConnection.Close() End Try End Sub