C#

I'm trying to read eventlogs from a server which has about 100 000 records using class EventLogReader(eventLogQuery).

I'm using pagination and each page will show only 25 records in my screen. So, I will be reading 25 records out of total records for the first page and next 25 records for the second page and so on.

My question is how to get the total records count for the below snippet like total rows affected because of that eventLogQuery applied on full set of events?

EventLogReader reader = new 
EventLogReader(eventLogQuery);
                reader.Seek(SeekOrigin.Begin, filter.PageStart);

eventLogs.TotalLogs = **totalRowsAffected**;                    
EventRecord eventInstance = reader.ReadEvent();

int i = filter.PageSize;
while (eventInstance != null && i-- > 0)
{
 try
 {
  eventLogs.Entries.Add(new EventLogData
  {
   Type = eventInstance.LevelDisplayName,
   Source = eventInstance.ProviderName,
   Time = eventInstance.TimeCreated,
   Category = eventInstance.TaskDisplayName,
   EventId = eventInstance.Id,
   User = eventInstance.UserId != null ? eventInstance.UserId.Value : "",
   Computer = eventInstance.MachineName,
   Message = eventInstance.FormatDescription(),
   FullXml = eventInstance.ToXml()
  });
 }catch{}
eventInstance = reader.ReadEvent();
}
}
return eventLogs;

		class public DBCall
{
private string connection_string = "...";

private void SomeMethod()
{
     var zipcode = ExecuteScalar<string>("select zipcode from ZIpcodes where Zip='92108'", connection_string);

}

public T ExecuteScalar<T>(string queryString, string connection_string)
		{
			using (OleDbConnection conn = new OleDbConnection (connection_string))
			{
				using (OleDbCommand cmd = new OleDbCommand (queryString , conn))
				{
					var result = cmd.ExecuteScalar ( );

					if (Convert.IsDBNull (result) && typeof (T).IsValueType)
						return default (T);                                         // if the db value is null, but T is a value type, set T = the default value of the type.
					else
						return (T) (result);
				}
			}
		}

		private void treeView1_NodeMouseClick(object sender , TreeNodeMouseClickEventArgs e)
		{

			if (e.Button == MouseButtons.Left)
			{
				string loadrowset = e.Node.Text;
				Rowset rowset = (Rowset) Enum.Parse (typeof (Rowset) , loadrowset);
				using (OleDbConnection conn = new OleDbConnection (ConnectionString))
				{
					OleDbSchemaTable s = new OleDbSchemaTable (rowset , conn);

					DataTable dt = new DataTable ( );
					dt = s.datatable;

					dataGridView1.Enabled = true;
					dataGridView1.DataSource = dt;	
				}

			}
			else
			{
				return;
			}

		}

private (string, int, string) getstuff()
{ 
    return (S1: "boo", I1: 99, S2: "ddd");
}

private (String S1, int I1, string S2) getstuff()
{ 
    return ("boo", 99, "ddd");
}

public (string S1, int I1, string S2) VTProp {set; get;}