protected void Page_Load(object sender, EventArgs e) { if (Request.UserAgent.IndexOf("AppleWebKit") > 0) { Request.Browser.Adapters.Clear(); } if (!IsPostBack) { DBTool dbTool = new DBTool(); Category category = new Category(); DataSet dsCategory = category.GetList(); DataTable dtCategory = dsCategory.Tables[0]; Menu1.Items.Add(new MenuItem("Library")); foreach (DataRow dr in dtCategory.Rows) { string CatName = Convert.ToString(dr["name"]); string CatId= Convert.ToString(dr["categoryid"]); string SubCatId = dbTool.GetOneString("SELECT TOP 1 subcategoryid FROM mst_subcategory WHERE Categoryid =" + CatId); MenuItem node = new MenuItem(CatName, "", "", "ViewCat.aspx?Catid=" + CatId + "&SubCatId="+SubCatId, ""); Menu1.Items[0].ChildItems.Add(node); } } txtSearch.Attributes.Add("onkeypress", "return AnyInput_KeyDown(event,'" + btnSearch.ClientID + "')"); }
public string GetSubcategoryByID(string bookid) { string SQL = "SELECT subcategoryid from tb_book where bookid='" + bookid + "'"; DBTool dbTool = new DBTool(); try { return dbTool.GetOneString(SQL); } catch (Exception) { return ""; } }
public string GetName(string subcategoryid) { string SQL = "SELECT name FROM mst_subcategory WHERE subcategoryid =" + subcategoryid; DBTool dbTool = new DBTool(); try { return dbTool.GetOneString(SQL); } catch (Exception) { return ""; } }