protected void btnTT_Click(object sender, EventArgs e)
{
PanelTT1.Visible = true;
string TT2 = "SELECT TeamMembers.V_ID, V_Name, V_LastName,V_MobileNo1, V_MobileNo2,V_Email ,TP_Name FROM TeamMembers,TeamPositions,Volunteer WHERE TeamMembers.TT_ID = " + ddlTT.SelectedValue + " AND TeamMembers.V_ID = Volunteer.V_ID and TeamMembers.TP_ID = TeamPositions.TP_ID ; ";
DataTable dtTT2 = dbconn.QueryExecuteScalar(TT2);
GridViewTT2.DataSource = dtTT2;
GridViewTT2.DataBind();
dbconn.Close();
lblTT.Text = GridViewTT2.Rows.Count.ToString();
}
protected void ddlTT_SelectedIndexChanged(object sender, EventArgs e)
{
string ActivityID = DetailsView1.DataKey.Value.ToString();
string TT2 = "SELECT TeamMembers.V_ID, V_Name, V_LastName,V_MobileNo1, V_MobileNo2,V_Email ,TP_Name FROM TeamMembers,TeamPositions,Volunteer WHERE TeamMembers.TT_ID = " + ddlTT.SelectedValue + " AND TeamMembers.V_ID = Volunteer.V_ID and TeamMembers.TP_ID = TeamPositions.TP_ID AND TeamMembers.V_ID NOT IN (SELECT VolunteerJoinActivities.V_ID FROM VolunteerJoinActivities WHERE Activity_ID = " + ActivityID + "); ";
DataTable dtTT2 = dbconn.QueryExecuteScalar(TT2);
GridViewTT2.DataSource = dtTT2;
GridViewTT2.DataBind();
dbconn.Close();
lblTT.Text = GridViewTT2.Rows.Count.ToString();
}
