[RESOLVED] how to query data in sql base on the date selected by a user in date time picker

[BONITO]

hi All,

I want to modify my program, how can i query data to sql server 2008 based on the date inputed by user in date time picker ?

see image:


i try code below but throw error : near ',',

  sqlCmd.CommandText = "WITH Src AS (SELECT station_no,CASE WHEN TestResult = 'ok' THEN 1 END AS ok,CASE WHEN TestResult = 'NG' " &
                "THEN 1 END AS NG,CASE WHEN TestResult = 'RR' THEN 1 END AS RR FROM Muscatel_MPCA_FCT1_LogData_T WHERE SQLDateTime >= '" + dtpFrom.Value.ToString("yyyy-mm-ddThh:mm:ss:tt") + "', AND SQLDateTime <= '" + dtpTo.Value.ToString("yyyy-mm-ddThh:mm:ss:tt") + "' and Station_No in (1,2,3,4,5,6))SELECT station_no, COUNT(ok) AS TotalOK,COUNT(NG) " &
                "AS TotalNG,COUNT(RR) AS TotalRR,COUNT(ok) + COUNT(NG) + COUNT(RR) AS Total FROM Src GROUP BY ROLLUP (Station_No)ORDER BY " &
                "Station_No DESC"

thanks in advance.