dotConnect for Zoho CRM Documentation
Devart.Data Namespace / SqlShimDataReader Class / HasRows Property
Example

In This Topic
    HasRows Property (SqlShimDataReader)
    In This Topic
    Gets a value indicating whether the SqlShimDataReader contains one or more rows.
    Syntax
    'Declaration
     
    Public Overrides ReadOnly Property HasRows As Boolean
    public override bool HasRows {get;}

    Property Value

    true if the SqlShimDataReader contains one or more rows; otherwise, false.
    Remarks
    Note that this property returns true even if all rows were read out.
    Example
    This sample shows how to optimize reading from a data source using HasRows property.
    public void FetchResults(ZohoConnection zohoConnection)
    {
      ZohoCommand cmd = new ZohoCommand("SELECT * FROM Accounts");
      cmd.FetchSize = 100;
      cmd.Connection = zohoConnection;
      zohoConnection.Open();
      try
      {
        ZohoDataReader 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
      {
        zohoConnection.Close();
      }
    }
    Public Sub FetchResults(ByVal zohoConnection As ZohoConnection)
      Dim cmd As ZohoCommand = New ZohoCommand("SELECT * FROM Accounts")
      cmd.FetchSize = 100
      cmd.Connection = zohoConnection
      zohoConnection.Open()
      Try
        Dim reader As ZohoDataReader = 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
        zohoConnection.Close()
      End Try
    End Sub
    See Also