Public Class Form1
Inherits System.Windows.Forms.Form
Dim objConnection As SqlConnection = New SqlConnection("server=bxg-zouyong;database=zpySQL11;user id=sa;password=")
Dim objDataAdapter As SqlDataAdapter = New SqlDataAdapter("SELECT N,CO,COO,O,Ar,H,HO from sheet3 ", objConnection)
Dim objDataSet As DataSet
Dim objDataView As DataView
Dim objCurrencyManager As CurrencyManagere
Private Sub FillDataSetAndView()
Try
objDataSet = New DataSet
objDataAdapter.Fill(objDataSet, "sheet3")
objDataView = New DataView(objDataSet.Tables("sheet3"))
objCurrencyManager = CType(Me.BindingContext(objDataView), CurrencyManager)
Catch sqlexception As SqlException
MessageBox.Show(sqlexception.Message)
End Try
End Sub
Private Sub BindingFields()
lblCO.DataBindings.Clear()
lblCO2.DataBindings.Clear()
lblO.DataBindings.Clear()
lblH.DataBindings.Clear()
lblAr.DataBindings.Clear()
lblHO.DataBindings.Clear()
lblN.DataBindings.Clear()
lblCO.DataBindings.Add("Text", objDataView, "CO")
lblCO2.DataBindings.Add("Text", objDataView, "COO")
lblO.DataBindings.Add("Text", objDataView, "O")
lblH.DataBindings.Add("Text", objDataView, "H")
lblAr.DataBindings.Add("Text", objDataView, "Ar")
lblHO.DataBindings.Add("Text", objDataView, "HO")
lblN.DataBindings.Add("Text", objDataView, "N")
End Sub
Private Sub ShowPosition()
lblPosition.Text = objCurrencyManager.Count & " of " & objCurrencyManager.Position + 1
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
FillDataSetAndView()
BindingFields()
ShowPosition()
End Sub
Private Sub btnBegin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBegin.Click
Dim i As Integer
For i = 1 To objCurrencyManager.Count
ShowPosition()
objCurrencyManager.Position += 1
Now.AddSeconds(6)
Next