一个DropDownList绑定三级数据

如图做事效果，家用电器是一级，大家电是二级，平板电视是三级

  定义一个类（pfunction）：

再类中写一个方法SetProtect

 public static void SetProtect(DropDownList ddl, DataTable dt, string text, string value)
        {
            ddl.Items.Clear();
            ddl.Items.Add(new ListItem("商品类别", "-1"));//--请选择--
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ddl.Items.Add(new ListItem(dt.Rows[i][text].ToString(), dt.Rows[i][value].ToString()));
                DataRow[] dr2 = dt.Select(" levels=2 and FirstID='" + dt.Rows[i]["ID"] + "' ");
                for (int j = 0; j < dr2.Length; j++)
                {
                    ddl.Items.Add(new ListItem("　" + dr2[j][text].ToString(), dr2[j][value].ToString()));
                    DataRow[] dr3 = dt.Select(" levels=3 and FirstID='" + dr2[j]["ID"] + "' ");
                    for (int h = 0; h <dr3.Length; h++)
                    {
                        ddl.Items.Add(new ListItem("　　 " + dr3[h][text].ToString(), dr3[h][value].ToString()));
                    }
                }
            }
        }

 

调用代码：

pfunction.SetProtect(ddlCName, DbHelperSQL.Query("select * from Da_CategoryList").Tables[0], "CName", "Id");