bindingdemoform15.vb

是一个用SQL和VB.NET来做的源码。

' 导入命名空间
Imports System.Data.SqlClient
Imports System.Globalization
Public Class BindingDemoForm15
    Inherits System.Windows.Forms.Form

    ' 数据集对象的类层级建立
    Dim ds As DataSet = New DataSet()

    ' 关联性连接对象的类层级声明
    Dim rel As DataRelation

    ' CurrencyManager 对象的类层级声明
    Dim bmCustomers As BindingManagerBase
    Dim bmOrders As BindingManagerBase

#Region " Windows Form 设计工具产生的程序代码 "

    Public Sub New()
        MyBase.New()

        '此调用为 Windows Form 设计工具的必要项。
        InitializeComponent()

        '在 InitializeComponent() 调用之后加入所有的初始设定

    End Sub

    'Form 覆盖 Dispose 以清除组件列表。
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    '为 Windows Form 设计工具的必要项
    Private components As System.ComponentModel.IContainer

    '注意: 以下为 Windows Form 设计工具所需的程序
    '您可以使用 Windows Form 设计工具进行修改。
    '请勿使用程序代码编辑器来修改这些程序。
    Friend WithEvents Label3 As System.Windows.Forms.Label
    Friend WithEvents Label2 As System.Windows.Forms.Label
    Friend WithEvents Label1 As System.Windows.Forms.Label
    Friend WithEvents TextBoxDiscount As System.Windows.Forms.TextBox
    Friend WithEvents lblDiscount As System.Windows.Forms.Label
    Friend WithEvents TextBoxQuantity As System.Windows.Forms.TextBox
    Friend WithEvents lblQuantity As System.Windows.Forms.Label
    Friend WithEvents TextBoxPrice As System.Windows.Forms.TextBox
    Friend WithEvents lblPrice As System.Windows.Forms.Label
    Friend WithEvents TextBoxProductName As System.Windows.Forms.TextBox
    Friend WithEvents lblProductName As System.Windows.Forms.Label
    Friend WithEvents TextBoxProductID As System.Windows.Forms.TextBox
    Friend WithEvents lblProductID As System.Windows.Forms.Label
    Friend WithEvents TextBoxOrderID As System.Windows.Forms.TextBox
    Friend WithEvents lblOrderID As System.Windows.Forms.Label
    Friend WithEvents TextBoxOrderPosition As System.Windows.Forms.TextBox
    Friend WithEvents btnChildEnd As System.Windows.Forms.Button
    Friend WithEvents btnChildNext As System.Windows.Forms.Button
    Friend WithEvents btnChildBack As System.Windows.Forms.Button
    Friend WithEvents btnChildFirst As System.Windows.Forms.Button
    Friend WithEvents lblAmount As System.Windows.Forms.Label
    Friend WithEvents lblOrderDate As System.Windows.Forms.Label
    Friend WithEvents TextBoxAmount As System.Windows.Forms.TextBox
    Friend WithEvents DateTimePickerOrderDate As System.Windows.Forms.DateTimePicker
    Friend WithEvents lblPhone As System.Windows.Forms.Label
    Friend WithEvents TextBoxPhone As System.Windows.Forms.TextBox
    Friend WithEvents lblContact As System.Windows.Forms.Label
    Friend WithEvents lblCompany As System.Windows.Forms.Label
    Friend WithEvents lblCustomerID As System.Windows.Forms.Label
    Friend WithEvents TextBoxCustomerID As System.Windows.Forms.TextBox
    Friend WithEvents TextBoxContact As System.Windows.Forms.TextBox
    Friend WithEvents TextBoxCompanyName As System.Windows.Forms.TextBox
    Friend WithEvents btnEnd As System.Windows.Forms.Button
    Friend WithEvents btnNext As System.Windows.Forms.Button
    Friend WithEvents btnBack As System.Windows.Forms.Button
    Friend WithEvents btnFirst As System.Windows.Forms.Button
    Friend WithEvents TextBoxCustomerPosition As System.Windows.Forms.TextBox
    Friend WithEvents Panel1 As System.Windows.Forms.Panel
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(BindingDemoForm15))
        Me.Label3 = New System.Windows.Forms.Label()
        Me.Label2 = New System.Windows.Forms.Label()
        Me.Label1 = New System.Windows.Forms.Label()
        Me.TextBoxDiscount = New System.Windows.Forms.TextBox()
        Me.lblDiscount = New System.Windows.Forms.Label()
        Me.TextBoxQuantity = New System.Windows.Forms.TextBox()
        Me.lblQuantity = New System.Windows.Forms.Label()
        Me.TextBoxPrice = New System.Windows.Forms.TextBox()
        Me.lblPrice = New System.Windows.Forms.Label()
        Me.TextBoxProductName = New System.Windows.Forms.TextBox()
        Me.lblProductName = New System.Windows.Forms.Label()
        Me.TextBoxProductID = New System.Windows.Forms.TextBox()
        Me.lblProductID = New System.Windows.Forms.Label()
        Me.TextBoxOrderID = New System.Windows.Forms.TextBox()
        Me.lblOrderID = New System.Windows.Forms.Label()
        Me.TextBoxOrderPosition = New System.Windows.Forms.TextBox()
        Me.btnChildEnd = New System.Windows.Forms.Button()
        Me.btnChildNext = New System.Windows.Forms.Button()
        Me.btnChildBack = New System.Windows.Forms.Button()
        Me.btnChildFirst = New System.Windows.Forms.Button()
        Me.lblAmount = New System.Windows.Forms.Label()
        Me.lblOrderDate = New System.Windows.Forms.Label()
        Me.TextBoxAmount = New System.Windows.Forms.TextBox()
        Me.DateTimePickerOrderDate = New System.Windows.Forms.DateTimePicker()
        Me.lblPhone = New System.Windows.Forms.Label()
        Me.TextBoxPhone = New System.Windows.Forms.TextBox()
        Me.lblContact = New System.Windows.Forms.Label()
        Me.lblCompany = New System.Windows.Forms.Label()
        Me.lblCustomerID = New System.Windows.Forms.Label()
        Me.TextBoxCustomerID = New System.Windows.Forms.TextBox()
        Me.TextBoxContact = New System.Windows.Forms.TextBox()
        Me.TextBoxCompanyName = New System.Windows.Forms.TextBox()
        Me.btnEnd = New System.Windows.Forms.Button()
        Me.btnNext = New System.Windows.Forms.Button()
        Me.btnBack = New System.Windows.Forms.Button()
        Me.btnFirst = New System.Windows.Forms.Button()
        Me.TextBoxCustomerPosition = New System.Windows.Forms.TextBox()
        Me.Panel1 = New System.Windows.Forms.Panel()
        Me.SuspendLayout()
        '
        'Label3
        '
        Me.Label3.AutoSize = True
        Me.Label3.Font = New System.Drawing.Font("宋体", 12.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(136, Byte))
        Me.Label3.ForeColor = System.Drawing.Color.Maroon
        Me.Label3.Location = New System.Drawing.Point(24, 224)
        Me.Label3.Name = "Label3"
        Me.Label3.Size = New System.Drawing.Size(90, 24)
        Me.Label3.TabIndex = 113
        Me.Label3.Text = "订单数据"
        '
        'Label2
        '
        Me.Label2.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D
        Me.Label2.Font = New System.Drawing.Font("宋体", 12.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(136, Byte))
        Me.Label2.ForeColor = System.Drawing.Color.Maroon
        Me.Label2.Location = New System.Drawing.Point(56, 72)
        Me.Label2.Name = "Label2"
        Me.Label2.Size = New System.Drawing.Size(30, 101)
        Me.Label2.TabIndex = 112
        Me.Label2.Text = "客户数据"
        '
        'Label1
        '
        Me.Label1.AutoSize = True
        Me.Label1.Font = New System.Drawing.Font("宋体", 24.0!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(136, Byte))
        Me.Label1.ForeColor = System.Drawing.Color.FromArgb(CType(0, Byte), CType(0, Byte), CType(192, Byte))
        Me.Label1.Location = New System.Drawing.Point(168, 8)
        Me.Label1.Name = "Label1"
        Me.Label1.Size = New System.Drawing.Size(388, 48)
        Me.Label1.TabIndex = 76
        Me.Label1.Text = "一对多数据浏览界面"
        Me.Label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'TextBoxDiscount
        '
        Me.TextBoxDiscount.ForeColor = System.Drawing.Color.Blue
        Me.TextBoxDiscount.Location = New System.Drawing.Point(496, 344)
        Me.TextBoxDiscount.Name = "TextBoxDiscount"
        Me.TextBoxDiscount.TabIndex = 106
        Me.TextBoxDiscount.Text = ""
        '
        'lblDiscount
        '
        Me.lblDiscount.AutoSize = True
        Me.lblDiscount.Location = New System.Drawing.Point(448, 347)
        Me.lblDiscount.Name = "lblDiscount"
        Me.lblDiscount.Size = New System.Drawing.Size(40, 18)
        Me.lblDiscount.TabIndex = 105
        Me.lblDiscount.Text = "折扣:"
        '
        'TextBoxQuantity
        '
        Me.TextBoxQuantity.ForeColor = System.Drawing.Color.Blue
        Me.TextBoxQuantity.Location = New System.Drawing.Point(302, 344)
        Me.TextBoxQuantity.Name = "TextBoxQuantity"
        Me.TextBoxQuantity.TabIndex = 104
        Me.TextBoxQuantity.Text = ""
        '
        'lblQuantity
        '
        Me.lblQuantity.AutoSize = True
        Me.lblQuantity.Location = New System.Drawing.Point(254, 347)
        Me.lblQuantity.Name = "lblQuantity"
        Me.lblQuantity.Size = New System.Drawing.Size(40, 18)
        Me.lblQuantity.TabIndex = 103
        Me.lblQuantity.Text = "数量:"
        '
        'TextBoxPrice
        '
        Me.TextBoxPrice.ForeColor = System.Drawing.Color.Blue
        Me.TextBoxPrice.Location = New System.Drawing.Point(112, 344)
        Me.TextBoxPrice.Name = "TextBoxPrice"
        Me.TextBoxPrice.TabIndex = 102
        Me.TextBoxPrice.Text = ""
        '
        'lblPrice
        '
        Me.lblPrice.AutoSize = True
        Me.lblPrice.Location = New System.Drawing.Point(64, 347)
        Me.lblPrice.Name = "lblPrice"
        Me.lblPrice.Size = New System.Drawing.Size(40, 18)
        Me.lblPrice.TabIndex = 101
        Me.lblPrice.Text = "单价:"
        '
        'TextBoxProductName
        '
        Me.TextBoxProductName.ForeColor = System.Drawing.Color.Blue
        Me.TextBoxProductName.Location = New System.Drawing.Point(302, 304)
        Me.TextBoxProductName.Name = "TextBoxProductName"
        Me.TextBoxProductName.TabIndex = 100
        Me.TextBoxProductName.Text = ""
        '
        'lblProductName
        '
        Me.lblProductName.AutoSize = True
        Me.lblProductName.Location = New System.Drawing.Point(222, 307)
        Me.lblProductName.Name = "lblProductName"