public List <HelpLevel3> LoadHelpLevel3ByParentId(int parentId) { string query = "SELECT * FROM HelpOnlineLevel3 WHERE parentID =" + parentId + " order by IndexTopic"; List <HelpLevel3> list = new List <HelpLevel3>(); using (SqlConnection con = SQLConnect()) { using (SqlDataAdapter sda = new SqlDataAdapter(query, con)) { using (DataTable dt = new DataTable()) { con.Open(); sda.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { DataRow row = dt.Rows[i]; HelpLevel3 level3 = new HelpLevel3(); level3.Id = Convert.ToInt32(row["Id"]); level3.Title = row["Title"].ToString(); level3.URL = row["URL"].ToString(); level3.ParentId = Convert.ToInt32(row["parentId"]); HelpLevel2DB helpLevel2DB = new HelpLevel2DB(); level3.ParentTopic = helpLevel2DB.GetHelpLevel2ById(level3.ParentId); level3.Index = 1; list.Add(level3); } } } } return(list); }