namespace NorthWindTableAdapters
{    
   public partial class CustomersTableAdapter    
   {        
      public DataTable GetData(int startRowIndex, int maximumRows, string sortExpression)        
      {            
         NorthWind.CustomersDataTable dt = new NorthWind.CustomersDataTable();       

         int topRows = startRowIndex + maximumRows;        

         if (!string.IsNullOrEmpty(sortExpression))                
            sortExpression = " order by " + sortExpression;

         OleDbDataAdapter adapter = new OleDbDataAdapter();            
         adapter.SelectCommand = new OleDbCommand();            
         adapter.SelectCommand.CommandText = "Select TOP " + topRows.ToString() + " * FROM Customers" + sortExpression;            
         adapter.SelectCommand.Connection = this.Connection;      

         adapter.Fill(dt);             

         return dt;        
      }
   
      public int SelectCount(string sortExpression)        
      {            
         this.Connection.Open();            
         OleDbDataAdapter adapter = new OleDbDataAdapter();            
         adapter.SelectCommand = new OleDbCommand();            
         adapter.SelectCommand.CommandText = "Select COUNT(*) From Customers";
         adapter.SelectCommand.Connection = this.Connection;

         int result = (int)adapter.SelectCommand.ExecuteScalar();            
         this.Connection.Close();     

         return result;        
      }    
   }
}