主题：有语法错误?

Dim adapter As New SqlClient.SqlDataAdapter("sel ect * from [可用数量表] where 生产订单号码 = '" & scddhm & "' and 工单行号 = '" & gdhh & "' and 物料编码 = '" & wlbm & "' and 库位类别 = '" & kwlb & "' and 入库时间 >= #" & startdate & "#  and 入库时间 <= #" & enddate & "# ", cn)

sqlserver数据库的话，要把#改成'