title: Convert SqlDataSource to DataTable and DataView
body: <p>I have the following <code>SqlDataSource</code> and I want to convert it to <code>DataView</code> and read a column from it:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT     
      dbo.Divisions.DivisionShortcut, 
      COUNT(DISTINCT dbo.UserQuiz.Username) AS [Number of Participants]
  FROM         
      dbo.Divisions 
  INNER JOIN
      dbo.employee ON dbo.Divisions.SapCode = dbo.employee.DivisionCode 
  INNER JOIN
      dbo.UserQuiz ON dbo.employee.Username = dbo.UserQuiz.Username 
  INNER JOIN
      dbo.Quiz ON dbo.UserQuiz.QuizID = dbo.Quiz.QuizID
  WHERE     
      (dbo.Quiz.QuizID = @QuizID)
  GROUP BY 
      dbo.Divisions.DivisionShortcut
  </code></pre>
  
  <p>This <code>SqlDataSource</code> lets the user enter the number of the Quiz, and it will retrieve the total number of participants in that quiz. I want to convert this <code>SqlDataSource</code> to a <code>DataTable</code> and read a column from it. </p>
  
  <p><strong>So how to do that?</strong></p>