Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.10 KB | None | 0 0
  1. Dim Cola As List(Of Integer) = New List(Of Integer)()
  2.  
  3. Sub Main()
  4.  
  5. Dim theThread As New Threading.Thread(AddressOf Hilo)
  6. theThread.Start()
  7.  
  8. While True
  9. Console.Write("Numero:")
  10. Dim Value = Console.ReadLine()
  11. Cola.Add(Convert.ToInt32(Value))
  12.  
  13. Console.WriteLine()
  14. End While
  15.  
  16. End Sub
  17.  
  18. Public Sub Hilo()
  19.  
  20. Dim myConn = New SqlConnection("Data Source=LAPTOP-90HC7AEXSQLEXPRESS;Network Library=DBMSSOCN;Initial Catalog=TRAINING3;User ID=sa;Password=js;")
  21. myConn.Open()
  22.  
  23. Dim myCmd = myConn.CreateCommand
  24. myCmd.CommandText = "insert into Prueba(Entero) values(@Numero)"
  25.  
  26. While True
  27.  
  28. SyncLock Cola
  29.  
  30. Dim ToRemove As List(Of Integer) = New List(Of Integer)()
  31. For Each Value In Cola
  32. myCmd.Parameters.Clear()
  33. myCmd.Parameters.AddWithValue("@Numero", Value)
  34. myCmd.ExecuteNonQuery()
  35. ToRemove.Add(Value)
  36. Next
  37.  
  38. For Each Value In ToRemove
  39. Cola.Remove(Value)
  40. Next
  41.  
  42. End SyncLock
  43.  
  44. End While
  45. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement