protected void drpGroup_SelectedIndexChanged(object sender, EventArgs e)
{
if (drpGroup.SelectedValue == "9999")
{
txtGroupName.Visible = true;
btnGroup.Visible = true;
txtSubGroupName.Visible = true;
btnSubGroup.Visible = true;
}
else
{
if (drpGroup.SelectedValue != "9999")
{
txtGroupName.Visible = false;
btnGroup.Visible = false;
txtSubGroupName.Visible = false;
btnSubGroup.Visible = false;
if (drpGroup.SelectedValue != "--Select--")
{
LoadSubGroup(1, drpGroup.SelectedValue);
}
else
{
DropSubGroup.ClearSelection();
}
}
}
}
protected void drpGroup_SelectedIndexChanged(object sender, EventArgs e)
{
if (drpGroup.SelectedValue != "--Select--")
{
LoadSubGroup(1, drpGroup.SelectedValue);
}
else
{
DropSubGroup.ClearSelection();
}
}
public void LoadSubGroup(int a, string code)
{
DataSet ds = new DataSet();
SqlConnection conn = dbconnection.connection();
//string quiry = "select code from program where Code <>'" + code + "' order by code";
string quiry = "Select SubGroupSL,SubGroupName from (Select top(100) SubGroupSL,SubGroupName from SubGroupInfo where GroupSL='" + code + "' order by (SubGroupName)) as SubGroupInfo union ALL Select 9999 as exp1,'Others' as exp2 ";
SqlDataAdapter dt = new SqlDataAdapter(quiry, conn);
dt.Fill(ds);
DropSubGroup.DataSource = ds;
DropSubGroup.DataTextField = "SubGroupName";
DropSubGroup.DataValueField = "SubGroupSL";
DropSubGroup.DataBind();
if (a == 1)
{
DropSubGroup.Items.Insert(0, "--Select--");
}
}
