protected void GetChildPage(string strID, string strIDPath, int nDepth) { string sqlText = "Select * from power_page Where fatherID='" + strID + "'"; //SqlDataReader dr = dba.getDRExSQL(sqlText) ; SqlConnection sqlConn = new SqlConnection(); SqlCommand sqlCmd = new SqlCommand(); sqlConn.ConnectionString = DBCallCommon.GetStringValue("connectionStrings"); sqlCmd.Connection = sqlConn; sqlCmd.CommandText = sqlText; SqlDataReader dr = DBCallCommon.GetDataReader(sqlConn, sqlCmd); //dr.IsClosed if (dr.Read()) { do { DDLCategory.Items.Add(new ListItem(GetLeft("--", nDepth) + dr["Name"].ToString(), strIDPath + dr["page_id"].ToString() + ",")); GetChildPage(dr["page_id"].ToString(), strIDPath + "," + dr["page_id"].ToString() + ",", nDepth + 1); } while (dr.Read()); dr.Close(); } else { dr.Close(); return; } }