GetAll Method (Category)
- Last UpdatedNov 06, 2025
- 2 minute read
'Declaration
Public Shared Function GetAll( _
ByVal categoryId As Nullable(Of Integer), _
ByVal categoryName As String, _
ByVal categoryDesc As String, _
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 categoryId As Nullable(Of Integer)
Dim categoryName As String
Dim categoryDesc As String
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 = Category.GetAll(categoryId, categoryName, categoryDesc, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> categoryId,
string categoryName,
string categoryDesc,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- categoryId
- Optional filter parameter. Holds the ID of the category.
- categoryName
- Optional filter parameter. Holds the name of the category.
- categoryDesc
- Optional filter parameter. Holds the description of a category.
- spare1
- Optional filter parameter. Holds a the value of the first user defined field.
- spare2
- Optional filter parameter. Holds a the value of the second user defined field.
- spare3
- Optional filter parameter. Holds a the value of the third user defined field.
- spare4
- Optional filter parameter. Holds a the value of the fourth user defined field.
- lastEditBy
- Optional filter parameter. Holds the ID of a user who added or last updated this type of record.
- lastEditAt
- Optional filter parameter. Holds a datetime when this type of record was added or last updated.
Return Value
Returns a DataSet that contains all the records in the Category table that satisfy the specified filters. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Name |
Description |
|---|---|
|
category_name |
A string that is the name of the category is returned. |
|
category_desc |
A string that is the description of the category is returned. |
|
spare1 |
A string that is the contents of the user-defined spare1 field. |
|
spare2 |
A string that is the contents of the user-defined spare2 field. |
|
spare3 |
A string that is the contents of the user-defined spare3 field. |
|
spare4 |
A string that is the contents of the user-defined spare4 field. |
|
last_edit_comment |
A string that contains comments about why the record was added or changed. |
|
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. |