GetProductBySql(String) Method

Gets the products by SQL.

Syntax

Visual Basic
C#

'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

Reference

Product Class
Product Members
Overload List