Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.37 KB | None | 0 0
  1. Dim sql As String = "SELECT * FROM Tasks WHERE DueDate < @DueDate"
  2. Using cn As New SqlConnection("Your connection string here"), _
  3. cmd As New SqlCommand(sql, cn)
  4. cmd.Parameters.Add("@DueDate", SqlDbType.DateTime).Value = DateTime.Now
  5. Dim reader As SqlDataReader = cmd.ExecuteReader
  6. While reader.Read
  7. Debug.WriteLine(reader(0))
  8. End While
  9. End Using
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement