Advertisement
nectonet

Untitled

Dec 14th, 2019
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
VB.NET 1.26 KB | None | 0 0
  1.   Private Sub Рассчитать_Click(sender As Object, e As EventArgs) Handles Рассчитать.Click
  2.         'On Error GoTo SaveErr
  3.  
  4.         Dim var As String
  5.         Dim DA As OleDbDataAdapter
  6.         Dim i As Integer
  7.             Dim num As Integer
  8.             Dim pos As Integer
  9.         Dim price As Integer
  10.         Dim n As Integer
  11.         Dim result As Integer
  12.  
  13.         n = ComboBox1.Text
  14.         var = "SELECT [Номер],[Количество],[Цена] FROM [Выручка]"
  15.  
  16.  
  17.         Dim connection = New OleDbConnection("Provider=Microsoft." & "Jet.OLEDB.4.0;Data Source=test.mdb")
  18.         connection.Open()
  19.         DA = New OleDbDataAdapter(var, connection)
  20.  
  21.         Dim sest As DataTable = New DataTable("Выручка")
  22.         sest.Columns.Add("Номер")
  23.         sest.Columns.Add("Количество")
  24.         sest.Columns.Add("Цена")
  25.         DA.Fill(sest)
  26.  
  27.         For i = 0 To n - 1
  28.             pos = sest.Rows(i)("Номер") + n
  29.             num = sest.Rows(i)("Количество")
  30.             price = sest.Rows(i)("Цена")
  31.             result = 0
  32.             result = num * price
  33.  
  34.         Next i
  35.         TextBox6.Text = result
  36.         connection.Close()
  37.         'SaveErr:
  38.         '        Exit Sub
  39.     End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement