Access database

kawaljit singh

Hi everybody,
I am having problem with this query

I am using Access database and asp.net c# 2.0 to reterieve things using this query

select count(*) as itemTotal from schoolitemmap where (schoolid =1 and OrderDate = 8/3/2009) and itemId = 1
this query does not return nything.

(this date used in query is in m/d/y format as a string)

and m using date() function as default value for OrderDate field in database which is also in format (m/d/y)

Plase help .......
Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Roei Bar17y ago
well thats the easy part :-

just do the following

string selectedDate = Calander.SelectedValue;
selectedDate = selectedDate.Replace("/", "-");

and then :
selectedDate = "#" + selectedDate + "#" select count(*) as itemTotal from schoolitemmap where (schoolid =1 and OrderDate = OrderDateParam) and itemId = 1
dont forget to mark this as "Accepted Answer"
0
kawaljit singh17y ago
thanks for d reply..
but i hav to pass the value to orderdate through a textbox using ajax calender extender...............in which date is selected in mm/dd/yy format......

how do i convert this textbox value (date) to date format of access............
0
Roei Bar17y ago
well the problem is in the Access DateTime Object:

here is the working code
OrderDateParam = #2009-08-03# select count(*) as itemTotal from schoolitemmap where (schoolid =1 and OrderDate = OrderDateParam) and itemId = 1
if you liked this dont forget to mark "Accepted Answer"
0