'Declaration Public Overrides ReadOnly Property FieldCount As Integer
public override int FieldCount {get;}
'Declaration Public Overrides ReadOnly Property FieldCount As Integer
public override int FieldCount {get;}
public void FetchResults(BigcommerceConnection bigcommerceConnection) { BigcommerceCommand cmd = new BigcommerceCommand("SELECT * FROM customers"); cmd.FetchSize = 100; cmd.Connection = bigcommerceConnection; bigcommerceConnection.Open(); try { BigcommerceDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { for (int i=0;i<reader.FieldCount;i++) { Console.Write("\t"+reader[i]); } Console.WriteLine(); } } finally { bigcommerceConnection.Close(); } }
Public Sub FetchResults(ByVal bigcommerceConnection As BigcommerceConnection) Dim cmd As BigcommerceCommand = New BigcommerceCommand("SELECT * FROM customers") cmd.FetchSize = 100 cmd.Connection = bigcommerceConnection bigcommerceConnection.Open() Try Dim reader As BigcommerceDataReader = cmd.ExecuteReader() While reader.Read() Dim i For i = 0 To reader.FieldCount - 1 Console.Write(String.Concat(" ", reader(i))) Next i Console.WriteLine() End While Finally bigcommerceConnection.Close() End Try End Sub