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;
}
}
