void FillGuardianGridView()
{
if (txtFamilyId.Text == "")
{
return;
}
int Family_ID = Convert.ToInt32(txtFamilyId.Text);
if (sqlCon.State == ConnectionState.Closed)
{
sqlCon.Open();
}
SqlDataAdapter sqlDa = new SqlDataAdapter("GuardianViewByFamilyID", sqlCon);
sqlDa.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDa.SelectCommand.Parameters.AddWithValue("@FamilyID", Family_ID);
DataTable dtbl = new DataTable();
sqlDa.Fill(dtbl);
sqlCon.Close();
gvGuardian.DataSource = dtbl;
gvGuardian.DataBind();
List <string> GuardianList = new List <string>();
foreach (DataRow x in dtbl.Rows)
{
GuardianList.Add(x["Guardian_ID"].ToString());
}
DropdownlistMainGuardian.DataSource = GuardianList;
DropdownlistMainGuardian.DataBind();
}
public void ClearFamily()
{
txtFamilyId.Text = txtFamilyName.Text = txtNotes.Text = txtPassCode.Text = txtLastLogin.Text = txtEmail.Text = txtUserName.Text = "";
lblFSuccessMessage.Text = lblFErrorMessage.Text = "";
DropdownlistMainGuardian.Items.Clear();
DropdownlistMainGuardian.DataSource = null;
DropdownlistMainGuardian.DataBind();
btnFSave.Text = "Save";
btnFDelete.Enabled = false;
ClearGuardian();
gvGuardian.DataSource = null;
gvGuardian.DataBind();
}
