let the user decide

[sase m via DotNetMonster.com]

I want to let the user decide for the date in the query. I want to sort the
database and put it in the datagrid.
I wrote this query :

SELECT *FROM table WHERE date BETWEEN #27/6/2005 20:20:30# and #28/6/2005
20:20:30#
And it works
But I want to put two MaskedBoxs and let the user decide for the date
I know how to do it with one variable but for two, please some one help me

 

[Lucas Tam]

I want to let the user decide for the date in the query. I want to
sort the database and put it in the datagrid.
I wrote this query :

SELECT *FROM table WHERE date BETWEEN #27/6/2005 20:20:30# and
#28/6/2005
20:20:30#
And it works
But I want to put two MaskedBoxs and let the user decide for the date
I know how to do it with one variable but for two, please some one
help me

FYI, take a look at SQLParameters... using SQLParameters will prevent
malcious data from being entered into the SQL command. It'll also allow you
to specify dynamic parameters easily.

 

[Cor Ligthert [MVP]]

Sase,

See this simple sample on our site (there is as well another parameter
sample)

http://www.windowsformsdatagridhelp.com/default.aspx?ID=886bba68-8a2f-4b99-8f66-7139b8970071

I hope this helps,

Cor