//
绑定所有目录
public
static
void
Bind_list(DropDownList DropDownList1)
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
DropDownList1.Items.Clear();
string sql = "SELECT list_id,list_name,list_parent FROM list";
DataTable dt = DataBase.getDataTable(sql); //根据SQL语句获取DataTable值
Bind_list(DropDownList1,dt, "0", 0);
}
![None.gif](/Images/OutliningIndicators/None.gif)
private
static
void
Bind_list(DropDownList DropDownList1, DataTable dt,
string
parent,
int
grade)
![ExpandedBlockStart.gif](/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
DataRow[] dr = dt.Select("list_parent=" + parent, "list_id asc");
if (dr.Length > 0)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
int grade1 = grade + 1;
foreach (DataRow row in dr)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
ListItem li = new ListItem();
li.Text = "";
for (int i = 0; i < grade; i++)
![ExpandedSubBlockStart.gif](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
li.Text += " ";
}
li.Text += "├" + row[1].ToString();
li.Value = row[0].ToString();
DropDownList1.Items.Add(li);
Bind_list(DropDownList1,dt, row[0].ToString(), grade1);
}
}
}
转载于:https://www.cnblogs.com/hzuIT/archive/2007/06/12/780686.html