GetProductBySql(String,Boolean) Method

Gets the products by SQL.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Shared Function GetProductBySql( _ 
   ByVal sql As String, _ 
   ByVal doRefactor As Boolean _ 
) As ProductCollection

public static ProductCollection GetProductBySql( 
   string sql,
   bool doRefactor 
)

Parameters

sql: The SQL query.
doRefactor: if set to true removes not used items.

Example

class MyPage : System.Web.UI.Page
{
   public void getActiveProducts(string sql)
   {
       ProductCollection dwProds = Product.GetProductBySql(sql, true);
       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

Reference

Product Class
Product Members
Overload List