private void FillTrainingTopicDetails() { objHRdb = new HRInfo(); DataTable dt = new DataTable(); sDepartments = ""; string DeptName = ""; string Desig = ""; if (cbTopicName.SelectedIndex > 0) { try { dt = objHRdb.GetTrainingTopicDetails(Convert.ToInt32(cbTopicName.SelectedValue)).Tables[0]; if (dt.Rows.Count > 0) { flagUpdate = true; txtDuration.Text = dt.Rows[0]["TopicDuration"].ToString(); clbDesigs.Items.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { if (sDepartments != dt.Rows[i]["DeptId"].ToString()) { sDepartments = dt.Rows[i]["DeptId"].ToString(); FillDesignationsData(sDepartments); } if (DeptName != dt.Rows[i]["DeptName"].ToString()) { DeptName = dt.Rows[i]["DeptName"].ToString(); for (int j = 0; j < clbDepartments.Items.Count; j++) { if (((NewCheckboxListItem)(clbDepartments.Items[j])).Text.Equals(DeptName)) { clbDepartments.SetSelected(j, true); clbDepartments.SetItemChecked(j, true); } } } } for (int iVar = 0; iVar < dt.Rows.Count; iVar++) { Desig = dt.Rows[iVar]["DesigId"].ToString(); for (int k = 0; k < clbDesigs.Items.Count; k++) { if (((NewCheckboxListItem)(clbDesigs.Items[k])).Tag.Equals(Desig)) { clbDesigs.SetSelected(k, true); clbDesigs.SetItemChecked(k, true); } } } } else { flagUpdate = false; for (int i = 0; i < clbDepartments.Items.Count; i++) { clbDepartments.SetItemCheckState(i, CheckState.Unchecked); } if (clbDesigs.Items.Count > 0) { clbDesigs.Items.Clear(); } } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { objHRdb = null; dt = null; } } else { flagUpdate = false; for (int i = 0; i < clbDepartments.Items.Count; i++) { clbDepartments.SetItemCheckState(i, CheckState.Unchecked); } clbDesigs.Items.Clear(); } }