how can i retrieve the record count

• • Reply

  16 years ago

  by anandasa

  anandasa

  , United States

  Joined 17 years ago

  hi
  

  
   I am using sqlclient data reader of ADO.NET to fetch the records. In this thru which property/method I can retrieve the record count?
  

  
  Thanks & Regards
  Anandasa

  Report abuse
• • Reply

  16 years ago

  by NYCSavage

  Tony Savage

  Skelmersdale, England, United Kingdom

  Joined 17 years ago

  I hope this helps but this is what I use (altho I use access):
  

  
  

  Code:

  
  Me.lblNavLocation.Text = (((Me.BindingContext(objNewCustomer, "Customers").Position + 1).ToString + " of  ") _
                     + Me.BindingContext(objNewCustomer, "Customers").Count.ToString)
     

  
  

  
  I create a label named lblNavLocation and link it to the dataset

  Report abuse