Error compiling template "Designs/australis/_parsed/Copy of fullwidth.parsed.cshtml"
Line 37: The type or namespace name 'Database' does not exist in the namespace 'Dynamicweb' (are you missing an assembly reference?)


  1	@{
  2	var brand = "All Brands";
  3	if((System.Web.HttpContext.Current.Request["brand"]=="All Brands")||(string.IsNullOrWhiteSpace(System.Web.HttpContext.Current.Request["brand"]))){
  4		brand = "All Brands";
  5		}
  6	
  7		else {
  8	    
  9			 brand = System.Web.HttpContext.Current.Request["brand"];  
 10	        
 11	        string SQL="";
 12			SQL = "SELECT ProductName,ProductID FROM EcomProducts WHERE ProductManufacturerID='" + brand.ToString().ToUpper() + "'";                           
 13	        System.Data.IDataReader myReader = Dynamicweb.Database.CreateDataReader(SQL) ;
 14	        while (myReader.Read())
 15	        {
 16	          string productName= myReader["ProductName"].ToString();	
 17	          string productID=myReader["ProductID"].ToString();
 18	<option value="@productID">@productName</option>
 19	          
 20	        }
 21	}
 22	}