Guest User

Untitled

a guest
Apr 24th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. Public Function teste (ByVal dtpInicio As String, ByVal dtpFim As String) As List(Of Teste)
  2. 'Consulta com a data dd/MM
  3. Dim retorno As New List(Of Teste)
  4. Try
  5. Conectar()
  6. cmd.CommandText = "SELECT * FROM NOME_TABELA WHERE NOME_COLUNA BETWEEN '" &
  7. dtpInicio.ToString("dd/MM/yyyy HH:mm:ss") & "' AND '" & dtpFim.ToString("dd/MM/yyyy HH:mm:ss") & "' ORDER BY NOME_COLUNA"
  8. dr = cmd.ExecuteReader
  9. While dr.Read
  10. retorno.Add(New Teste With {
  11. .NOME_COLUNA = dr(0)
  12. })
  13. End While
  14. Catch ex As Exception
  15. MsgBox(ex.Message)
  16. Finally
  17. Desconectar()
  18. End Try
  19.  
  20. 'Consulta com a data dd/MM
  21. Dim retorno As New List(Of Teste)
  22. Try
  23. Conectar()
  24. cmd.CommandText = "SELECT * FROM NOME_TABELA WHERE NOME_COLUNA BETWEEN '" &
  25. dtpInicio.ToString("MM/dd/yyyy") & "' AND '" & dtpFim.ToString("MM/dd/yyyy") & "' ORDER BY NOME_COLUNA"
  26. dr = cmd.ExecuteReader
  27. While dr.Read
  28. retorno.Add(New Teste With {
  29. .NOME_COLUNA = dr(0)
  30. })
  31. End While
  32. Catch ex As Exception
  33. MsgBox(ex.Message)
  34. Finally
  35. Desconectar()
  36. End Try
  37. Return retorno
  38. End Function
Add Comment
Please, Sign In to add comment