问个关于SQL语句的有关问题

问个关于SQL语句的问题
"SELECT * FROM [Record] WHERE [操作员]='@V1' AND [编号] BEWTEEN '@V2' AND '@V3'"
为什么总提示这个SQL语句有问题……我就是想查询俩条件同时成立的条目……
一个条件是确定的值，也就是@V1
还有一个条件是一个范围，也就是后边的betweenXXX……
谁告诉我该咋写……
我源代码是这样写的：

VB.NET code

 Public Function SearchAndReturnTimeAndUserBack(ByVal User As String, ByVal BeginTime As Long, ByVal EndTime As Long, ByVal DT As DataTable)
        Dim DB_Connection As New OleDb.OleDbConnection
        DB_Connection.ConnectionString = DB_ConStr()
        DB_Connection.Open()
        Dim DB_Command As New OleDb.OleDbCommand("SELECT * FROM [Record] WHERE [操作员]='@V1' AND [编号] BEWTEEN '@V2' AND '@V3'", DB_Connection)
        DB_Command.Parameters.AddWithValue("@V1", User)
        DB_Command.Parameters.AddWithValue("@V2", BeginTime)
        DB_Command.Parameters.AddWithValue("@V3", EndTime)
        Dim RS As New OleDb.OleDbDataAdapter
        RS.SelectCommand = DB_Command
        RS.Fill(DT)
        DB_Connection.Close()
        Return DT
    End Function

------解决方案--------------------
去掉单引号

问个关于SQL语句的有关问题

相关推荐