Charts SQL Statment

[Notorious Neo]

Hi people,

Please i need your assistant in a problem that i'm facing.
I'm creating a web page that contains a chart which uses an access databse
as a data source. i inserted a date\ timer picker control into the page in
order to allow the user to specify the date of the data shown in the chart.
but i couldn't find a way to pass the value of the date\time picker control
into my chart SQL statment that retrieve the data from the database

Example how i do it in VBA:

"SELECT * FROM tblSales WHERE [tblSales].[DeliveryDate] = #" &
DTPicker1.value & "#"

Thanks in advance,

 

[Alvin Bruney [MVP]]

If the datetime picker is a server control, and i believe it is, you will
have to push script out from the server to the client to load that data. or
write a client script function that accepts a date parameter and call that
client script from the server with the date time picker value.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin