Hi,

If you want to select everything for a particular month use:

SELECT * FROM <TABLE_NAME> WHERE MONTH(Date_and_Time) = 6

Note you can also use the following:

DAY(Date_and_Time)

YEAR(Date_and_Time)

Hope this Helps,

A

Try:

Dim connString As String = "user id=username;password=pass; initial catalog=DBName; data source=ServerName"

Dim myConn As New SqlConnection(connString)

Abs