Select ข้อมูลปีนี้ ออกมาไม่ได้ครับ ใน Web.config ผมใส่ code นี้ไว้ ..<globalization uiCulture="th-TH" culture="th-TH" /> .. เวลาในเครือง เป็น คศ.

SELECT YEAR(DATE_FROM) AS HAS_YEAR 
   ,COUNT(YEAR(DATE_FROM)) AS TOTAL_REC
FROM RESV ,ROOM 
WHERE  (RESV_STTS LIKE '%C') AND (RESV.ROOM_ID=ROOM.ROOM_ID)
GROUP BY YEAR(DATE_FROM)  

SELECT YEAR(DATE_FROM) AS HAS_YEAR 
   ,COUNT(YEAR(DATE_FROM)) AS TOTAL_REC
FROM RESV ,ROOM 
WHERE  (RESV_STTS LIKE '%C') AND (RESV.ROOM_ID=ROOM.ROOM_ID)
GROUP BY YEAR(DATE_FROM)  

  Dim connection As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"
        Dim sqlroom As String
        sqlroom = "SELECT RESV.*,ROOM.ROOM_NAME_THAI FROM RESV,ROOM WHERE (MONTH(DATE_FROM) = MONTH(GETDATE())) AND RESV_STTS LIKE '%C' AND RESV.ROOM_ID=ROOM.ROOM_ID"
        Dim conn As New SqlConnection(connection)
        conn.Open()
        Dim com As New SqlCommand(sqlroom, conn)
        Dim dr As SqlDataReader = com.ExecuteReader
        GridView1.DataSource = dr
        GridView1.DataBind()
        dr.Close()
        conn.Close()

WHERE

year(CURdate()) = year(DATE_FROM)