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