date range problem

[girl]

i have this problem
m using dataset
dataadapter and dataset

i would like to select a date range using a datetimepicker or monthcalendar. the data in my database for date is 05/01/2007 where 05 is the month and 01 is the date.



sqladapter.SelectCommand = New OdbcCommand("SELECT * from " & table & "where date between @from_date and @to_date", conn)



sqladapter.SelectCommand.Parameters.Add("@from_dat e", OdbcType.date, "date").Value = Me.DateTimePicker1.Value.ToShortDateString


sqladapter.SelectCommand.Parameters.Add("@to_date" , OdbcType.date, "date").Value = Me.DateTimePicker2.Value.ToShortDateString


i tried these codes but when was prompt error " date type cannot convert to int"

how do i solve the prob?

[kenobewan]

Try converting to date before add them as parameter. HTH.

[Plater]

I always added dates as strings, SQL treated it correctly for date comparisons, insertions and updates

[girl]

thnx for all your reply...

kenobewan , you had mention to convert to date first meaning using convert function? or cast functions??

Plater, how do you display ur date in string? please teach me!

and lastly,

sqladapter.SelectCommand = New OdbcCommand("SELECT * from " & table & " where date between @from_date and @to_date", conn)

sqladapter.SelectCommand.Parameters.Add("@from_dat e", OdbcType.Date).Value = Me.MonthCalendar1.SelectionRange.Start.Date.ToStri ng
sqladapter.SelectCommand.Parameters.Add("@to_date" , OdbcType.Date).Value = Me.MonthCalendar2.SelectionRange.End.Date.ToString

sqladapter.Fill(ds, "" & table & "")

when i try this, it prompt me optional features to be implemented! ani ideas what error is this?

thnx!