backupform1.vb

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

Imports System.Data.SqlClient
Public Class BackupForm1
    Inherits System.Windows.Forms.Form

    ' 数据集对象的模块层级声明
    Dim ds As DataSet = New DataSet()

#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 ComboBoxCategory As System.Windows.Forms.ComboBox
    Friend WithEvents CheckBoxSaleOrNot As System.Windows.Forms.CheckBox
    Friend WithEvents lblSaleOrNot As System.Windows.Forms.Label
    Friend WithEvents lblSafety As System.Windows.Forms.Label
    Friend WithEvents TextBoxSafety 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 lblOrderAmount As System.Windows.Forms.Label
    Friend WithEvents lblStock As System.Windows.Forms.Label
    Friend WithEvents lblPrice As System.Windows.Forms.Label
    Friend WithEvents lblUnit As System.Windows.Forms.Label
    Friend WithEvents lblCategoryID As System.Windows.Forms.Label
    Friend WithEvents lblSupplierID As System.Windows.Forms.Label
    Friend WithEvents lblProduct As System.Windows.Forms.Label
    Friend WithEvents lblProductID As System.Windows.Forms.Label
    Friend WithEvents TextBoxPosition As System.Windows.Forms.TextBox
    Friend WithEvents TextBoxOrderAmount As System.Windows.Forms.TextBox
    Friend WithEvents TextBoxStock As System.Windows.Forms.TextBox
    Friend WithEvents TextBoxPrice As System.Windows.Forms.TextBox
    Friend WithEvents TextBoxUnit As System.Windows.Forms.TextBox
    Friend WithEvents TextBoxCategoryID As System.Windows.Forms.TextBox
    Friend WithEvents TextBoxProductID As System.Windows.Forms.TextBox
    Friend WithEvents TextBoxSupplierID As System.Windows.Forms.TextBox
    Friend WithEvents TextBoxProduct As System.Windows.Forms.TextBox
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(BackupForm1))
        Me.ComboBoxCategory = New System.Windows.Forms.ComboBox()
        Me.CheckBoxSaleOrNot = New System.Windows.Forms.CheckBox()
        Me.lblSaleOrNot = New System.Windows.Forms.Label()
        Me.lblSafety = New System.Windows.Forms.Label()
        Me.TextBoxSafety = 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.lblOrderAmount = New System.Windows.Forms.Label()
        Me.lblStock = New System.Windows.Forms.Label()
        Me.lblPrice = New System.Windows.Forms.Label()
        Me.lblUnit = New System.Windows.Forms.Label()
        Me.lblCategoryID = New System.Windows.Forms.Label()
        Me.lblSupplierID = New System.Windows.Forms.Label()
        Me.lblProduct = New System.Windows.Forms.Label()
        Me.lblProductID = New System.Windows.Forms.Label()
        Me.TextBoxPosition = New System.Windows.Forms.TextBox()
        Me.TextBoxOrderAmount = New System.Windows.Forms.TextBox()
        Me.TextBoxStock = New System.Windows.Forms.TextBox()
        Me.TextBoxPrice = New System.Windows.Forms.TextBox()
        Me.TextBoxUnit = New System.Windows.Forms.TextBox()
        Me.TextBoxCategoryID = New System.Windows.Forms.TextBox()
        Me.TextBoxProductID = New System.Windows.Forms.TextBox()
        Me.TextBoxSupplierID = New System.Windows.Forms.TextBox()
        Me.TextBoxProduct = New System.Windows.Forms.TextBox()
        Me.SuspendLayout()
        '
        'ComboBoxCategory
        '
        Me.ComboBoxCategory.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
        Me.ComboBoxCategory.Location = New System.Drawing.Point(329, 78)
        Me.ComboBoxCategory.Name = "ComboBoxCategory"
        Me.ComboBoxCategory.Size = New System.Drawing.Size(121, 23)
        Me.ComboBoxCategory.TabIndex = 73
        '
        'CheckBoxSaleOrNot
        '
        Me.CheckBoxSaleOrNot.Location = New System.Drawing.Point(137, 299)
        Me.CheckBoxSaleOrNot.Name = "CheckBoxSaleOrNot"
        Me.CheckBoxSaleOrNot.Size = New System.Drawing.Size(17, 24)
        Me.CheckBoxSaleOrNot.TabIndex = 72
        '
        'lblSaleOrNot
        '
        Me.lblSaleOrNot.AutoSize = True
        Me.lblSaleOrNot.Location = New System.Drawing.Point(57, 302)
        Me.lblSaleOrNot.Name = "lblSaleOrNot"
        Me.lblSaleOrNot.Size = New System.Drawing.Size(71, 18)
        Me.lblSaleOrNot.TabIndex = 71
        Me.lblSaleOrNot.Text = "不再销售:"
        '
        'lblSafety
        '
        Me.lblSafety.AutoSize = True
        Me.lblSafety.Location = New System.Drawing.Point(57, 274)
        Me.lblSafety.Name = "lblSafety"
        Me.lblSafety.Size = New System.Drawing.Size(71, 18)
        Me.lblSafety.TabIndex = 69
        Me.lblSafety.Text = "安全存量:"
        '
        'TextBoxSafety
        '
        Me.TextBoxSafety.Location = New System.Drawing.Point(137, 271)
        Me.TextBoxSafety.Name = "TextBoxSafety"
        Me.TextBoxSafety.TabIndex = 70
        Me.TextBoxSafety.Text = ""
        '
        'btnEnd
        '
        Me.btnEnd.BackColor = System.Drawing.Color.White
        Me.btnEnd.Image = CType(resources.GetObject("btnEnd.Image"), System.Drawing.Bitmap)
        Me.btnEnd.Location = New System.Drawing.Point(278, 371)
        Me.btnEnd.Name = "btnEnd"
        Me.btnEnd.Size = New System.Drawing.Size(58, 27)
        Me.btnEnd.TabIndex = 68
        '
        'btnNext
        '
        Me.btnNext.BackColor = System.Drawing.Color.White
        Me.btnNext.Image = CType(resources.GetObject("btnNext.Image"), System.Drawing.Bitmap)
        Me.btnNext.Location = New System.Drawing.Point(199, 371)
        Me.btnNext.Name = "btnNext"
        Me.btnNext.Size = New System.Drawing.Size(58, 27)
        Me.btnNext.TabIndex = 67
        '
        'btnBack
        '
        Me.btnBack.BackColor = System.Drawing.Color.White
        Me.btnBack.Image = CType(resources.GetObject("btnBack.Image"), System.Drawing.Bitmap)
        Me.btnBack.Location = New System.Drawing.Point(120, 371)
        Me.btnBack.Name = "btnBack"
        Me.btnBack.Size = New System.Drawing.Size(58, 27)
        Me.btnBack.TabIndex = 66
        '
        'btnFirst
        '
        Me.btnFirst.BackColor = System.Drawing.Color.White
        Me.btnFirst.Image = CType(resources.GetObject("btnFirst.Image"), System.Drawing.Bitmap)
        Me.btnFirst.Location = New System.Drawing.Point(41, 371)
        Me.btnFirst.Name = "btnFirst"
        Me.btnFirst.Size = New System.Drawing.Size(58, 27)
        Me.btnFirst.TabIndex = 65
        '
        'lblOrderAmount
        '
        Me.lblOrderAmount.AutoSize = True
        Me.lblOrderAmount.Location = New System.Drawing.Point(57, 243)
        Me.lblOrderAmount.Name = "lblOrderAmount"
        Me.lblOrderAmount.Size = New System.Drawing.Size(71, 18)
        Me.lblOrderAmount.TabIndex = 62
        Me.lblOrderAmount.Text = "已订购量:"
        '
        'lblStock
        '
        Me.lblStock.AutoSize = True