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(); }