dataset1.vb
来自「是一个工资的管理系统 利用的是VB.NET和sql2000来完成的」· VB 代码 · 共 493 行 · 第 1/2 页
VB
493 行
'------------------------------------------------------------------------------
' <autogenerated>
' This code was generated by a tool.
' Runtime Version: 1.1.4322.573
'
' 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 DataSet1
Inherits DataSet
Private table总表 As 总表DataTable
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("总表")) Is Nothing) Then
Me.Tables.Add(New 总表DataTable(ds.Tables("总表")))
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 总表 As 总表DataTable
Get
Return Me.table总表
End Get
End Property
Public Overrides Function Clone() As DataSet
Dim cln As DataSet1 = CType(MyBase.Clone,DataSet1)
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("总表")) Is Nothing) Then
Me.Tables.Add(New 总表DataTable(ds.Tables("总表")))
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总表 = CType(Me.Tables("总表"),总表DataTable)
If (Not (Me.table总表) Is Nothing) Then
Me.table总表.InitVars
End If
End Sub
Private Sub InitClass()
Me.DataSetName = "DataSet1"
Me.Prefix = ""
Me.Namespace = "http://www.tempuri.org/DataSet1.xsd"
Me.Locale = New System.Globalization.CultureInfo("zh-CN")
Me.CaseSensitive = false
Me.EnforceConstraints = true
Me.table总表 = New 总表DataTable
Me.Tables.Add(Me.table总表)
End Sub
Private Function ShouldSerialize总表() 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 总表RowChangeEventHandler(ByVal sender As Object, ByVal e As 总表RowChangeEvent)
<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
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
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 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 GetEnumerator() As System.Collections.IEnumerator Implements System.Collections.IEnumerable.GetEnumerator
Return Me.Rows.GetEnumerator
End Function
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?