?? ds4.vb
字號:
End Property
Public Default ReadOnly Property Item(ByVal index As Integer) As 管理員Row
Get
Return CType(Me.Rows(index),管理員Row)
End Get
End Property
Public Event 管理員RowChanged As 管理員RowChangeEventHandler
Public Event 管理員RowChanging As 管理員RowChangeEventHandler
Public Event 管理員RowDeleted As 管理員RowChangeEventHandler
Public Event 管理員RowDeleting As 管理員RowChangeEventHandler
Public Overloads Sub Add管理員Row(ByVal row As 管理員Row)
Me.Rows.Add(row)
End Sub
Public Overloads Function Add管理員Row(ByVal 帳號 As String, ByVal 密碼 As String, ByVal 姓名 As String, ByVal 類型 As String) As 管理員Row
Dim row管理員Row As 管理員Row = CType(Me.NewRow,管理員Row)
row管理員Row.ItemArray = New Object() {帳號, 密碼, 姓名, 類型}
Me.Rows.Add(row管理員Row)
Return row管理員Row
End Function
Public Function FindBy帳號(ByVal 帳號 As String) As 管理員Row
Return CType(Me.Rows.Find(New Object() {帳號}),管理員Row)
End Function
Public Function GetEnumerator() As System.Collections.IEnumerator Implements System.Collections.IEnumerable.GetEnumerator
Return Me.Rows.GetEnumerator
End Function
Public Overrides Function Clone() As DataTable
Dim cln As 管理員DataTable = CType(MyBase.Clone,管理員DataTable)
cln.InitVars
Return cln
End Function
Protected Overrides Function CreateInstance() As DataTable
Return New 管理員DataTable
End Function
Friend Sub InitVars()
Me.column帳號 = Me.Columns("帳號")
Me.column密碼 = Me.Columns("密碼")
Me.column姓名 = Me.Columns("姓名")
Me.column類型 = Me.Columns("類型")
End Sub
Private Sub InitClass()
Me.column帳號 = New DataColumn("帳號", GetType(System.String), Nothing, System.Data.MappingType.Element)
Me.Columns.Add(Me.column帳號)
Me.column密碼 = New DataColumn("密碼", GetType(System.String), Nothing, System.Data.MappingType.Element)
Me.Columns.Add(Me.column密碼)
Me.column姓名 = New DataColumn("姓名", GetType(System.String), Nothing, System.Data.MappingType.Element)
Me.Columns.Add(Me.column姓名)
Me.column類型 = New DataColumn("類型", GetType(System.String), Nothing, System.Data.MappingType.Element)
Me.Columns.Add(Me.column類型)
Me.Constraints.Add(New UniqueConstraint("Constraint1", New DataColumn() {Me.column帳號}, true))
Me.column帳號.AllowDBNull = false
Me.column帳號.Unique = true
Me.column密碼.AllowDBNull = false
Me.column姓名.AllowDBNull = false
End Sub
Public Function New管理員Row() As 管理員Row
Return CType(Me.NewRow,管理員Row)
End Function
Protected Overrides Function NewRowFromBuilder(ByVal builder As DataRowBuilder) As DataRow
Return New 管理員Row(builder)
End Function
Protected Overrides Function GetRowType() As System.Type
Return GetType(管理員Row)
End Function
Protected Overrides Sub OnRowChanged(ByVal e As DataRowChangeEventArgs)
MyBase.OnRowChanged(e)
If (Not (Me.管理員RowChangedEvent) Is Nothing) Then
RaiseEvent 管理員RowChanged(Me, New 管理員RowChangeEvent(CType(e.Row,管理員Row), e.Action))
End If
End Sub
Protected Overrides Sub OnRowChanging(ByVal e As DataRowChangeEventArgs)
MyBase.OnRowChanging(e)
If (Not (Me.管理員RowChangingEvent) Is Nothing) Then
RaiseEvent 管理員RowChanging(Me, New 管理員RowChangeEvent(CType(e.Row,管理員Row), e.Action))
End If
End Sub
Protected Overrides Sub OnRowDeleted(ByVal e As DataRowChangeEventArgs)
MyBase.OnRowDeleted(e)
If (Not (Me.管理員RowDeletedEvent) Is Nothing) Then
RaiseEvent 管理員RowDeleted(Me, New 管理員RowChangeEvent(CType(e.Row,管理員Row), e.Action))
End If
End Sub
Protected Overrides Sub OnRowDeleting(ByVal e As DataRowChangeEventArgs)
MyBase.OnRowDeleting(e)
If (Not (Me.管理員RowDeletingEvent) Is Nothing) Then
RaiseEvent 管理員RowDeleting(Me, New 管理員RowChangeEvent(CType(e.Row,管理員Row), e.Action))
End If
End Sub
Public Sub Remove管理員Row(ByVal row As 管理員Row)
Me.Rows.Remove(row)
End Sub
End Class
<System.Diagnostics.DebuggerStepThrough()> _
Public Class 管理員Row
Inherits DataRow
Private table管理員 As 管理員DataTable
Friend Sub New(ByVal rb As DataRowBuilder)
MyBase.New(rb)
Me.table管理員 = CType(Me.Table,管理員DataTable)
End Sub
Public Property 帳號 As String
Get
Return CType(Me(Me.table管理員.帳號Column),String)
End Get
Set
Me(Me.table管理員.帳號Column) = value
End Set
End Property
Public Property 密碼 As String
Get
Return CType(Me(Me.table管理員.密碼Column),String)
End Get
Set
Me(Me.table管理員.密碼Column) = value
End Set
End Property
Public Property 姓名 As String
Get
Return CType(Me(Me.table管理員.姓名Column),String)
End Get
Set
Me(Me.table管理員.姓名Column) = value
End Set
End Property
Public Property 類型 As String
Get
Try
Return CType(Me(Me.table管理員.類型Column),String)
Catch e As InvalidCastException
Throw New StrongTypingException("無法獲取值,因為它是 DBNull。", e)
End Try
End Get
Set
Me(Me.table管理員.類型Column) = value
End Set
End Property
Public Function Is類型Null() As Boolean
Return Me.IsNull(Me.table管理員.類型Column)
End Function
Public Sub Set類型Null()
Me(Me.table管理員.類型Column) = System.Convert.DBNull
End Sub
End Class
<System.Diagnostics.DebuggerStepThrough()> _
Public Class 管理員RowChangeEvent
Inherits EventArgs
Private eventRow As 管理員Row
Private eventAction As DataRowAction
Public Sub New(ByVal row As 管理員Row, ByVal action As DataRowAction)
MyBase.New
Me.eventRow = row
Me.eventAction = action
End Sub
Public ReadOnly Property Row As 管理員Row
Get
Return Me.eventRow
End Get
End Property
Public ReadOnly Property Action As DataRowAction
Get
Return Me.eventAction
End Get
End Property
End Class
End Class
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -