📄 dataset3.vb
字号:
'------------------------------------------------------------------------------
' <autogenerated>
' This code was generated by a tool.
' Runtime Version: 1.0.3705.209
'
' Changes to this file may cause incorrect behavior and will be lost if
' the code is regenerated.
' </autogenerated>
'------------------------------------------------------------------------------
Option Strict Off
Option Explicit On
Imports System
Imports System.Data
Imports System.Runtime.Serialization
Imports System.Xml
<Serializable(), _
System.ComponentModel.DesignerCategoryAttribute("code"), _
System.Diagnostics.DebuggerStepThrough(), _
System.ComponentModel.ToolboxItem(true)> _
Public Class DataSet3
Inherits DataSet
Private table_Table As _TableDataTable
Public Sub New()
MyBase.New
Me.InitClass
Dim schemaChangedHandler As System.ComponentModel.CollectionChangeEventHandler = AddressOf Me.SchemaChanged
AddHandler Me.Tables.CollectionChanged, schemaChangedHandler
AddHandler Me.Relations.CollectionChanged, schemaChangedHandler
End Sub
Protected Sub New(ByVal info As SerializationInfo, ByVal context As StreamingContext)
MyBase.New
Dim strSchema As String = CType(info.GetValue("XmlSchema", GetType(System.String)),String)
If (Not (strSchema) Is Nothing) Then
Dim ds As DataSet = New DataSet
ds.ReadXmlSchema(New XmlTextReader(New System.IO.StringReader(strSchema)))
If (Not (ds.Tables("Table")) Is Nothing) Then
Me.Tables.Add(New _TableDataTable(ds.Tables("Table")))
End If
Me.DataSetName = ds.DataSetName
Me.Prefix = ds.Prefix
Me.Namespace = ds.Namespace
Me.Locale = ds.Locale
Me.CaseSensitive = ds.CaseSensitive
Me.EnforceConstraints = ds.EnforceConstraints
Me.Merge(ds, false, System.Data.MissingSchemaAction.Add)
Me.InitVars
Else
Me.InitClass
End If
Me.GetSerializationData(info, context)
Dim schemaChangedHandler As System.ComponentModel.CollectionChangeEventHandler = AddressOf Me.SchemaChanged
AddHandler Me.Tables.CollectionChanged, schemaChangedHandler
AddHandler Me.Relations.CollectionChanged, schemaChangedHandler
End Sub
<System.ComponentModel.Browsable(false), _
System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Content)> _
Public ReadOnly Property _Table As _TableDataTable
Get
Return Me.table_Table
End Get
End Property
Public Overrides Function Clone() As DataSet
Dim cln As DataSet3 = CType(MyBase.Clone,DataSet3)
cln.InitVars
Return cln
End Function
Protected Overrides Function ShouldSerializeTables() As Boolean
Return false
End Function
Protected Overrides Function ShouldSerializeRelations() As Boolean
Return false
End Function
Protected Overrides Sub ReadXmlSerializable(ByVal reader As XmlReader)
Me.Reset
Dim ds As DataSet = New DataSet
ds.ReadXml(reader)
If (Not (ds.Tables("Table")) Is Nothing) Then
Me.Tables.Add(New _TableDataTable(ds.Tables("Table")))
End If
Me.DataSetName = ds.DataSetName
Me.Prefix = ds.Prefix
Me.Namespace = ds.Namespace
Me.Locale = ds.Locale
Me.CaseSensitive = ds.CaseSensitive
Me.EnforceConstraints = ds.EnforceConstraints
Me.Merge(ds, false, System.Data.MissingSchemaAction.Add)
Me.InitVars
End Sub
Protected Overrides Function GetSchemaSerializable() As System.Xml.Schema.XmlSchema
Dim stream As System.IO.MemoryStream = New System.IO.MemoryStream
Me.WriteXmlSchema(New XmlTextWriter(stream, Nothing))
stream.Position = 0
Return System.Xml.Schema.XmlSchema.Read(New XmlTextReader(stream), Nothing)
End Function
Friend Sub InitVars()
Me.table_Table = CType(Me.Tables("Table"),_TableDataTable)
If (Not (Me.table_Table) Is Nothing) Then
Me.table_Table.InitVars
End If
End Sub
Private Sub InitClass()
Me.DataSetName = "DataSet3"
Me.Prefix = ""
Me.Namespace = "http://www.tempuri.org/DataSet3.xsd"
Me.Locale = New System.Globalization.CultureInfo("zh-CN")
Me.CaseSensitive = false
Me.EnforceConstraints = true
Me.table_Table = New _TableDataTable
Me.Tables.Add(Me.table_Table)
End Sub
Private Function ShouldSerialize_Table() As Boolean
Return false
End Function
Private Sub SchemaChanged(ByVal sender As Object, ByVal e As System.ComponentModel.CollectionChangeEventArgs)
If (e.Action = System.ComponentModel.CollectionChangeAction.Remove) Then
Me.InitVars
End If
End Sub
Public Delegate Sub _TableRowChangeEventHandler(ByVal sender As Object, ByVal e As _TableRowChangeEvent)
<System.Diagnostics.DebuggerStepThrough()> _
Public Class _TableDataTable
Inherits DataTable
Implements System.Collections.IEnumerable
Private column日期 As DataColumn
Private column项目名称 As DataColumn
Private column金额 As DataColumn
Friend Sub New()
MyBase.New("Table")
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
Public Default ReadOnly Property Item(ByVal index As Integer) As _TableRow
Get
Return CType(Me.Rows(index),_TableRow)
End Get
End Property
Public Event _TableRowChanged As _TableRowChangeEventHandler
Public Event _TableRowChanging As _TableRowChangeEventHandler
Public Event _TableRowDeleted As _TableRowChangeEventHandler
Public Event _TableRowDeleting As _TableRowChangeEventHandler
Public Overloads Sub Add_TableRow(ByVal row As _TableRow)
Me.Rows.Add(row)
End Sub
Public Overloads Function Add_TableRow(ByVal 日期 As String, ByVal 项目名称 As String, ByVal 金额 As String) As _TableRow
Dim row_TableRow As _TableRow = CType(Me.NewRow,_TableRow)
row_TableRow.ItemArray = New Object() {日期, 项目名称, 金额}
Me.Rows.Add(row_TableRow)
Return row_TableRow
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 _TableDataTable = CType(MyBase.Clone,_TableDataTable)
cln.InitVars
Return cln
End Function
Protected Overrides Function CreateInstance() As DataTable
Return New _TableDataTable
End Function
Friend Sub InitVars()
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金额)
End Sub
Public Function New_TableRow() As _TableRow
Return CType(Me.NewRow,_TableRow)
End Function
Protected Overrides Function NewRowFromBuilder(ByVal builder As DataRowBuilder) As DataRow
Return New _TableRow(builder)
End Function
Protected Overrides Function GetRowType() As System.Type
Return GetType(_TableRow)
End Function
Protected Overrides Sub OnRowChanged(ByVal e As DataRowChangeEventArgs)
MyBase.OnRowChanged(e)
If (Not (Me._TableRowChangedEvent) Is Nothing) Then
RaiseEvent _TableRowChanged(Me, New _TableRowChangeEvent(CType(e.Row,_TableRow), e.Action))
End If
End Sub
Protected Overrides Sub OnRowChanging(ByVal e As DataRowChangeEventArgs)
MyBase.OnRowChanging(e)
If (Not (Me._TableRowChangingEvent) Is Nothing) Then
RaiseEvent _TableRowChanging(Me, New _TableRowChangeEvent(CType(e.Row,_TableRow), e.Action))
End If
End Sub
Protected Overrides Sub OnRowDeleted(ByVal e As DataRowChangeEventArgs)
MyBase.OnRowDeleted(e)
If (Not (Me._TableRowDeletedEvent) Is Nothing) Then
RaiseEvent _TableRowDeleted(Me, New _TableRowChangeEvent(CType(e.Row,_TableRow), e.Action))
End If
End Sub
Protected Overrides Sub OnRowDeleting(ByVal e As DataRowChangeEventArgs)
MyBase.OnRowDeleting(e)
If (Not (Me._TableRowDeletingEvent) Is Nothing) Then
RaiseEvent _TableRowDeleting(Me, New _TableRowChangeEvent(CType(e.Row,_TableRow), e.Action))
End If
End Sub
Public Sub Remove_TableRow(ByVal row As _TableRow)
Me.Rows.Remove(row)
End Sub
End Class
<System.Diagnostics.DebuggerStepThrough()> _
Public Class _TableRow
Inherits DataRow
Private table_Table As _TableDataTable
Friend Sub New(ByVal rb As DataRowBuilder)
MyBase.New(rb)
Me.table_Table = CType(Me.Table,_TableDataTable)
End Sub
Public Property 日期 As String
Get
Try
Return CType(Me(Me.table_Table.日期Column),String)
Catch e As InvalidCastException
Throw New StrongTypingException("无法获取值,因为它是 DBNull。", e)
End Try
End Get
Set
Me(Me.table_Table.日期Column) = value
End Set
End Property
Public Property 项目名称 As String
Get
Try
Return CType(Me(Me.table_Table.项目名称Column),String)
Catch e As InvalidCastException
Throw New StrongTypingException("无法获取值,因为它是 DBNull。", e)
End Try
End Get
Set
Me(Me.table_Table.项目名称Column) = value
End Set
End Property
Public Property 金额 As String
Get
Try
Return CType(Me(Me.table_Table.金额Column),String)
Catch e As InvalidCastException
Throw New StrongTypingException("无法获取值,因为它是 DBNull。", e)
End Try
End Get
Set
Me(Me.table_Table.金额Column) = value
End Set
End Property
Public Function Is日期Null() As Boolean
Return Me.IsNull(Me.table_Table.日期Column)
End Function
Public Sub Set日期Null()
Me(Me.table_Table.日期Column) = System.Convert.DBNull
End Sub
Public Function Is项目名称Null() As Boolean
Return Me.IsNull(Me.table_Table.项目名称Column)
End Function
Public Sub Set项目名称Null()
Me(Me.table_Table.项目名称Column) = System.Convert.DBNull
End Sub
Public Function Is金额Null() As Boolean
Return Me.IsNull(Me.table_Table.金额Column)
End Function
Public Sub Set金额Null()
Me(Me.table_Table.金额Column) = System.Convert.DBNull
End Sub
End Class
<System.Diagnostics.DebuggerStepThrough()> _
Public Class _TableRowChangeEvent
Inherits EventArgs
Private eventRow As _TableRow
Private eventAction As DataRowAction
Public Sub New(ByVal row As _TableRow, ByVal action As DataRowAction)
MyBase.New
Me.eventRow = row
Me.eventAction = action
End Sub
Public ReadOnly Property Row As _TableRow
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 + -