void initOfficial()
{
p_dsOfficial = csql.getBrgyOfficial("SmartConcepcion", p_BrgyID);
lblCaptain.Text = p_dsOfficial.Tables["dtCapt"].Rows[0]["officialName"].ToString();
imgcaptain.Src = $"../community/ProfilePicture/{p_dsOfficial.Tables["dtCapt"].Rows[0]["userID"].ToString()}{p_dsOfficial.Tables["dtCapt"].Rows[0]["profile_ext"].ToString()}{'"'}";
loadListview(lvCouncilor, p_dsOfficial.Tables["dtCouncilor"]);
}
void loadOfficial()
{
p_dsOfficial = csql.getBrgyOfficial("SmartConcepcion", p_BrgyID);
if (b_hasrow(p_dsOfficial.Tables["dtCapt"]))
{
txtChairman.Text = p_dsOfficial.Tables["dtCapt"].Rows[0]["officialName"].ToString();
}
if (b_hasrow(p_dsOfficial.Tables["dtEmployee"]))
{
loadListview(lvCouncilor, p_dsOfficial.Tables["dtCouncilor"]);
}
if (b_hasrow(p_dsOfficial.Tables["dtEmployee"]))
{
loadGridView(gvSecretary, p_dsOfficial.Tables["dtEmployee"]);
}
upBoard.Update();
}
