ListItem type_all = new ListItem("ALL", "");
DropDownList_Section.Items.Add(type_all);
DropDownList_Line.Items.Add(type_all);
dsTemp = new DataSet();
sSql = "select distinct section_code, rtrim(section_code) + '-' + struct_name struct_name from HR_ORGANIZATION_CODES where struct_type = 'S' order by section_code";
dsTemp = myClsDB.ExecuteDataset(CommandType.Text, sSql);
DataView dv_temp_section = new DataView(dsTemp.Tables[0]);
for (int i = 0; i < dv_temp_section.Count; i++)
{
ListItem li = new ListItem(dv_temp_section[i]["struct_name"].ToString(), dv_temp_section[i]["section_code"].ToString());
DropDownList_Section.Items.Add(li);
}
dsTemp = new DataSet();
sSql = "select distinct line_code, rtrim(section_code)+'-'+rtrim(line_code) + '-' + struct_name struct_name from HR_ORGANIZATION_CODES where struct_type = 'L' order by line_code";
dsTemp = myClsDB.ExecuteDataset(CommandType.Text, sSql);
DataView dv_temp_line = new DataView(dsTemp.Tables[0]);
for (int i = 0; i < dv_temp_line.Count; i++)
{
ListItem li = new ListItem(dv_temp_line[i]["struct_name"].ToString(), dv_temp_line[i]["line_code"].ToString());
DropDownList_Line.Items.Add(li);
WebMISCL.ClassDB myClsDB = new WebMISCL.ClassDB();
dsTemp = new DataSet();
sSql = "select distinct line_code, rtrim(section_code)+'-'+rtrim(line_code) + '-' + struct_name struct_name from HR_ORGANIZATION_CODES where struct_type = 'L' and section_code like '%" + DropDownList_Section.SelectedValue.ToString() + "%' order by line_code";
dsTemp = myClsDB.ExecuteDataset(CommandType.Text, sSql);
myClsDB.CloseConnection();
myClsDB.Dispose();
DataView dv_temp_line = new DataView(dsTemp.Tables[0]);
for (int i = 0; i < dv_temp_line.Count; i++)
{
ListItem li = new ListItem(dv_temp_line[i]["struct_name"].ToString(), dv_temp_line[i]["line_code"].ToString());
DropDownList_Line.Items.Add(li);
}
myClsDB.CloseConnection();
myClsDB.Dispose();
if (RelationddList != null)
{
//RelationddList.SectionValue = this.DropDownList_Section.SelectedValue;
}
}