protected void ddlArea3_SelectedIndexChanged(object sender, EventArgs e)
{
string ActivityID = DetailsView1.DataKey.Value.ToString();
string Area3 = "SELECT VolunteerJoinedAreas.V_ID, V_Name, V_LastName, V_MobileNo1,V_MobileNo2, V_Email from VolunteerJoinedAreas, Volunteer WHERE VolunteerJoinedAreas.V_ID = Volunteer.V_ID AND JA_ID = " + ddlArea3.SelectedValue + " AND VolunteerJoinedAreas.V_ID NOT IN (SELECT VolunteerJoinActivities.V_ID FROM VolunteerJoinActivities WHERE Activity_ID = " + ActivityID + ");";
DataTable dtArea3 = dbconn.QueryExecuteScalar(Area3);
GridViewArea3.DataSource = dtArea3;
GridViewArea3.DataBind();
dbconn.Close();
lblArea3.Text = GridViewArea3.Rows.Count.ToString();
}
protected void SaveArea3_Click(object sender, EventArgs e)
{
CheckBox chkbox = new CheckBox();
foreach (GridViewRow grdRow in GridViewArea3.Rows)
{
chkbox = (CheckBox)Convert.ChangeType(((CheckBox)grdRow.FindControl("chk")), typeof(CheckBox));
if (chkbox.Checked)
{
string keyID = (string)GridViewArea3.DataKeys[grdRow.RowIndex].Value.ToString();
string sqlSelectVolunteer = "Insert into VolunteerJoinActivities(V_ID,VJA_Status,Activity_ID) Values (" + keyID + ",'Selected'," + DetailsView1.SelectedValue + ") ;";
dbconn.QueryExecuteScalar(sqlSelectVolunteer);
}
}
GridViewArea3.DataBind();
dbconn.Close();
}
