protected void Page_Load(object sender, EventArgs e) { int link = -1; try { link = Convert.ToInt32(Request.QueryString["c"]); } catch { Response.Redirect("Pricewatch.aspx"); } cat = dbmngr.GetCategorie(link); TitleCat.Text = cat.Naam; ItemTable.DataSource = dbmngr.GetCatProducts(link); ItemTable.DataBind(); }
public Categorie GetCategorie(int id) { int idcat = -1; string naam = null; int childof = -1; Categorie cat = null; try { if (id < 0) { throw new NoNullAllowedException(); } string sql = @"SELECT * FROM Categorie WHERE ID= :CatID"; conn.Open(); OracleCommand cmd = new OracleCommand(sql, conn); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("CatID", OracleDbType.Int32, id, ParameterDirection.Input); OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { idcat = reader.GetInt32(0); naam = reader.GetOracleString(1).ToString(); string temp = reader.GetValue(3).ToString(); if (!int.TryParse(temp, out childof)) { childof = -1; } } cat = new Categorie(idcat, naam, null, childof); } catch { } finally { conn.Close(); } return(cat); }
public Categorie GetCategorie(int id) { int idcat = -1; string naam = null; int childof = -1; Categorie cat = null; try { if (id < 0) { throw new NoNullAllowedException(); } string sql = @"SELECT * FROM Categorie WHERE ID= :CatID"; conn.Open(); OracleCommand cmd = new OracleCommand(sql, conn); cmd.CommandType = CommandType.Text; cmd.Parameters.Add("CatID", OracleDbType.Int32, id, ParameterDirection.Input); OracleDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { idcat = reader.GetInt32(0); naam = reader.GetOracleString(1).ToString(); string temp = reader.GetValue(3).ToString(); if (!int.TryParse(temp, out childof)) { childof = -1; } } cat = new Categorie(idcat, naam, null, childof); } catch { } finally { conn.Close(); } return cat; }