?? dataset1.vb
字號:
Me.column班級編號.Unique = true
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
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 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 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 Property 人數 As Decimal
Get
Try
Return CType(Me(Me.table班級信息.人數Column),Decimal)
Catch e As InvalidCastException
Throw New StrongTypingException("無法獲取值,因為它是 DBNull。", e)
End Try
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
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
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
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
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
<System.Diagnostics.DebuggerStepThrough()> _
Public Class 學生信息DataTable
Inherits DataTable
Implements System.Collections.IEnumerable
Private column學號 As DataColumn
Private column姓名 As DataColumn
Private column班級編號 As DataColumn
Private column性別 As DataColumn
Private column年級 As DataColumn
Private column身份證號 As DataColumn
Private column政治面貌編號 As DataColumn
Private column民族編號 As DataColumn
Private column籍貫編號 As DataColumn
Private column學籍編號 As DataColumn
Friend Sub New()
MyBase.New("學生信息")
Me.InitClass
End Sub
Friend Sub New(ByVal table As DataTable)
MyBase.New(table.TableName)
If (table.CaseSensitive <> table.DataSet.CaseSensitive) Then
Me.CaseSensitive = table.CaseSensitive
End If
If (table.Locale.ToString <> table.DataSet.Locale.ToString) Then
Me.Locale = table.Locale
End If
If (table.Namespace <> table.DataSet.Namespace) Then
Me.Namespace = table.Namespace
End If
Me.Prefix = table.Prefix
Me.MinimumCapacity = table.MinimumCapacity
Me.DisplayExpression = table.DisplayExpression
End Sub
<System.ComponentModel.Browsable(false)> _
Public ReadOnly Property Count As Integer
Get
Return Me.Rows.Count
End Get
End Property
Friend ReadOnly Property 學號Column As DataColumn
Get
Return Me.column學號
End Get
End Property
Friend ReadOnly Property 姓名Column As DataColumn
Get
Return Me.column姓名
End Get
End Property
Friend ReadOnly Property 班級編號Column As DataColumn
Get
Return Me.column班級編號
End Get
End Property
Friend ReadOnly Property 性別Column As DataColumn
Get
Return Me.column性別
End Get
End Property
Friend ReadOnly Property 年級Column As DataColumn
Get
Return Me.column年級
End Get
End Property
Friend ReadOnly Property 身份證號Column As DataColumn
Get
Return Me.column身份證號
End Get
End Property
Friend ReadOnly Property 政治面貌編號Column As DataColumn
Get
Return Me.column政治面貌編號
End Get
End Property
Friend ReadOnly Property 民族編號Column As DataColumn
Get
Return Me.column民族編號
End Get
End Property
Friend ReadOnly Property 籍貫編號Column As DataColumn
Get
Return Me.column籍貫編號
End Get
End Property
Friend ReadOnly Property 學籍編號Column As DataColumn
Get
Return Me.column學籍編號
End Get
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, ByVal 年級 As Integer, ByVal 身份證號 As String, 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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -