Advertisement
Guest User

Untitled

a guest
Aug 20th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. If cb1.text = "Web Developer" Then
  2. l1.text = "5000 pesos"
  3.  
  4. OR
  5.  
  6. If cb1.text = "CEO" Then
  7. l1.text = "10000 pesos"
  8.  
  9. And so forth...
  10.  
  11. Public Class AddForm
  12. Dim qry As String
  13. Dim con As New MySqlConnection
  14. Dim cmd As New MySqlCommand
  15. Dim dr As MySqlDataReader
  16. Dim ds As New DataSet
  17. Dim da As New MySqlDataAdapter
  18.  
  19. Private Sub AddForm_Load(sender As Object, e As EventArgs) Handles MyBase.Load
  20. Try
  21. con = New MySqlConnection("server=localhost;username=root;password=;Persist Security Info=False;database=pms;")
  22. qry = "SELECT * FROM designations ORDER By design_id ASC"
  23. cmd = New MySqlCommand(qry, con)
  24. con.Open()
  25. dr = cmd.ExecuteReader
  26.  
  27. While dr.Read
  28. cb1.Items.Add(dr.Item(1))
  29.  
  30. If cb1.SelectedValue Then
  31. Dim money As String = dr.GetValue(2)
  32. l1.Text = "₱ " & money & ".00"
  33. End If
  34. End While
  35.  
  36. dr.Close()
  37. con.Close()
  38. Catch ex As Exception
  39. MessageBox.Show(ex.Message)
  40. Finally
  41. con.Dispose()
  42. End Try
  43. End Sub
  44. End Class
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement