Advertisement
Guest User

Untitled

a guest
Oct 7th, 2015
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.76 KB | None | 0 0
  1. Dim b as integer = 1
  2. cmd = New SqlCommand
  3. With cmd
  4. .Connection = connecti
  5. .CommandTimeout = 0
  6. .CommandText = "INSERT INTO HEZDDD(ID,Number,Dates) VALUES (@Id,@Number,@Dates)"
  7. With .Parameters
  8. .AddWithValue("@ID", NextId())
  9. .AddWithValue("@Dates", date.now)
  10.  
  11. If b = 1 Then
  12. .AddWithValue("@Number", 1)
  13. cmd.ExecuteNonQuery()
  14. End if
  15.  
  16. If b>10 Then
  17. .AddWithValue("@Number", 2)
  18. cmd.ExecuteNonQuery()
  19. End if
  20. End With
  21. End With
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement