protected void PageDataBind()
{
string sqlstring = "select * from news_class order by rootid,orderid";
SqlDataReader sdr=DbHelperSQL.ExecuteReader(sqlstring);
int i=0;
while(sdr.Read())
{
int class_id=Convert.ToInt32(sdr["class_id"].ToString());
int depth=Convert.ToInt32(sdr["depth"].ToString());
this.ddlclass.Items.Insert(i,new ListItem(sdr["classname"].ToString(),sdr["class_id"].ToString()));
for(int j=0;j<depth;j++)
{
this.ddlclass.Items[i].Text="|---"+this.ddlclass.Items[i].Text.ToString();
}
i++;
}
sdr.Close();
}