Dynamicweb 8 Documentation
GetProductBySql(String) Method
Example 

Gets the products by SQL.
Syntax
'Declaration
 
Public Overloads Shared Function GetProductBySql( _ 
   ByVal sql As String _ 
) As ProductCollection
public static ProductCollection GetProductBySql( 
   string sql 
)

Parameters

sql
Example
class MyPage : System.Web.UI.Page
{
   public void getActiveProducts(string sql)
   {
       ProductCollection dwProds = Product.GetProductBySql(sql);
       foreach (Product dwProd in dwProds)
       {
           //TODO: insert your code here
       }
   }
}
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

Product Class
Product Members
Overload List

Send Feedback