protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {

                SqlCommand Cmd = new SqlCommand("Select id,categoryname From tblcategory where parentid=0", con);
                SqlDataAdapter DA = new SqlDataAdapter(Cmd);

                DA.Fill(ds, "tblcategory");

                ddl1.DataSource = ds.Tables["tblcategory"];
                ddl1.DataTextField = "categoryname";
                ddl1.DataValueField = "id";
                ddl1.DataBind();
                ddl1.Items.Insert(0, "--Select one--");
                ddl2.Items.Insert(0, "--Select one--");
                ddl3.Items.Insert(0, "--Select one--");
                ddl4.Items.Insert(0, "--Select one--");
                ddl5.Items.Insert(0, "--Select one--");
            }

        }

        protected void ddl1_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (ddl1.SelectedValue != "Select")
            {
               

                SqlCommand Cmd1 = new SqlCommand("Select id,categoryname From tblcategory Where catpath='" + ddl1.SelectedValue + "'", con);
                SqlDataAdapter DA1 = new SqlDataAdapter(Cmd1);
                DA1.Fill(ds);
                ddl2.DataSource = ds.Tables["tblcategory"];
                ddl2.DataTextField = "id";
                ddl2.DataValueField = "categoryname";
                ddl2.DataBind();
                ddl2.Items.Insert(0, "Select");
            }

        }

        protected void ddl2_SelectedIndexChanged(object sender, EventArgs e)
        {
            if (ddl2.SelectedValue != "Select")
            {
                SqlCommand Cmd2 = new SqlCommand("Select categoryname From tblcategory Where catpath='" + ddl1.SelectedValue + "'", con);
                SqlDataAdapter DA1 = new SqlDataAdapter(Cmd2);
                DA1.Fill(ds, "tblcategory");
                ddl2.DataSource = ds.Tables["tblcategory"];
                ddl2.DataTextField = "categoryname";
                ddl2.DataValueField = "id";
                ddl2.DataBind();
                ddl2.Items.Insert(0, "Select");
            }