dataform1.vb

用vb.net写的基于c/s结构的进销存程序设计源代码

        Me.lblNavLocation.Name = "lblNavLocation"
        Me.lblNavLocation.Size = New System.Drawing.Size(95, 23)
        Me.lblNavLocation.TabIndex = 26
        Me.lblNavLocation.Text = "无记录"
        Me.lblNavLocation.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'btnNavNext
        '
        Me.btnNavNext.Location = New System.Drawing.Point(365, 241)
        Me.btnNavNext.Name = "btnNavNext"
        Me.btnNavNext.Size = New System.Drawing.Size(35, 23)
        Me.btnNavNext.TabIndex = 27
        Me.btnNavNext.Text = ">"
        '
        'btnLast
        '
        Me.btnLast.Location = New System.Drawing.Point(400, 241)
        Me.btnLast.Name = "btnLast"
        Me.btnLast.Size = New System.Drawing.Size(40, 23)
        Me.btnLast.TabIndex = 28
        Me.btnLast.Text = ">>"
        '
        'btnAdd
        '
        Me.btnAdd.Location = New System.Drawing.Point(195, 274)
        Me.btnAdd.Name = "btnAdd"
        Me.btnAdd.TabIndex = 29
        Me.btnAdd.Text = "添加(&A)"
        '
        'btnDelete
        '
        Me.btnDelete.Location = New System.Drawing.Point(280, 274)
        Me.btnDelete.Name = "btnDelete"
        Me.btnDelete.TabIndex = 30
        Me.btnDelete.Text = "删除(&D)"
        '
        'btnCancel
        '
        Me.btnCancel.Location = New System.Drawing.Point(365, 274)
        Me.btnCancel.Name = "btnCancel"
        Me.btnCancel.TabIndex = 31
        Me.btnCancel.Text = "取消(&C)"
        '
        'DataForm1
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(442, 322)
        Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.btnLoad, Me.btnUpdate, Me.lblCustomerID, Me.lblCompanyName, Me.lblContactName, Me.lblContactTitle, Me.lblAddress, Me.lblCity, Me.editCustomerID, Me.editCompanyName, Me.editContactName, Me.editContactTitle, Me.editAddress, Me.editCity, Me.lblRegion, Me.lblPostalCode, Me.lblCountry, Me.lblPhone, Me.lblFax, Me.editRegion, Me.editPostalCode, Me.editCountry, Me.editPhone, Me.editFax, Me.btnNavFirst, Me.btnNavPrev, Me.lblNavLocation, Me.btnNavNext, Me.btnLast, Me.btnAdd, Me.btnDelete, Me.btnCancel})
        Me.Name = "DataForm1"
        Me.Text = "DataForm1"
        CType(Me.objdsNorthWind, System.ComponentModel.ISupportInitialize).EndInit()
        Me.ResumeLayout(False)

    End Sub

#End Region

    Private Sub btnCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCancel.Click
        Me.BindingContext(objdsNorthWind, "Customers").CancelCurrentEdit()
        Me.objdsNorthWind_PositionChanged()

    End Sub
    Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
        If (Me.BindingContext(objdsNorthWind, "Customers").Count > 0) Then
            Me.BindingContext(objdsNorthWind, "Customers").RemoveAt(Me.BindingContext(objdsNorthWind, "Customers").Position)
            Me.objdsNorthWind_PositionChanged()
        End If

    End Sub
    Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
        Try
            '清除当前编辑内容
            Me.BindingContext(objdsNorthWind, "Customers").EndCurrentEdit()
            Me.BindingContext(objdsNorthWind, "Customers").AddNew()
        Catch eEndEdit As System.Exception
            System.Windows.Forms.MessageBox.Show(eEndEdit.Message)
        End Try
        Me.objdsNorthWind_PositionChanged()

    End Sub
    Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
        Try
            '尝试更新数据源。
            Me.UpdateDataSet()
        Catch eUpdate As System.Exception
            '在此处添加错误处理代码。
            '显示错误信息（如果有）。
            System.Windows.Forms.MessageBox.Show(eUpdate.Message)
        End Try
        Me.objdsNorthWind_PositionChanged()

    End Sub
    Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click
        Try
            '尝试加载数据集。
            Me.LoadDataSet()
        Catch eLoad As System.Exception
            '在此处添加错误处理代码。
            '显示错误信息（如果有）。
            System.Windows.Forms.MessageBox.Show(eLoad.Message)
        End Try
        Me.objdsNorthWind_PositionChanged()

    End Sub
    Private Sub btnNavFirst_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNavFirst.Click
        Me.BindingContext(objdsNorthWind, "Customers").Position = 0
        Me.objdsNorthWind_PositionChanged()

    End Sub
    Private Sub btnLast_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLast.Click
        Me.BindingContext(objdsNorthWind, "Customers").Position = (Me.objdsNorthWind.Tables("Customers").Rows.Count - 1)
        Me.objdsNorthWind_PositionChanged()

    End Sub
    Private Sub btnNavPrev_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNavPrev.Click
        Me.BindingContext(objdsNorthWind, "Customers").Position = (Me.BindingContext(objdsNorthWind, "Customers").Position - 1)
        Me.objdsNorthWind_PositionChanged()

    End Sub
    Private Sub btnNavNext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNavNext.Click
        Me.BindingContext(objdsNorthWind, "Customers").Position = (Me.BindingContext(objdsNorthWind, "Customers").Position + 1)
        Me.objdsNorthWind_PositionChanged()

    End Sub
    Private Sub objdsNorthWind_PositionChanged()
        Me.lblNavLocation.Text = (((Me.BindingContext(objdsNorthWind, "Customers").Position + 1).ToString + " 的 ") _
                    + Me.BindingContext(objdsNorthWind, "Customers").Count.ToString)

    End Sub
    Public Sub UpdateDataSet()
        '创建一个新数据集来保存对主数据集所做的更改。
        Dim objDataSetChanges As WindowsApplication1.dsNorthWind = New WindowsApplication1.dsNorthWind()
        '停止当前的任何编辑。
        Me.BindingContext(objdsNorthWind, "Customers").EndCurrentEdit()
        '获取对主数据集所做的更改。
        objDataSetChanges = CType(objdsNorthWind.GetChanges, WindowsApplication1.dsNorthWind)
        '检查是否做了任何更改。
        If (Not (objDataSetChanges) Is Nothing) Then
            Try
                '需要做一些更改，所以尝试通过调用 update 方法
                '和传递数据集以及任何参数来更新数据源。
                Me.UpdateDataSource(objDataSetChanges)
                objdsNorthWind.Merge(objDataSetChanges)
                objdsNorthWind.AcceptChanges()
            Catch eUpdate As System.Exception
                '在此处添加错误处理代码。
                Throw eUpdate
            End Try
            '添加代码以检查返回的数据集中是否有任何可能已被
            '推入到行对象错误中的错误。
        End If

    End Sub
    Public Sub LoadDataSet()
        '创建一个新数据集以保存从 FillDataSet 调用返回的记录。
        '使用了一个临时数据集，这是因为填充现有的数据集
        '需要重新绑定数据绑定。
        Dim objDataSetTemp As WindowsApplication1.dsNorthWind
        objDataSetTemp = New WindowsApplication1.dsNorthWind()
        Try
            '尝试填充临时数据集。
            Me.FillDataSet(objDataSetTemp)
        Catch eFillDataSet As System.Exception
            '在此处添加错误处理代码。
            Throw eFillDataSet
        End Try
        Try
            '清空数据集中的旧记录。
            objdsNorthWind.Clear()
            '将记录合并到主数据集中。
            objdsNorthWind.Merge(objDataSetTemp)
        Catch eLoadMerge As System.Exception
            '在此处添加错误处理代码。
            Throw eLoadMerge
        End Try

    End Sub
    Public Sub UpdateDataSource(ByVal ChangedRows As WindowsApplication1.dsNorthWind)
        Try
            '在有挂起的更改时，只需要更新数据源即可。
            If (Not (ChangedRows) Is Nothing) Then
                '打开连接。
                Me.OleDbConnection1.Open()
                '尝试更新数据源。
                OleDbDataAdapter1.Update(ChangedRows)
            End If
        Catch updateException As System.Exception
            '在此处添加错误处理代码。
            Throw updateException
        Finally
            '无论是否引发了异常都关闭连接。
            Me.OleDbConnection1.Close()
        End Try

    End Sub
    Public Sub FillDataSet(ByVal dataSet As WindowsApplication1.dsNorthWind)
        '在填充数据集前关闭约束检查。
        '这允许适配器填充数据集而不用考虑
        '表之间的依赖项。
        dataSet.EnforceConstraints = False
        Try
            '打开连接。
            Me.OleDbConnection1.Open()
            '尝试通过 OleDbDataAdapter1 填充数据集。
            Me.OleDbDataAdapter1.Fill(dataSet)
        Catch fillException As System.Exception
            '在此处添加错误处理代码。
            Throw fillException
        Finally
            '重新打开约束检查。
            dataSet.EnforceConstraints = True
            '无论是否引发了异常都关闭连接。
            Me.OleDbConnection1.Close()
        End Try

    End Sub
End Class