private void FillGroupMappedSourceData(string strBCode, string strSCode) { objServicedb = new ServiceDB(); DataTable dt = new DataTable(); string strLogBcode = string.Empty; string strLoadedEcode = string.Empty; string[] strDestCode = ((NewCheckboxListItem)(clbDestination.SelectedItem)).Tag.Split('~'); clbSource.Items.Clear(); try { dt = objServicedb.LevelGroupServiceEcodeMapped_Get(CommonData.CompanyCode, strBCode, strSCode, Convert.ToInt32(strDestCode[0]), Convert.ToInt32(cbLevels.SelectedValue.ToString()), strLogBcode).Tables[0]; if (dt.Rows.Count > 0) { foreach (DataRow dataRow in dt.Rows) { if (dataRow["mapped"].ToString() == "999999") { cbGroupCamp.Text = dataRow["GroupName"].ToString(); cbLogcalBranch.Text = dataRow["logBranchName"].ToString(); NewCheckboxListItem oclBox = new NewCheckboxListItem(); oclBox.Tag = dataRow["ECODE"].ToString(); oclBox.Text = dataRow["ENAME"].ToString(); clbSource.Items.Add(oclBox); oclBox = null; } else { if (strDestCode[0].IndexOf(dataRow["ECODE"].ToString().Substring(0, dataRow["ECODE"].ToString().IndexOf("~"))) < 0) { cbGroupCamp.Text = dataRow["GroupName"].ToString(); cbLogcalBranch.Text = dataRow["logBranchName"].ToString(); NewCheckboxListItem oclBox = new NewCheckboxListItem(); oclBox.Tag = dataRow["ECODE"].ToString(); oclBox.Text = dataRow["ENAME"].ToString(); if (!strLoadedEcode.Contains(dataRow["ECODE"].ToString())) { clbSource.Items.Add(oclBox, CheckState.Checked); } strLoadedEcode += dataRow["ECODE"].ToString() + ","; //clbSource.Items.Add(oclBox, CheckState.Checked); oclBox = null; } } } } dt = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { objServicedb = null; } }