title: Select Distinct and Count in Grid View
body: <p>I need some help....</p>
  
  <p>this is the example of my database table:</p>
  
  <pre><code>Record_ID    User_ID    Record
  -------------------------------
  001          A111111    file1
  002          A111111    fileq
  003          A222222    file2
  004          A222222    file3
  005          A111111    file4
  006          A333333    file5
  007          A333333    file6
  </code></pre>
  
  <p>I want it to show up in Grid view like below:</p>
  
  <pre><code>User_ID    Total_Record
  -----------------------
  A111111         3
  A222222         2
  A333333         2
  </code></pre>
  
  <blockquote>
    <p>SELECT count(*) as total_record FROM Table where user_id</p>
  </blockquote>
  
  <p>I know the sql syntax but I don't know how to create the grid view for show result this query 
  please help me</p>