Advertisement
Guest User

Untitled

a guest
Mar 29th, 2015
244
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. Dim adsa As Integer
  2. Dim ads As Integer
  3. For adsa = 0 To Label4.Text
  4. For ads = 0 To 4
  5. Dim row As String() = New String() {myDataTable.Rows(adsa).Item(ads).ToString()}
  6. Next
  7. Next
  8.  
  9. Call Connects()
  10. MySqlCmd = New MySqlCommand
  11. MySqlCmd.Connection = Myconnect
  12. MySqlCmd.CommandText = "SELECT Count(distinct os_number) AS os_number FROM order_sub o where isActive=0"
  13. MyDA = New MySqlDataAdapter
  14. myDataTable = New DataTable
  15. READER = MySqlCmd.ExecuteReader()
  16. MyDA.SelectCommand = MySqlCmd
  17. While READER.Read
  18. Dim prod = READER.GetInt32("os_number")
  19. Label4.Text = prod
  20. End While
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement