odbc adapter help!..

[girl]

hi all,

i need help in this area.
i had set up the connection with database using odbc adapter and it is working fine.

however i would like to select a range of data to display based on different range of dates.

how do i go about using parameterised data for my select statement

select * from database where (date>=?) and (date2<=?)
how do i declare the ? that is extracted from the month calendar??

thnx for helP!

 

[cjard]

i strongly advise against calling your database columns by the type name

your column called "date" -- change it, make it more meaningful


to answer your q:

Youre using .NET 2.0
You shouldnt need to be doing any of this yourself. Stop following old tutorials and follow something targeted at the framework youre using.

See the DW2 link in my signature, section on Creating a Form to Search Data