void Page_Load ( Object src, EventArgs e ) {
   if ( !IsPostBack ) {
      // get total records count of data source
      // used for calculating virtual page count ( VirtualItemCount/PageSize )
      myGrid.VirtualItemCount = countRows ( );
      // initialize grid
      bindGrid ( );
   }
}

int countRows ( ) {
   // specify the data source
   OleDbConnection myConn = new OleDbConnection (
      "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " +
      Server.MapPath ( "~/app_data/plans.mdb" ) );

   string query = "SELECT Count ( * ) from Plans";
   OleDbCommand myCommand = new OleDbCommand ( query, myConn );
   myConn.Open ( );
   int rowCount = ( int ) myCommand.ExecuteScalar ( );
   myConn.Close ( );
   return rowCount;
}

sub Page_Load ( byval src as Object, byval e as EventArgs ) {
   if not IsPostBack then
      ' get total records count of data source
      ' used for calculating virtual page count ( VirtualItemCount/PageSize )
      myGrid.VirtualItemCount = countRows ( )
      // initialize grid
      bindGrid ( )
   end if
end sub

function countRows ( ) as integer {
   ' specify the data source
   Dim myConn as OleDbConnection ( _
      "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " &_
      Server.MapPath ( "~/app_data/plans.mdb" ) )

   Dim query as string = "SELECT Count ( * ) from Plans"
   Dim myCommand as new OleDbCommand ( query, myConn )
   myConn.Open ( )
   Dim rowCount as integer = ctype ( myCommand.ExecuteScalar ( ), integer )
   myConn.Close ( )
   return rowCount
end function