title: How to assign sql selected result to label from code behind?
body: <p>I want to show the result in Label, I wrote a query by which I am getting some records, I want to assign that records based on the Name.</p>
  
  <p>I have 5 label: A, B , C, D, E in these label I want to show the records.</p>
  
  <p>Query:</p>
  
  <pre><code>select s.Name, count(1)as Records from tbl_Case tc
  inner join tbl_subcase ts on ts.id = tc.Id
  inner join tbl_supercase tsc on tsc.id = tc.supercaseid
  inner join course c on c.id = b.courseid
  where s.isvalid = 1 group by s.Name
  </code></pre>
  
  <p>From the query suppose I am getting A = 4, B = 10, c = 2, E= 100 and I did not get the record for D. so I want to show in label as 4 Records, 10 Records, 2 Records, No Records Found, 100 Records.</p>
  
  <p>Please some one tell me how could I assign records in label from Code Behind.</p>