如果是文本型,楼主这样写也不对 "select * from a where shijian = '" + textbox1.text + "'" 建议用 "select * from a where shijian = @var_datetime" 然后在加个参数赋值比较好 MyCommand.Parameters.Add(New SqlParameter("@var_datetime", SqlDbType.Datetime)) MyCommand.Parameters("@var_datetime").Value = cdate(textbox1.text)
"select * from a where shijian = '" + textbox1.text + "'"
建议用 "select * from a where shijian = @var_datetime"
然后在加个参数赋值比较好
MyCommand.Parameters.Add(New SqlParameter("@var_datetime", SqlDbType.Datetime))
MyCommand.Parameters("@var_datetime").Value = cdate(textbox1.text)