title: how to apply paging on a list
body: <p>I have a function that retrieves data from database and add it into list. My list is ready and shows the data but i want paging on that list so that it shows limited records per page. but no idea about how to do that.<br>
  Here is my code of that data layer function.  </p>
  
  <pre><code> public List&lt;demodto&gt; executereader(List&lt;demodto&gt; Ldemo,SqlCommand cmdshow, string tablename)
      {
           SqlConnection cn;
           try
           {
               cn = this.getconnection();
  
               cmdshow.Connection = cn;
               cn.Open();
  
               SqlDataReader rd = cmdshow.ExecuteReader();
               while (rd.Read())
               {
                   demodto dtoobj1 = new demodto();
                   dtoobj1.ID = Convert.ToInt32(rd[0].ToString());
                   dtoobj1.Name = rd[1].ToString();
                   dtoobj1.PhNo = Convert.ToInt32(rd[2].ToString());
                   dtoobj1.Address = rd[3].ToString();
                   dtoobj1.Gender = rd[4].ToString();
                   dtoobj1.Email = rd[5].ToString();
                   dtoobj1.Emptype = rd[6].ToString();
  
                   Ldemo.Add(dtoobj1);
  
               }
               cn.Close();
               return Ldemo;
           }
           catch (Exception ex2)
           {
               throw new DataException("error....." + ex2.Message);
  
           }
  
      }
  </code></pre>
  
  <p>And this is for DTO class..  </p>
  
  <pre><code> public class demodto
  {
      public Int32 ID{get;set;}
      public string Name{get;set;}
      public Int32 PhNo { get; set; }
      public string Address{get;set;}
      public string Gender { get; set; }
      public string Email { get; set; }
      public string Emptype { get; set; }
   }
  </code></pre>
  
  <p>please help me. Thanks.</p>