dataform2.vb

Visual Basic .NET程序设计教程源代码

        Me.editname.Text = ""
        '
        'editpc
        '
        Me.editpc.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.objDataSet1, "detail.pc"))
        Me.editpc.Location = New System.Drawing.Point(340, 175)
        Me.editpc.Name = "editpc"
        Me.editpc.TabIndex = 21
        Me.editpc.Text = ""
        '
        'editphone
        '
        Me.editphone.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.objDataSet1, "detail.phone"))
        Me.editphone.Location = New System.Drawing.Point(340, 208)
        Me.editphone.Name = "editphone"
        Me.editphone.TabIndex = 22
        Me.editphone.Text = ""
        '
        'btnNavFirst
        '
        Me.btnNavFirst.Location = New System.Drawing.Point(195, 241)
        Me.btnNavFirst.Name = "btnNavFirst"
        Me.btnNavFirst.Size = New System.Drawing.Size(40, 23)
        Me.btnNavFirst.TabIndex = 23
        Me.btnNavFirst.Text = "<<"
        '
        'btnNavPrev
        '
        Me.btnNavPrev.Location = New System.Drawing.Point(235, 241)
        Me.btnNavPrev.Name = "btnNavPrev"
        Me.btnNavPrev.Size = New System.Drawing.Size(35, 23)
        Me.btnNavPrev.TabIndex = 24
        Me.btnNavPrev.Text = "<"
        '
        'lblNavLocation
        '
        Me.lblNavLocation.BackColor = System.Drawing.Color.White
        Me.lblNavLocation.Location = New System.Drawing.Point(270, 241)
        Me.lblNavLocation.Name = "lblNavLocation"
        Me.lblNavLocation.Size = New System.Drawing.Size(95, 23)
        Me.lblNavLocation.TabIndex = 25
        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 = 26
        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 = 27
        Me.btnLast.Text = ">>"
        '
        'btnAdd
        '
        Me.btnAdd.Location = New System.Drawing.Point(195, 274)
        Me.btnAdd.Name = "btnAdd"
        Me.btnAdd.TabIndex = 28
        Me.btnAdd.Text = "添加(&A)"
        '
        'btnDelete
        '
        Me.btnDelete.Location = New System.Drawing.Point(280, 274)
        Me.btnDelete.Name = "btnDelete"
        Me.btnDelete.TabIndex = 29
        Me.btnDelete.Text = "删除(&D)"
        '
        'btnCancel
        '
        Me.btnCancel.Location = New System.Drawing.Point(365, 274)
        Me.btnCancel.Name = "btnCancel"
        Me.btnCancel.TabIndex = 30
        Me.btnCancel.Text = "取消(&C)"
        '
        'DataForm2
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(442, 322)
        Me.Controls.Add(Me.btnLoad)
        Me.Controls.Add(Me.btnUpdate)
        Me.Controls.Add(Me.btnCancelAll)
        Me.Controls.Add(Me.lbladdress)
        Me.Controls.Add(Me.lblbirth)
        Me.Controls.Add(Me.lblbp)
        Me.Controls.Add(Me.lbldemo)
        Me.Controls.Add(Me.lblemail)
        Me.Controls.Add(Me.editaddress)
        Me.Controls.Add(Me.editbirth)
        Me.Controls.Add(Me.editbp)
        Me.Controls.Add(Me.editdemo)
        Me.Controls.Add(Me.editemail)
        Me.Controls.Add(Me.lblid)
        Me.Controls.Add(Me.lblmobile)
        Me.Controls.Add(Me.lblname)
        Me.Controls.Add(Me.lblpc)
        Me.Controls.Add(Me.lblphone)
        Me.Controls.Add(Me.editid)
        Me.Controls.Add(Me.editmobile)
        Me.Controls.Add(Me.editname)
        Me.Controls.Add(Me.editpc)
        Me.Controls.Add(Me.editphone)
        Me.Controls.Add(Me.btnNavFirst)
        Me.Controls.Add(Me.btnNavPrev)
        Me.Controls.Add(Me.lblNavLocation)
        Me.Controls.Add(Me.btnNavNext)
        Me.Controls.Add(Me.btnLast)
        Me.Controls.Add(Me.btnAdd)
        Me.Controls.Add(Me.btnDelete)
        Me.Controls.Add(Me.btnCancel)
        Me.Name = "DataForm2"
        Me.Text = "DataForm2"
        CType(Me.objDataSet1, 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(objDataSet1, "detail").CancelCurrentEdit()
        Me.objDataSet1_PositionChanged()

    End Sub
    Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
        If (Me.BindingContext(objDataSet1, "detail").Count > 0) Then
            Me.BindingContext(objDataSet1, "detail").RemoveAt(Me.BindingContext(objDataSet1, "detail").Position)
            Me.objDataSet1_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(objDataSet1, "detail").EndCurrentEdit()
            Me.BindingContext(objDataSet1, "detail").AddNew()
        Catch eEndEdit As System.Exception
            System.Windows.Forms.MessageBox.Show(eEndEdit.Message)
        End Try
        Me.objDataSet1_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.objDataSet1_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.objDataSet1_PositionChanged()

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

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

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

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

    End Sub
    Private Sub objDataSet1_PositionChanged()
        Me.lblNavLocation.Text = (((Me.BindingContext(objDataSet1, "detail").Position + 1).ToString + " 的 ") _
                    + Me.BindingContext(objDataSet1, "detail").Count.ToString)

    End Sub
    Private Sub btnCancelAll_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCancelAll.Click
        Me.objDataSet1.RejectChanges()

    End Sub
    Public Sub UpdateDataSet()
        '创建一个新数据集来保存对主数据集所做的更改。
        Dim objDataSetChanges As WindowsApplication1.DataSet1 = New WindowsApplication1.DataSet1
        Dim objDataSetUpdated As System.Data.DataSet = New WindowsApplication1.DataSet1
        '停止当前的任何编辑。
        Me.BindingContext(objDataSet1, "detail").EndCurrentEdit()
        '获取对主数据集所做的更改。
        objDataSetChanges = CType(objDataSet1.GetChanges, WindowsApplication1.DataSet1)
        '检查是否做了任何更改。
        If (Not (objDataSetChanges) Is Nothing) Then
            Try
                '需要做一些更改，所以尝试通过调用 update 方法
                '和传递数据集以及任何参数来更新数据源。
                objDataSetUpdated = Me.objDataSet1.Clone
            Catch eUpdate As System.Exception
                '在此处添加错误处理代码。
                Throw eUpdate
            End Try
            '添加代码以检查返回的数据集中是否有任何可能已被
            '推入到行对象错误中的错误。
            Try
                objDataSet1.Merge(objDataSetUpdated)
            Catch eUpdateMerge As System.Exception
                '在此处添加异常处理代码
                Throw eUpdateMerge
            End Try
            '提交刚刚合并的更改
            '这将会改动任何标记为已更新、已插入或已更改的行，将其标记为原始值
            objDataSet1.AcceptChanges()
        End If

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

    End Sub
End Class