轮询Datagrid btw 2个搜索日期 [英] Polulating a Datagrid btw 2 Dates Searched

问题描述

Private Sub searchButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles searchButton.Click
       Dim con As New SqlConnection(connectionString)
       con.Open()
       sql = "SELECT * FROM Teachers WHERE DateOfEmployment BETWEEN " &DateTimePicker1.Value.ToShortDateString & " AND  " & DateTimePicker2.Value.ToShortDateString & " "
       Dim cmd As New SqlCommand(sql, con)
       Dim objDataAdapter As New SqlDataAdapter(cmd)
       Dim objDataSet As New DataSet
       objDataAdapter.Fill(objDataSet, "Teachers")                 

       DataGridView1.DataSource = objDataSet
       DataGridView1.DataMember = "Teachers"
       DataGridView1.AutoGenerateColumns = True
   End Sub

在行上:objDataAdapter.Fill(objDataSet, "Teachers")
错误说"操作符类型冲突:日期与int不兼容"

请帮助我纠正代码，或者如果您的代码可以填充datagrid btw 2 date searhced，请输入，谢谢

on the line: objDataAdapter.Fill(objDataSet, "Teachers")
the error Says "Operand type clash: date is incompatible with int "

Please help me on how to correct the code, or if you have a code that can populate a datagrid btw 2 date searhced , Type it, Thanks

推荐答案

请输入datetime在单引号('')之间，例如在"2011年1月12日"和"2011年1月13日"之间

即

please put datetime between single quote ('') e.g BETWEEN ''12 JAN 2011'' AND ''13 JAN 2011''

i.e.

sql = "SELECT * FROM Teachers WHERE DateOfEmployment BETWEEN ''" &DateTimePicker1.Value.ToShortDateString & "'' AND ''" & DateTimePicker2.Value.ToShortDateString & "'' "

这篇关于轮询Datagrid btw 2个搜索日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！