SELECT values between two selected DATES

Hot Topic

Server.Execute: How to transmit variables between VB and C#
SignedXML
Internals of remote object creation
Single .NET executable - linkers
Convert VB to C# for saving/reading an image from Access DB
Is there any tool is there to convert xml or xsl file in to fo?
Error when finishing Deployment Package Wizard
Receiving error: The root element is missing.
fast XML file scan......
Facing problem in passing a sqlparameter parameter through webservices

.NET Development

Is WS-ReliableMessaging implemented in .NET 2.0?
Proxy class doesn't desializer custom type
How OS Invokes CLR
MySql and SqlDataAdapter
access data from a Deleted DataRow
Access to a smartcard key
JIT: different code emitted for the same IL in the same process
is Web service developed in VS 2005 can be accessed from vs 2003
How to pass custom object to WebMethod?
How to get a free port ?

SELECT values between two selected DATES

Hi, was wondering if someone can help me, I trying to extract values from a database, but dates beween, 2 certain dates.

But, somehow, the values that's displayed, aren't the correct values.

I'm using access2003, with VB.NET. the data type af the 'adddate'-column are "date/time", and I'm using a DateTimePicker to alloy the user to select their own 2 dates.

this is the SELECT statement,

Dim comm As New OleDb.OleDbCommand("SELECT * from labour where adddate between " & fromdate & " AND " & todate, conn)

but easch time I try to run it, I get an error message, stating that "Missing operator

If someone can see something I'm not, please direct me.

Thanks

SJB

Answer this question

SELECT values between two selected DATES

  • CoderX

    Hi!

    You better use SQL parameters:

    "SELECT * FROM labour WHERE addDate BETWEEN @FromDate AND @ToDate"

    then you must add parameters @FromDate and @ToDate:

    comm.Parameters.AddWithValue("@FromDate", fromDate)

    comm.Parameters.AddWithValue("@ToDate", toDate)

    This is better because you don't need to care about dates to string formatting and parameters defend your code from SQL injection attacks.



  • SELECT values between two selected DATES
Answer this question