Institutions¶
API reference for Institutions.
Purpose¶
- Legacy machine-generated typed
DataSet(from anInstitutions.xsdschema, produced by the Visual Studio DataSet designer) representing institution and financial-institution rows through a single typedInstitutionDataTableand its nestedInstitutionRowtype. - Structurally separate from the BOF business-object pattern used elsewhere in this library; no consumer of this type was found within
SAIF.Business.View.Provider.
Context¶
- Namespace:
SAIF.Business.View.Provider - Assembly/package:
SAIF.BOF.Business.View.Provider
Public members¶
Institutions DataSet members¶
| Member | Signature | Purpose |
|---|---|---|
| New | Public Sub New() |
Constructs the typed Institutions dataset and initializes its single InstitutionDataTable. |
| Institution | Public ReadOnly Property Institution() As InstitutionDataTable |
Returns the typed Institution table instance stored in the dataset. |
| SchemaSerializationMode | Public Overrides Property SchemaSerializationMode() As Global.System.Data.SchemaSerializationMode |
Gets or sets whether the dataset serializes schema information with its XML payload. |
| Tables | Public Shadows ReadOnly Property Tables() As Global.System.Data.DataTableCollection |
Returns the underlying DataTableCollection for the dataset. |
| Relations | Public Shadows ReadOnly Property Relations() As Global.System.Data.DataRelationCollection |
Returns the dataset's relation collection. |
| Clone | Public Overrides Function Clone() As Global.System.Data.DataSet |
Creates a typed clone of the dataset. |
| GetTypedDataSetSchema | Public Shared Function GetTypedDataSetSchema(ByVal xs As Global.System.Xml.Schema.XmlSchemaSet) As Global.System.Xml.Schema.XmlSchemaComplexType |
Returns the XML schema metadata for the typed dataset. |
InstitutionDataTable members¶
| Member | Signature | Purpose |
|---|---|---|
| InstitutionDataTable | Partial Public Class InstitutionDataTable Inherits Global.System.Data.TypedTableBase(Of InstitutionRow) |
Typed table class that stores InstitutionRow instances. |
| New | Public Sub New() |
Constructs an empty typed InstitutionDataTable. |
| LYONS_IDColumn | Public ReadOnly Property LYONS_IDColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for LYONS_ID. |
| LOCColumn | Public ReadOnly Property LOCColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for LOC. |
| NAMEColumn | Public ReadOnly Property NAMEColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for NAME. |
| MICRColumn | Public ReadOnly Property MICRColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for MICR. |
| FRACColumn | Public ReadOnly Property FRACColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for FRAC. |
| ACHColumn | Public ReadOnly Property ACHColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for ACH. |
| PHYS_ADDR1Column | Public ReadOnly Property PHYS_ADDR1Column() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for PHYS_ADDR1. |
| PHYS_CITYColumn | Public ReadOnly Property PHYS_CITYColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for PHYS_CITY. |
| PHYS_STATEColumn | Public ReadOnly Property PHYS_STATEColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for PHYS_STATE. |
| PHYS_ZIPColumn | Public ReadOnly Property PHYS_ZIPColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for PHYS_ZIP. |
| PHONEColumn | Public ReadOnly Property PHONEColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for PHONE. |
| FAXColumn | Public ReadOnly Property FAXColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for FAX. |
| FEDWIREColumn | Public ReadOnly Property FEDWIREColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for FEDWIRE. |
| CORR_RTNOColumn | Public ReadOnly Property CORR_RTNOColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for CORR_RTNO. |
| _RETURNColumn | Public ReadOnly Property _RETURNColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for _RETURN. |
| RETURN_EXTColumn | Public ReadOnly Property RETURN_EXTColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for RETURN_EXT. |
| ADJUSTColumn | Public ReadOnly Property ADJUSTColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for ADJUST. |
| ADJUST_EXTColumn | Public ReadOnly Property ADJUST_EXTColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for ADJUST_EXT. |
| WIREPHONEColumn | Public ReadOnly Property WIREPHONEColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for WIREPHONE. |
| WIREPHONE_EXTColumn | Public ReadOnly Property WIREPHONE_EXTColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for WIREPHONE_EXT. |
| SWIFTColumn | Public ReadOnly Property SWIFTColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for SWIFT. |
| TELEXColumn | Public ReadOnly Property TELEXColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for TELEX. |
| OLDMICRColumn | Public ReadOnly Property OLDMICRColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for OLDMICR. |
| HOMEPAGEColumn | Public ReadOnly Property HOMEPAGEColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for HOMEPAGE. |
| EMAILColumn | Public ReadOnly Property EMAILColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for EMAIL. |
| NOTESColumn | Public ReadOnly Property NOTESColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for NOTES. |
| LYONS_NOTEColumn | Public ReadOnly Property LYONS_NOTEColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for LYONS_NOTE. |
| CUST_SVCColumn | Public ReadOnly Property CUST_SVCColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for CUST_SVC. |
| UniWireColumn | Public ReadOnly Property UniWireColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for UniWire. |
| LABAOld2Column | Public ReadOnly Property LABAOld2Column() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for LABAOld2. |
| LABAOld3Column | Public ReadOnly Property LABAOld3Column() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for LABAOld3. |
| LACHOldColumn | Public ReadOnly Property LACHOldColumn() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for LACHOld. |
| LACHOld2Column | Public ReadOnly Property LACHOld2Column() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for LACHOld2. |
| LACHOld3Column | Public ReadOnly Property LACHOld3Column() As Global.System.Data.DataColumn |
Returns the typed DataColumn descriptor for LACHOld3. |
| Count | Public ReadOnly Property Count() As Integer |
Returns the number of typed rows currently in the table. |
| Item(index) | Public Default ReadOnly Property Item(ByVal index As Integer) As InstitutionRow |
Returns the typed row at the supplied zero-based index. |
| InstitutionRowChanging | Public Event InstitutionRowChanging As InstitutionRowChangeEventHandler |
Raised before a row change is committed. |
| InstitutionRowChanged | Public Event InstitutionRowChanged As InstitutionRowChangeEventHandler |
Raised after a row change is committed. |
| InstitutionRowDeleting | Public Event InstitutionRowDeleting As InstitutionRowChangeEventHandler |
Raised before a row delete is committed. |
| InstitutionRowDeleted | Public Event InstitutionRowDeleted As InstitutionRowChangeEventHandler |
Raised after a row delete is committed. |
| AddInstitutionRow(row) | Public Overloads Sub AddInstitutionRow(ByVal row As InstitutionRow) |
Adds an existing typed row to the table. |
| AddInstitutionRow(values...) | Public Overloads Function AddInstitutionRow(ByVal LYONS_ID As String, ByVal LOC As String, ByVal NAME As String, ByVal MICR As String, ByVal FRAC As String, ByVal ACH As String, ByVal PHYS_ADDR1 As String, ByVal PHYS_CITY As String, ByVal PHYS_STATE As String, ByVal PHYS_ZIP As String, ByVal PHONE As String, ByVal FAX As String, ByVal FEDWIRE As String, ByVal CORR_RTNO As String, ByVal _RETURN As String, ByVal RETURN_EXT As String, ByVal ADJUST As String, ByVal ADJUST_EXT As String, ByVal WIREPHONE As String, ByVal WIREPHONE_EXT As String, ByVal SWIFT As String, ByVal TELEX As String, ByVal OLDMICR As String, ByVal HOMEPAGE As String, ByVal EMAIL As String, ByVal NOTES As String, ByVal LYONS_NOTE As String, ByVal CUST_SVC As String, ByVal UniWire As String, ByVal LABAOld2 As String, ByVal LABAOld3 As String, ByVal LACHOld As String, ByVal LACHOld2 As String, ByVal LACHOld3 As String) As InstitutionRow |
Creates, populates, adds, and returns a new typed row using the full column set. |
| Clone | Public Overrides Function Clone() As Global.System.Data.DataTable |
Creates a typed clone of the table. |
| NewInstitutionRow | Public Function NewInstitutionRow() As InstitutionRow |
Creates a new detached typed row instance for this table. |
| RemoveInstitutionRow | Public Sub RemoveInstitutionRow(ByVal row As InstitutionRow) |
Removes the supplied typed row from the table. |
| GetTypedTableSchema | Public Shared Function GetTypedTableSchema(ByVal xs As Global.System.Xml.Schema.XmlSchemaSet) As Global.System.Xml.Schema.XmlSchemaComplexType |
Returns the XML schema metadata for the typed table. |
InstitutionRow members¶
| Member | Signature | Purpose |
|---|---|---|
| InstitutionRow | Partial Public Class InstitutionRow Inherits Global.System.Data.DataRow |
Typed row class for one Institution record. |
| LYONS_ID | Public Property LYONS_ID() As String |
Gets or sets the LYONS_ID column value for the current row. |
| LOC | Public Property LOC() As String |
Gets or sets the LOC column value for the current row. |
| NAME | Public Property NAME() As String |
Gets or sets the NAME column value for the current row. |
| MICR | Public Property MICR() As String |
Gets or sets the MICR column value for the current row. |
| FRAC | Public Property FRAC() As String |
Gets or sets the FRAC column value for the current row. |
| ACH | Public Property ACH() As String |
Gets or sets the ACH column value for the current row. |
| PHYS_ADDR1 | Public Property PHYS_ADDR1() As String |
Gets or sets the PHYS_ADDR1 column value for the current row. |
| PHYS_CITY | Public Property PHYS_CITY() As String |
Gets or sets the PHYS_CITY column value for the current row. |
| PHYS_STATE | Public Property PHYS_STATE() As String |
Gets or sets the PHYS_STATE column value for the current row. |
| PHYS_ZIP | Public Property PHYS_ZIP() As String |
Gets or sets the PHYS_ZIP column value for the current row. |
| PHONE | Public Property PHONE() As String |
Gets or sets the PHONE column value for the current row. |
| FAX | Public Property FAX() As String |
Gets or sets the FAX column value for the current row. |
| FEDWIRE | Public Property FEDWIRE() As String |
Gets or sets the FEDWIRE column value for the current row. |
| CORR_RTNO | Public Property CORR_RTNO() As String |
Gets or sets the CORR_RTNO column value for the current row. |
| _RETURN | Public Property _RETURN() As String |
Gets or sets the _RETURN column value for the current row. |
| RETURN_EXT | Public Property RETURN_EXT() As String |
Gets or sets the RETURN_EXT column value for the current row. |
| ADJUST | Public Property ADJUST() As String |
Gets or sets the ADJUST column value for the current row. |
| ADJUST_EXT | Public Property ADJUST_EXT() As String |
Gets or sets the ADJUST_EXT column value for the current row. |
| WIREPHONE | Public Property WIREPHONE() As String |
Gets or sets the WIREPHONE column value for the current row. |
| WIREPHONE_EXT | Public Property WIREPHONE_EXT() As String |
Gets or sets the WIREPHONE_EXT column value for the current row. |
| SWIFT | Public Property SWIFT() As String |
Gets or sets the SWIFT column value for the current row. |
| TELEX | Public Property TELEX() As String |
Gets or sets the TELEX column value for the current row. |
| OLDMICR | Public Property OLDMICR() As String |
Gets or sets the OLDMICR column value for the current row. |
| HOMEPAGE | Public Property HOMEPAGE() As String |
Gets or sets the HOMEPAGE column value for the current row. |
Public Property EMAIL() As String |
Gets or sets the EMAIL column value for the current row. |
|
| NOTES | Public Property NOTES() As String |
Gets or sets the NOTES column value for the current row. |
| LYONS_NOTE | Public Property LYONS_NOTE() As String |
Gets or sets the LYONS_NOTE column value for the current row. |
| CUST_SVC | Public Property CUST_SVC() As String |
Gets or sets the CUST_SVC column value for the current row. |
| UniWire | Public Property UniWire() As String |
Gets or sets the UniWire column value for the current row. |
| LABAOld2 | Public Property LABAOld2() As String |
Gets or sets the LABAOld2 column value for the current row. |
| LABAOld3 | Public Property LABAOld3() As String |
Gets or sets the LABAOld3 column value for the current row. |
| LACHOld | Public Property LACHOld() As String |
Gets or sets the LACHOld column value for the current row. |
| LACHOld2 | Public Property LACHOld2() As String |
Gets or sets the LACHOld2 column value for the current row. |
| LACHOld3 | Public Property LACHOld3() As String |
Gets or sets the LACHOld3 column value for the current row. |
| IsLYONS_IDNull | Public Function IsLYONS_IDNull() As Boolean |
Returns whether LYONS_ID currently contains DBNull. |
| SetLYONS_IDNull | Public Sub SetLYONS_IDNull() |
Sets LYONS_ID to DBNull. |
| IsLOCNull | Public Function IsLOCNull() As Boolean |
Returns whether LOC currently contains DBNull. |
| SetLOCNull | Public Sub SetLOCNull() |
Sets LOC to DBNull. |
| IsNAMENull | Public Function IsNAMENull() As Boolean |
Returns whether NAME currently contains DBNull. |
| SetNAMENull | Public Sub SetNAMENull() |
Sets NAME to DBNull. |
| IsMICRNull | Public Function IsMICRNull() As Boolean |
Returns whether MICR currently contains DBNull. |
| SetMICRNull | Public Sub SetMICRNull() |
Sets MICR to DBNull. |
| IsFRACNull | Public Function IsFRACNull() As Boolean |
Returns whether FRAC currently contains DBNull. |
| SetFRACNull | Public Sub SetFRACNull() |
Sets FRAC to DBNull. |
| IsACHNull | Public Function IsACHNull() As Boolean |
Returns whether ACH currently contains DBNull. |
| SetACHNull | Public Sub SetACHNull() |
Sets ACH to DBNull. |
| IsPHYS_ADDR1Null | Public Function IsPHYS_ADDR1Null() As Boolean |
Returns whether PHYS_ADDR1 currently contains DBNull. |
| SetPHYS_ADDR1Null | Public Sub SetPHYS_ADDR1Null() |
Sets PHYS_ADDR1 to DBNull. |
| IsPHYS_CITYNull | Public Function IsPHYS_CITYNull() As Boolean |
Returns whether PHYS_CITY currently contains DBNull. |
| SetPHYS_CITYNull | Public Sub SetPHYS_CITYNull() |
Sets PHYS_CITY to DBNull. |
| IsPHYS_STATENull | Public Function IsPHYS_STATENull() As Boolean |
Returns whether PHYS_STATE currently contains DBNull. |
| SetPHYS_STATENull | Public Sub SetPHYS_STATENull() |
Sets PHYS_STATE to DBNull. |
| IsPHYS_ZIPNull | Public Function IsPHYS_ZIPNull() As Boolean |
Returns whether PHYS_ZIP currently contains DBNull. |
| SetPHYS_ZIPNull | Public Sub SetPHYS_ZIPNull() |
Sets PHYS_ZIP to DBNull. |
| IsPHONENull | Public Function IsPHONENull() As Boolean |
Returns whether PHONE currently contains DBNull. |
| SetPHONENull | Public Sub SetPHONENull() |
Sets PHONE to DBNull. |
| IsFAXNull | Public Function IsFAXNull() As Boolean |
Returns whether FAX currently contains DBNull. |
| SetFAXNull | Public Sub SetFAXNull() |
Sets FAX to DBNull. |
| IsFEDWIRENull | Public Function IsFEDWIRENull() As Boolean |
Returns whether FEDWIRE currently contains DBNull. |
| SetFEDWIRENull | Public Sub SetFEDWIRENull() |
Sets FEDWIRE to DBNull. |
| IsCORR_RTNONull | Public Function IsCORR_RTNONull() As Boolean |
Returns whether CORR_RTNO currently contains DBNull. |
| SetCORR_RTNONull | Public Sub SetCORR_RTNONull() |
Sets CORR_RTNO to DBNull. |
| Is_RETURNNull | Public Function Is_RETURNNull() As Boolean |
Returns whether _RETURN currently contains DBNull. |
| Set_RETURNNull | Public Sub Set_RETURNNull() |
Sets _RETURN to DBNull. |
| IsRETURN_EXTNull | Public Function IsRETURN_EXTNull() As Boolean |
Returns whether RETURN_EXT currently contains DBNull. |
| SetRETURN_EXTNull | Public Sub SetRETURN_EXTNull() |
Sets RETURN_EXT to DBNull. |
| IsADJUSTNull | Public Function IsADJUSTNull() As Boolean |
Returns whether ADJUST currently contains DBNull. |
| SetADJUSTNull | Public Sub SetADJUSTNull() |
Sets ADJUST to DBNull. |
| IsADJUST_EXTNull | Public Function IsADJUST_EXTNull() As Boolean |
Returns whether ADJUST_EXT currently contains DBNull. |
| SetADJUST_EXTNull | Public Sub SetADJUST_EXTNull() |
Sets ADJUST_EXT to DBNull. |
| IsWIREPHONENull | Public Function IsWIREPHONENull() As Boolean |
Returns whether WIREPHONE currently contains DBNull. |
| SetWIREPHONENull | Public Sub SetWIREPHONENull() |
Sets WIREPHONE to DBNull. |
| IsWIREPHONE_EXTNull | Public Function IsWIREPHONE_EXTNull() As Boolean |
Returns whether WIREPHONE_EXT currently contains DBNull. |
| SetWIREPHONE_EXTNull | Public Sub SetWIREPHONE_EXTNull() |
Sets WIREPHONE_EXT to DBNull. |
| IsSWIFTNull | Public Function IsSWIFTNull() As Boolean |
Returns whether SWIFT currently contains DBNull. |
| SetSWIFTNull | Public Sub SetSWIFTNull() |
Sets SWIFT to DBNull. |
| IsTELEXNull | Public Function IsTELEXNull() As Boolean |
Returns whether TELEX currently contains DBNull. |
| SetTELEXNull | Public Sub SetTELEXNull() |
Sets TELEX to DBNull. |
| IsOLDMICRNull | Public Function IsOLDMICRNull() As Boolean |
Returns whether OLDMICR currently contains DBNull. |
| SetOLDMICRNull | Public Sub SetOLDMICRNull() |
Sets OLDMICR to DBNull. |
| IsHOMEPAGENull | Public Function IsHOMEPAGENull() As Boolean |
Returns whether HOMEPAGE currently contains DBNull. |
| SetHOMEPAGENull | Public Sub SetHOMEPAGENull() |
Sets HOMEPAGE to DBNull. |
| IsEMAILNull | Public Function IsEMAILNull() As Boolean |
Returns whether EMAIL currently contains DBNull. |
| SetEMAILNull | Public Sub SetEMAILNull() |
Sets EMAIL to DBNull. |
| IsNOTESNull | Public Function IsNOTESNull() As Boolean |
Returns whether NOTES currently contains DBNull. |
| SetNOTESNull | Public Sub SetNOTESNull() |
Sets NOTES to DBNull. |
| IsLYONS_NOTENull | Public Function IsLYONS_NOTENull() As Boolean |
Returns whether LYONS_NOTE currently contains DBNull. |
| SetLYONS_NOTENull | Public Sub SetLYONS_NOTENull() |
Sets LYONS_NOTE to DBNull. |
| IsCUST_SVCNull | Public Function IsCUST_SVCNull() As Boolean |
Returns whether CUST_SVC currently contains DBNull. |
| SetCUST_SVCNull | Public Sub SetCUST_SVCNull() |
Sets CUST_SVC to DBNull. |
| IsUniWireNull | Public Function IsUniWireNull() As Boolean |
Returns whether UniWire currently contains DBNull. |
| SetUniWireNull | Public Sub SetUniWireNull() |
Sets UniWire to DBNull. |
| IsLABAOld2Null | Public Function IsLABAOld2Null() As Boolean |
Returns whether LABAOld2 currently contains DBNull. |
| SetLABAOld2Null | Public Sub SetLABAOld2Null() |
Sets LABAOld2 to DBNull. |
| IsLABAOld3Null | Public Function IsLABAOld3Null() As Boolean |
Returns whether LABAOld3 currently contains DBNull. |
| SetLABAOld3Null | Public Sub SetLABAOld3Null() |
Sets LABAOld3 to DBNull. |
| IsLACHOldNull | Public Function IsLACHOldNull() As Boolean |
Returns whether LACHOld currently contains DBNull. |
| SetLACHOldNull | Public Sub SetLACHOldNull() |
Sets LACHOld to DBNull. |
| IsLACHOld2Null | Public Function IsLACHOld2Null() As Boolean |
Returns whether LACHOld2 currently contains DBNull. |
| SetLACHOld2Null | Public Sub SetLACHOld2Null() |
Sets LACHOld2 to DBNull. |
| IsLACHOld3Null | Public Function IsLACHOld3Null() As Boolean |
Returns whether LACHOld3 currently contains DBNull. |
| SetLACHOld3Null | Public Sub SetLACHOld3Null() |
Sets LACHOld3 to DBNull. |
Generated event and event-args types¶
| Member | Signature | Purpose |
|---|---|---|
| InstitutionRowChangeEventHandler | Public Delegate Sub InstitutionRowChangeEventHandler(ByVal sender As Object, ByVal e As InstitutionRowChangeEvent) |
Delegate signature used by the table's row-change events. |
| InstitutionRowChangeEvent | Public Class InstitutionRowChangeEvent Inherits Global.System.EventArgs |
Event-args type carrying the changed row and DataRowAction. |
| New | Public Sub New(ByVal row As InstitutionRow, ByVal action As Global.System.Data.DataRowAction) |
Creates a typed row-change event instance. |
| Row | Public ReadOnly Property Row() As InstitutionRow |
Returns the affected row. |
| Action | Public ReadOnly Property Action() As Global.System.Data.DataRowAction |
Returns the DataRowAction that triggered the event. |
Behavioral notes¶
- This is a designer-generated typed
DataSet/DataTable/DataRowtriad, not a BOF business object: it does not inheritclsBusinessBase/clsBusinessCollection, has noIBusinessCriteria, and performs no data-portal or SQL retrieval of its own. - No consumer of this type was found elsewhere in
SAIF.Business.View.Provider; it remains a standalone generated artifact in this assembly.
Constraints and usage notes¶
- As with all Visual Studio designer typed
DataSetfiles,Institutions.Designer.vbshould be treated as generated output; schema changes belong in the underlying.xsdand should then be regenerated.
Sources¶
Business\SAIF.Business.View.Provider\Institutions.Designer.vb