title: how to store items from database inside an array?
body: <pre><code>public partial class Piechart : System.Web.UI.Page
  {
      private decimal total = 0; // course total
      private decimal registered = 0;
      private decimal regAttend = 0;
      private decimal nRegAttend = 0;
      private int regPer = 0;
      private int regToTotalPer = 0;
      private int nRegPer = 0;
      private int angle = 0;
      private int angle2 = 0;
      private int angle3 = 0;
      private int parTotal = 0;
      //const string G = "SELECT DISTINCT COUNT(Grouping) from Attendance";
     // SqlConnection c = new SqlConnection(@"Data Source=localhost\SQLEXPRESS;Initial Catalog=PSeminar;Integrated Security=true;Trusted_Connection=Yes;MultipleActiveResultSets=true");
      //SqlCommand Command = new SqlCommand(G);
  
  
      private string[] Status = new string[2] { "Attend", "Didn't Attend" };
      private string[] Course = new string[] {//items from database};
  </code></pre>
  
  <p>I want to use a sql statement to call a list of items and store inside the above array. I am doing this as previously the items in the array were hardcoded. Now I want to retrieve it from the database, as whenever there is a new item, a new pie chart will be drawn automatically. </p>