DBStorage.LookupMultipleData Method (PIA)
Use this method to retrieve multiple results from the database table. If the data is found, this method creates a SimpleList object that contains OrderForm or Dictionary objects, depending on the vtProgID parameter passed to the InitStorage method.
Definition
[Visual Basic .NET]
Imports Microsoft.CommerceServer.Interop.Orders
…
Public Function LookupMultipleData(vtReserved As Object,
ByRefpvtKeys As Object,
ByRefpvtValues As Object) As Object
[C#]
using Microsoft.CommerceServer.Interop.Orders;
…
public object LookupMultipleData(objectvtReserved,
ref objectpvtKeys,
ref objectpvtValues);
Parameters
[Visual Basic .NET]
- vtReserved
An Object reserved for future use. The LookupData method ignores any value stored in this parameter. - pvtKeys
An Object that identifies the columns in which to search for the data. This Object can be either a SimpleList object or a System.Array. - pvtValues
An Object that identifies the values for which to search. This parameter can be either a SimpleList object or a System.Array.
[C#]
- vtReserved
An object reserved for future use. The LookupData method ignores any value stored in this parameter. - pvtKeys
A reference to the object that identifies the columns in which to search for the data. This object can be either a SimpleList object or a System.Array. - pvtValues
A pointer to the object that identifies the values for which to search. This parameter can be either a SimpleList object or a System.Array.
Return Values
[Visual Basic .NET] If this method completes successfully, it returns an Object that references a SimpleList object that consists of one or more Dictionary objects, one for each row of data returned.
[C#] This method returns the result of the lookup. This object references a SimpleList object that consists of one or more Dictionary objects, one for each row of data returned. If the method fails, this parameter is set to null.
Exceptions
This method may throw one of many mapped exceptions or an exception of type COMException. See Standard COM Errors for additional details.
[Visual Basic .NET]
Example
' Order is a Commerce.OrderForm object; OrderFormStorage is
' an initialized Commerce.DBStorage object
Order.order_id = "Order_tmp"
Order.shopper_id = "Shopper_tmp"
OrderFormStorage.InsertData(DBNull.Value, Order)
Dim keyArray As String() = {“order_id”}
Dim valueArray As String() = {“Order_tmp”}
OrderFormStorage.LookupMultipleData(DBNull.Value, keysArray, _
valueArray)
Requirements
Namespace: Microsoft.CommerceServer.Interop.Orders
Platforms: Windows 2000, Windows Server 2003
Assembly: commercelib (in commercelib.dll)
See Also
Copyright © 2005 Microsoft Corporation.
All rights reserved.