this for the aspx.
<tr>
<td width="20%">UEM SCHOLARSHIP PROGRAMME</td>
<td align="middle" width="5%"><a href="http://www.google.com"><asp:Label ID="lblAUS1" runat="server"></asp:Label></a></td>
<td align="middle" width="5%"><a href="http://www.google.com"><asp:Label ID="lblUS1" runat="server"></asp:Label></a></td>
<td align="middle" width="5%"><a href="http://www.google.com"><asp:Label ID="lblUK1" runat="server"></asp:Label></a></td>
<td align="middle" width="5%"><a href="http://www.google.com"><asp:Label ID="lblMSIA1" runat="server"></asp:Label></td>
<td align="middle" width="5%"><a href="http://www.google.com"><asp:Label ID="lblGER1" runat="server"></asp:Label></td>
<td align="middle" width="8%"><a href="http://www.google.com"><asp:Label ID="lblTOTAL1" runat="server"></asp:Label></td>
</tr>
this for cs
con.Open();
String AUS = "select COUNT(StudentID) AS TotalScholar from Student where StudentScholarshipID = '1' and StudentCountryID = '9'";
SqlCommand cmdRD1 = new SqlCommand(AUS, con);
SqlDataReader drRD1 = cmdRD1.ExecuteReader();
con.Close();
con.Open();
string getValue1 = Convert.ToString(cmdRD1.ExecuteScalar());
lblAUS1.Text = getValue1;
con.Close();
con.Open();
String US = "select COUNT(StudentID) AS TotalScholar from Student where StudentScholarshipID = '1' and StudentCountryID = '13'";
SqlCommand cmdRD2 = new SqlCommand(US, con);
SqlDataReader drRD2 = cmdRD2.ExecuteReader();
con.Close();
con.Open();
string getValue2 = Convert.ToString(cmdRD2.ExecuteScalar());
lblUS1.Text = getValue2;
con.Close();
con.Open();
String UK = "select COUNT(StudentID) AS TotalScholar from Student where StudentScholarshipID = '1' and StudentCountryID = '14'";
SqlCommand cmdRD3 = new SqlCommand(UK, con);
SqlDataReader drRD3 = cmdRD3.ExecuteReader();
con.Close();
con.Open();
string getValue3 = Convert.ToString(cmdRD3.ExecuteScalar());
lblUK1.Text = getValue3;
con.Close();
con.Open();
String MSIA = "select COUNT(StudentID) AS TotalScholar from Student where StudentScholarshipID = '1' and StudentCountryID = '1'";
SqlCommand cmdRD4 = new SqlCommand(MSIA, con);
SqlDataReader drRD4 = cmdRD4.ExecuteReader();
con.Close();
con.Open();
string getValue4 = Convert.ToString(cmdRD4.ExecuteScalar());
lblMSIA1.Text = getValue4;
con.Close();
con.Open();
String GER = "select COUNT(StudentID) AS TotalScholar from Student where StudentScholarshipID = '1' and StudentCountryID = '15'";
SqlCommand cmdRD5 = new SqlCommand(GER, con);
SqlDataReader drRD5 = cmdRD5.ExecuteReader();
con.Close();
con.Open();
string getValue5 = Convert.ToString(cmdRD5.ExecuteScalar());
lblGER1.Text = getValue5;
con.Close();
I already get the value for each label, but how do i want to calculate sum of the value and put in lblTOTAL1 ?