GetAll Method (Cust)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal custId As String, _
ByVal custName As String, _
ByVal city As String, _
ByVal state As String, _
ByVal zip As String, _
ByVal country As String, _
ByVal customer As Nullable(Of Boolean), _
ByVal vendor As Nullable(Of Boolean), _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim custId As String
Dim custName As String
Dim city As String
Dim state As String
Dim zip As String
Dim country As String
Dim customer As Nullable(Of Boolean)
Dim vendor As Nullable(Of Boolean)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = Cust.GetAll(custId, custName, city, state, zip, country, customer, vendor, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
string custId,
string custName,
string city,
string state,
string zip,
string country,
Nullable<bool> customer,
Nullable<bool> vendor,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- custId
- Optional filter parameter. Holds a customer or vendor ID.
- custName
- Optional filter parameter. Holds the name of a customer or vendor.
- city
- Optional filter parameter. Holds the city portion of a customer or vendor's address.
- state
- Optional filter parameter. Holds the state portion of an address.
- zip
- Optional filter parameter. Holds the ZIP code portion of an address.
- country
- Optional filter parameter. Holds the country portion of an address.
- customer
- Optional filter parameter. Holds the flag that specifies whether this is a customer.
- vendor
- Optional filter parameter. Holds the flag that specifies whether this is a vendor.
- spare1
- Optional filter parameter. Holds the contents of the user-defined spare1 field.
- spare2
- Optional filter parameter. Holds the contents of the user-defined spare2 field.
- spare3
- Optional filter parameter. Holds the contents of the user-defined spare3 field.
- spare4
- Optional filter parameter. Holds the contents of the user-defined spare4 field.
- lastEditBy
- Optional filter parameter. Holds the user who created or last updated the record.
- lastEditAt
- Optional filter parameter. Holds the date and time that the record was added or last updated.
Return Value
Returns a DataSet that contains a DataRow for each customer or vendor record that matches the specified filter criteria. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Names |
Description |
|---|---|
|
cust_id |
A string that is the customer or vendor ID. |
|
cust_name |
A string that is the name of the customer or vendor. |
|
address1 |
A string that is the first part of the customer or vendor address. |
|
address2 |
An string that is the second part of the customer or vendor address. |
|
city |
A string that is the city of the customer or vendor address. |
|
state |
A string that is the state of the customer or vendor address. |
|
zip |
A string that is the zip code of the customer or vendor address. |
|
country |
A string that is the country of the customer or vendor address. |
|
phone |
A string that is the phone number of the customer or vendor. |
|
fax |
A string that is the fax number of the customer or vendor. |
|
|
A string that is the email address of the customer or vendor. |
|
customer |
A Boolean flag that indicates whether this is a customer. |
|
vendor |
A Boolean flag that indicates whether this is a vendor. |
|
spare1 to spare4 |
A string that is the content of the spare1 to spare4 user-defined fields. |
|
last_edit_comment |
A string that contains comments about why the record was added or updated. |
|
last_edit_by |
A string that is the ID of the user who added or last updated this record. |
|
last_edit_at |
A datetime that indicates when the record was added or last updated. |
|
mod_id |
The current modification ID of the record in the table. This ID is binary number that increments each time the record’s table row is modified. Optionally used for optimistic concurrency control when performing updates or deletes. |